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 3066: IF fnd_global.conc_program_id <> -1 THEN

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

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

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

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

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

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

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