DBA Data[Home] [Help]

APPS.PJI_LAUNCH_UPP_MAIN dependencies on PJI_UTILS

Line 292: PJI_UTILS.SET_PARAMETER ('PJI_STAGE3_REQ_LUPPD', p_submit_uppd_during_lppd);

288: where name = 'PJI_STAGE3_REQ_LUPPD';
289: commit;
290:
291: IF p_submit_uppd_during_lppd = 'N' THEN
292: PJI_UTILS.SET_PARAMETER ('PJI_STAGE3_REQ_LUPPD', p_submit_uppd_during_lppd);
293: commit;
294: -- Need to check if any stage 3 program has been submitted and running. If so, error out.
295: Select count(*)
296: Into l_req_count

Line 681: application => PJI_UTILS.GET_PJI_SCHEMA_NAME , -- Application Name

677:
678: else
679: l_request_id := FND_REQUEST.SUBMIT_REQUEST
680: (
681: application => PJI_UTILS.GET_PJI_SCHEMA_NAME , -- Application Name
682: program => g_incr_disp_name, -- Program Name
683: sub_request => FALSE, -- Sub Request
684: argument1 => 'I', -- p_run_mode
685: argument2 => P_OPERATING_UNIT, -- p_operating_unit /* added for bug 9059519 */

Line 751: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,

747:
748: /* Code added for bug 8416116 starts */
749: if (mod(g_stat_count,10) = 0) then
750:
751: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
752: tabname => 'PJI_FP_XBS_ACCUM_F',
753: percent => 5,
754: degree => PJI_UTILS.GET_DEGREE_OF_PARALLELISM());
755:

Line 754: degree => PJI_UTILS.GET_DEGREE_OF_PARALLELISM());

750:
751: FND_STATS.GATHER_TABLE_STATS(ownname => PJI_UTILS.GET_PJI_SCHEMA_NAME,
752: tabname => 'PJI_FP_XBS_ACCUM_F',
753: percent => 5,
754: degree => PJI_UTILS.GET_DEGREE_OF_PARALLELISM());
755:
756: end if;
757: /* Code added for bug 8416116 ends */
758:

Line 2083: l_tolerance_amt := nvl(to_number(PJI_UTILS.GET_PARAMETER('PJI_TOLERANCE_AMT')),0);

2079: l_data_type := 'VAL_ACT_COST';
2080:
2081: end if;
2082:
2083: l_tolerance_amt := nvl(to_number(PJI_UTILS.GET_PARAMETER('PJI_TOLERANCE_AMT')),0);
2084:
2085: OPEN get_proj_cost;
2086: FETCH get_proj_cost bulk collect into v_project_id;
2087: