APPS.PQP_GB_TP_PENSION_EXTRACTS dependencies on PQP_EXTRACT_ATTRIBUTES

Line 64: l_extract_attributes pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes%ROWTYPE;

60: ,p_trace_on IN VARCHAR2
61: )
62: IS
63: -- l_trace_options VARCHAR2(200);
64: l_extract_attributes pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes%ROWTYPE;
65: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
66:
67: BEGIN
68:

Line 87: OPEN pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes;

83:
84: -- Set the trace flag, but only the first time around
85: IF g_trace IS NULL THEN
86:
87: OPEN pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes;
88: FETCH pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes INTO l_extract_attributes;
89: CLOSE pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes;
90:
91: l_business_group_id := fnd_global.per_business_group_id;

Line 88: FETCH pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes INTO l_extract_attributes;

84: -- Set the trace flag, but only the first time around
85: IF g_trace IS NULL THEN
86:
87: OPEN pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes;
88: FETCH pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes INTO l_extract_attributes;
89: CLOSE pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes;
90:
91: l_business_group_id := fnd_global.per_business_group_id;
92:

Line 89: CLOSE pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes;

85: IF g_trace IS NULL THEN
86:
87: OPEN pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes;
88: FETCH pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes INTO l_extract_attributes;
89: CLOSE pqp_gb_tp_pension_extracts.csr_pqp_extract_attributes;
90:
91: l_business_group_id := fnd_global.per_business_group_id;
92:
93: BEGIN

Line 380: FROM pqp_extract_attributes pqea

376: l_year NUMBER; --RET2.a : New Variable
377:
378: CURSOR csr_last_run_details IS
379: SELECT MAX(TRUNC(rslt.eff_dt)) -- highest effective date of all prev runs
380: FROM pqp_extract_attributes pqea
381: ,ben_ext_rslt rslt
382: ,ben_ext_rslt_dtl rdtl
383: ,ben_ext_rcd drcd
384: WHERE pqea.ext_dfn_type = g_extract_type

Line 416: FROM pqp_extract_attributes pqea

412:
413:
414: CURSOR csr_next_run_details IS
415: SELECT MIN(TRUNC(rslt.eff_dt)) -- least effective date of all future runs
416: FROM pqp_extract_attributes pqea
417: ,ben_ext_rslt rslt
418: ,ben_ext_rslt_dtl rdtl
419: ,ben_ext_rcd drcd
420: WHERE pqea.ext_dfn_type = g_extract_type

Line 1348: debug('open csr_pqp_extract_attributes:', 60);

1344: ELSE
1345: debug ('*********this is a EXTRACT Process run***********', 50);
1346: END IF ;
1347:
1348: debug('open csr_pqp_extract_attributes:', 60);
1349:
1350: OPEN csr_pqp_extract_attributes;
1351: FETCH csr_pqp_extract_attributes INTO g_extract_type, g_extract_udt_name, l_udt_id;
1352: CLOSE csr_pqp_extract_attributes;

Line 1350: OPEN csr_pqp_extract_attributes;

1346: END IF ;
1347:
1348: debug('open csr_pqp_extract_attributes:', 60);
1349:
1350: OPEN csr_pqp_extract_attributes;
1351: FETCH csr_pqp_extract_attributes INTO g_extract_type, g_extract_udt_name, l_udt_id;
1352: CLOSE csr_pqp_extract_attributes;
1353:
1354: debug ('g_extract_type:'||g_extract_type, 70);

Line 1351: FETCH csr_pqp_extract_attributes INTO g_extract_type, g_extract_udt_name, l_udt_id;

1347:
1348: debug('open csr_pqp_extract_attributes:', 60);
1349:
1350: OPEN csr_pqp_extract_attributes;
1351: FETCH csr_pqp_extract_attributes INTO g_extract_type, g_extract_udt_name, l_udt_id;
1352: CLOSE csr_pqp_extract_attributes;
1353:
1354: debug ('g_extract_type:'||g_extract_type, 70);
1355: debug ('g_extract_udt_name:'||g_extract_udt_name);

Line 1352: CLOSE csr_pqp_extract_attributes;

1348: debug('open csr_pqp_extract_attributes:', 60);
1349:
1350: OPEN csr_pqp_extract_attributes;
1351: FETCH csr_pqp_extract_attributes INTO g_extract_type, g_extract_udt_name, l_udt_id;
1352: CLOSE csr_pqp_extract_attributes;
1353:
1354: debug ('g_extract_type:'||g_extract_type, 70);
1355: debug ('g_extract_udt_name:'||g_extract_udt_name);
1356: debug ('l_udt_id:'||l_udt_id);