DBA Data[Home] [Help]

APPS.INVCIINT dependencies on FND_GLOBAL

Line 24: IF fnd_global.conc_program_id <> -1 THEN

20:
21: BEGIN
22:
23: --Start 3537282 : Gather stats before running
24: IF fnd_global.conc_program_id <> -1 THEN
25:
26: SELECT count(*) INTO l_records
27: FROM mtl_ci_interface
28: WHERE process_flag = 1;

Line 285: nvl(Recinfo.Request_Id, fnd_global.conc_request_id),

281: Recinfo.Last_Updated_By,
282: Recinfo.Creation_Date,
283: Recinfo.Created_By,
284: Recinfo.Last_Update_Login,
285: nvl(Recinfo.Request_Id, fnd_global.conc_request_id),
286: nvl(Recinfo.Program_Application_Id, fnd_global.prog_appl_id),
287: nvl(Recinfo.Program_Id, fnd_global.conc_program_id),
288: nvl(Recinfo.Program_Update_Date, sysdate),
289: Delete_Record );

Line 286: nvl(Recinfo.Program_Application_Id, fnd_global.prog_appl_id),

282: Recinfo.Creation_Date,
283: Recinfo.Created_By,
284: Recinfo.Last_Update_Login,
285: nvl(Recinfo.Request_Id, fnd_global.conc_request_id),
286: nvl(Recinfo.Program_Application_Id, fnd_global.prog_appl_id),
287: nvl(Recinfo.Program_Id, fnd_global.conc_program_id),
288: nvl(Recinfo.Program_Update_Date, sysdate),
289: Delete_Record );
290: /*

Line 287: nvl(Recinfo.Program_Id, fnd_global.conc_program_id),

283: Recinfo.Created_By,
284: Recinfo.Last_Update_Login,
285: nvl(Recinfo.Request_Id, fnd_global.conc_request_id),
286: nvl(Recinfo.Program_Application_Id, fnd_global.prog_appl_id),
287: nvl(Recinfo.Program_Id, fnd_global.conc_program_id),
288: nvl(Recinfo.Program_Update_Date, sysdate),
289: Delete_Record );
290: /*
291: if L_Success = 1 then

Line 3065: IF fnd_global.conc_program_id <> -1 THEN

3061:
3062: BEGIN
3063:
3064: --Start 3537282 : Gather stats before running
3065: IF fnd_global.conc_program_id <> -1 THEN
3066: SELECT count(*) INTO l_records
3067: FROM mtl_ci_xrefs_interface
3068: WHERE process_flag = 1;
3069:

Line 3269: nvl(Recinfo2.Request_Id, fnd_global.conc_request_id),

3265: Recinfo2.Last_Updated_By,
3266: Recinfo2.Creation_Date,
3267: Recinfo2.Created_By,
3268: Recinfo2.Last_Update_Login,
3269: nvl(Recinfo2.Request_Id, fnd_global.conc_request_id),
3270: nvl(Recinfo2.Program_Application_Id, fnd_global.prog_appl_id),
3271: nvl(Recinfo2.Program_Id, fnd_global.conc_program_id),
3272: nvl(Recinfo2.Program_Update_Date, sysdate),
3273: Delete_Record);

Line 3270: nvl(Recinfo2.Program_Application_Id, fnd_global.prog_appl_id),

3266: Recinfo2.Creation_Date,
3267: Recinfo2.Created_By,
3268: Recinfo2.Last_Update_Login,
3269: nvl(Recinfo2.Request_Id, fnd_global.conc_request_id),
3270: nvl(Recinfo2.Program_Application_Id, fnd_global.prog_appl_id),
3271: nvl(Recinfo2.Program_Id, fnd_global.conc_program_id),
3272: nvl(Recinfo2.Program_Update_Date, sysdate),
3273: Delete_Record);
3274: /*

Line 3271: nvl(Recinfo2.Program_Id, fnd_global.conc_program_id),

3267: Recinfo2.Created_By,
3268: Recinfo2.Last_Update_Login,
3269: nvl(Recinfo2.Request_Id, fnd_global.conc_request_id),
3270: nvl(Recinfo2.Program_Application_Id, fnd_global.prog_appl_id),
3271: nvl(Recinfo2.Program_Id, fnd_global.conc_program_id),
3272: nvl(Recinfo2.Program_Update_Date, sysdate),
3273: Delete_Record);
3274: /*
3275: if L_Success = 1 then