APPS.PQP_GB_CPX_EXTRACT_FUNCTIONS dependencies on PQP_EXTRACT_ATTRIBUTES

Line 94: l_extract_attributes csr_pqp_extract_attributes%ROWTYPE;

90: -- ----------------------------------------------------------------------------
91:
92: PROCEDURE debug_enter (p_proc_name IN VARCHAR2, p_trace_on IN VARCHAR2)
93: IS
94: l_extract_attributes csr_pqp_extract_attributes%ROWTYPE;
95: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
96: BEGIN
97: IF g_nested_level = 0
98: THEN -- swtich tracing on/off at the top level only

Line 102: OPEN csr_pqp_extract_attributes;

98: THEN -- swtich tracing on/off at the top level only
99: -- Set the trace flag, but only the first time around
100: IF g_trace IS NULL
101: THEN
102: OPEN csr_pqp_extract_attributes;
103: FETCH csr_pqp_extract_attributes INTO l_extract_attributes;
104: CLOSE csr_pqp_extract_attributes;
105: l_business_group_id := fnd_global.per_business_group_id;
106:

Line 103: FETCH csr_pqp_extract_attributes INTO l_extract_attributes;

99: -- Set the trace flag, but only the first time around
100: IF g_trace IS NULL
101: THEN
102: OPEN csr_pqp_extract_attributes;
103: FETCH csr_pqp_extract_attributes INTO l_extract_attributes;
104: CLOSE csr_pqp_extract_attributes;
105: l_business_group_id := fnd_global.per_business_group_id;
106:
107: BEGIN

Line 104: CLOSE csr_pqp_extract_attributes;

100: IF g_trace IS NULL
101: THEN
102: OPEN csr_pqp_extract_attributes;
103: FETCH csr_pqp_extract_attributes INTO l_extract_attributes;
104: CLOSE csr_pqp_extract_attributes;
105: l_business_group_id := fnd_global.per_business_group_id;
106:
107: BEGIN
108: g_trace :=

Line 195: FROM pqp_extract_attributes pqea,

191: IS
192: SELECT MAX (
193: TRUNC (rslt.eff_dt)
194: ) -- highest effective date of all prev runs
195: FROM pqp_extract_attributes pqea,
196: ben_ext_rslt rslt,
197: ben_ext_rslt_dtl rdtl
198: -- ben_ext_rcd drcd
199: WHERE pqea.ext_dfn_type = g_extract_type

Line 229: FROM pqp_extract_attributes pqea,

225: IS
226: SELECT MIN (
227: TRUNC (rslt.eff_dt)
228: ) -- least effective date of all future runs
229: FROM pqp_extract_attributes pqea,
230: ben_ext_rslt rslt,
231: ben_ext_rslt_dtl rdtl
232: -- ben_ext_rcd drcd
233: WHERE pqea.ext_dfn_type = g_extract_type

Line 906: OPEN csr_pqp_extract_attributes;

902: g_business_group_id := p_business_group_id;
903: DEBUG ( 'Effective Date: '
904: || p_effective_date);
905: g_effective_date := p_effective_date;
906: OPEN csr_pqp_extract_attributes;
907: FETCH csr_pqp_extract_attributes INTO g_extract_type, g_extract_udt_name;
908: CLOSE csr_pqp_extract_attributes;
909: --
910: -- Based on extract type set the effective dates accordingly

Line 907: FETCH csr_pqp_extract_attributes INTO g_extract_type, g_extract_udt_name;

903: DEBUG ( 'Effective Date: '
904: || p_effective_date);
905: g_effective_date := p_effective_date;
906: OPEN csr_pqp_extract_attributes;
907: FETCH csr_pqp_extract_attributes INTO g_extract_type, g_extract_udt_name;
908: CLOSE csr_pqp_extract_attributes;
909: --
910: -- Based on extract type set the effective dates accordingly
911: --

Line 908: CLOSE csr_pqp_extract_attributes;

904: || p_effective_date);
905: g_effective_date := p_effective_date;
906: OPEN csr_pqp_extract_attributes;
907: FETCH csr_pqp_extract_attributes INTO g_extract_type, g_extract_udt_name;
908: CLOSE csr_pqp_extract_attributes;
909: --
910: -- Based on extract type set the effective dates accordingly
911: --
912: