APPS.PQH_PQHEEO4_XMLP_PKG dependencies on DBMS_SQL

Line 98: SOURCE_CURSOR := DBMS_SQL.OPEN_CURSOR;

94: ,L_PT);
95: L_FRC := '(' || REPLACE(L_FR
96: ,','
97: ,''',''') || ')';
98: SOURCE_CURSOR := DBMS_SQL.OPEN_CURSOR;
99: L_QUERY_TEXT := 'Select count(1) l_ft_emp_count' || FROM_WHERE_CLAUSE || L_FT_EFFECTIVE_DATES || 'AND ass.employment_category in ' || L_FRC;
100: DBMS_SQL.PARSE(SOURCE_CURSOR
101: ,L_QUERY_TEXT
102: ,2);

Line 100: DBMS_SQL.PARSE(SOURCE_CURSOR

96: ,','
97: ,''',''') || ')';
98: SOURCE_CURSOR := DBMS_SQL.OPEN_CURSOR;
99: L_QUERY_TEXT := 'Select count(1) l_ft_emp_count' || FROM_WHERE_CLAUSE || L_FT_EFFECTIVE_DATES || 'AND ass.employment_category in ' || L_FRC;
100: DBMS_SQL.PARSE(SOURCE_CURSOR
101: ,L_QUERY_TEXT
102: ,2);
103: DBMS_SQL.DEFINE_COLUMN(SOURCE_CURSOR
104: ,1

Line 103: DBMS_SQL.DEFINE_COLUMN(SOURCE_CURSOR

99: L_QUERY_TEXT := 'Select count(1) l_ft_emp_count' || FROM_WHERE_CLAUSE || L_FT_EFFECTIVE_DATES || 'AND ass.employment_category in ' || L_FRC;
100: DBMS_SQL.PARSE(SOURCE_CURSOR
101: ,L_QUERY_TEXT
102: ,2);
103: DBMS_SQL.DEFINE_COLUMN(SOURCE_CURSOR
104: ,1
105: ,L_FT_EMP_COUNT);
106: ROWS_PROCESSED := DBMS_SQL.EXECUTE(SOURCE_CURSOR);
107: IF DBMS_SQL.FETCH_ROWS(SOURCE_CURSOR) > 0 THEN

Line 106: ROWS_PROCESSED := DBMS_SQL.EXECUTE(SOURCE_CURSOR);

102: ,2);
103: DBMS_SQL.DEFINE_COLUMN(SOURCE_CURSOR
104: ,1
105: ,L_FT_EMP_COUNT);
106: ROWS_PROCESSED := DBMS_SQL.EXECUTE(SOURCE_CURSOR);
107: IF DBMS_SQL.FETCH_ROWS(SOURCE_CURSOR) > 0 THEN
108: DBMS_SQL.COLUMN_VALUE(SOURCE_CURSOR
109: ,1
110: ,L_FT_EMP_COUNT);

Line 107: IF DBMS_SQL.FETCH_ROWS(SOURCE_CURSOR) > 0 THEN

103: DBMS_SQL.DEFINE_COLUMN(SOURCE_CURSOR
104: ,1
105: ,L_FT_EMP_COUNT);
106: ROWS_PROCESSED := DBMS_SQL.EXECUTE(SOURCE_CURSOR);
107: IF DBMS_SQL.FETCH_ROWS(SOURCE_CURSOR) > 0 THEN
108: DBMS_SQL.COLUMN_VALUE(SOURCE_CURSOR
109: ,1
110: ,L_FT_EMP_COUNT);
111: END IF;

Line 108: DBMS_SQL.COLUMN_VALUE(SOURCE_CURSOR

104: ,1
105: ,L_FT_EMP_COUNT);
106: ROWS_PROCESSED := DBMS_SQL.EXECUTE(SOURCE_CURSOR);
107: IF DBMS_SQL.FETCH_ROWS(SOURCE_CURSOR) > 0 THEN
108: DBMS_SQL.COLUMN_VALUE(SOURCE_CURSOR
109: ,1
110: ,L_FT_EMP_COUNT);
111: END IF;
112: DBMS_SQL.CLOSE_CURSOR(SOURCE_CURSOR);

Line 112: DBMS_SQL.CLOSE_CURSOR(SOURCE_CURSOR);

108: DBMS_SQL.COLUMN_VALUE(SOURCE_CURSOR
109: ,1
110: ,L_FT_EMP_COUNT);
111: END IF;
112: DBMS_SQL.CLOSE_CURSOR(SOURCE_CURSOR);
113: SOURCE_CURSOR := DBMS_SQL.OPEN_CURSOR;
114: L_QUERY_TEXT := 'Select job.job_information7 l_function_code,
115: count(1) l_function_count ' || FROM_WHERE_CLAUSE || L_FT_EFFECTIVE_DATES || ' group by job.job_information7 ';
116: DBMS_SQL.PARSE(SOURCE_CURSOR

Line 113: SOURCE_CURSOR := DBMS_SQL.OPEN_CURSOR;

109: ,1
110: ,L_FT_EMP_COUNT);
111: END IF;
112: DBMS_SQL.CLOSE_CURSOR(SOURCE_CURSOR);
113: SOURCE_CURSOR := DBMS_SQL.OPEN_CURSOR;
114: L_QUERY_TEXT := 'Select job.job_information7 l_function_code,
115: count(1) l_function_count ' || FROM_WHERE_CLAUSE || L_FT_EFFECTIVE_DATES || ' group by job.job_information7 ';
116: DBMS_SQL.PARSE(SOURCE_CURSOR
117: ,L_QUERY_TEXT

Line 116: DBMS_SQL.PARSE(SOURCE_CURSOR

112: DBMS_SQL.CLOSE_CURSOR(SOURCE_CURSOR);
113: SOURCE_CURSOR := DBMS_SQL.OPEN_CURSOR;
114: L_QUERY_TEXT := 'Select job.job_information7 l_function_code,
115: count(1) l_function_count ' || FROM_WHERE_CLAUSE || L_FT_EFFECTIVE_DATES || ' group by job.job_information7 ';
116: DBMS_SQL.PARSE(SOURCE_CURSOR
117: ,L_QUERY_TEXT
118: ,2);
119: DBMS_SQL.DEFINE_COLUMN_CHAR(SOURCE_CURSOR
120: ,1

Line 119: DBMS_SQL.DEFINE_COLUMN_CHAR(SOURCE_CURSOR

115: count(1) l_function_count ' || FROM_WHERE_CLAUSE || L_FT_EFFECTIVE_DATES || ' group by job.job_information7 ';
116: DBMS_SQL.PARSE(SOURCE_CURSOR
117: ,L_QUERY_TEXT
118: ,2);
119: DBMS_SQL.DEFINE_COLUMN_CHAR(SOURCE_CURSOR
120: ,1
121: ,L_FUNCTION_CODE
122: ,10);
123: DBMS_SQL.DEFINE_COLUMN(SOURCE_CURSOR

Line 123: DBMS_SQL.DEFINE_COLUMN(SOURCE_CURSOR

119: DBMS_SQL.DEFINE_COLUMN_CHAR(SOURCE_CURSOR
120: ,1
121: ,L_FUNCTION_CODE
122: ,10);
123: DBMS_SQL.DEFINE_COLUMN(SOURCE_CURSOR
124: ,2
125: ,L_FUNCTION_COUNT);
126: ROWS_PROCESSED := DBMS_SQL.EXECUTE(SOURCE_CURSOR);
127: LOOP

Line 126: ROWS_PROCESSED := DBMS_SQL.EXECUTE(SOURCE_CURSOR);

122: ,10);
123: DBMS_SQL.DEFINE_COLUMN(SOURCE_CURSOR
124: ,2
125: ,L_FUNCTION_COUNT);
126: ROWS_PROCESSED := DBMS_SQL.EXECUTE(SOURCE_CURSOR);
127: LOOP
128: IF DBMS_SQL.FETCH_ROWS(SOURCE_CURSOR) > 0 THEN
129: DBMS_SQL.COLUMN_VALUE_CHAR(SOURCE_CURSOR
130: ,1

Line 128: IF DBMS_SQL.FETCH_ROWS(SOURCE_CURSOR) > 0 THEN

124: ,2
125: ,L_FUNCTION_COUNT);
126: ROWS_PROCESSED := DBMS_SQL.EXECUTE(SOURCE_CURSOR);
127: LOOP
128: IF DBMS_SQL.FETCH_ROWS(SOURCE_CURSOR) > 0 THEN
129: DBMS_SQL.COLUMN_VALUE_CHAR(SOURCE_CURSOR
130: ,1
131: ,L_FUNCTION_CODE);
132: DBMS_SQL.COLUMN_VALUE(SOURCE_CURSOR

Line 129: DBMS_SQL.COLUMN_VALUE_CHAR(SOURCE_CURSOR

125: ,L_FUNCTION_COUNT);
126: ROWS_PROCESSED := DBMS_SQL.EXECUTE(SOURCE_CURSOR);
127: LOOP
128: IF DBMS_SQL.FETCH_ROWS(SOURCE_CURSOR) > 0 THEN
129: DBMS_SQL.COLUMN_VALUE_CHAR(SOURCE_CURSOR
130: ,1
131: ,L_FUNCTION_CODE);
132: DBMS_SQL.COLUMN_VALUE(SOURCE_CURSOR
133: ,2

Line 132: DBMS_SQL.COLUMN_VALUE(SOURCE_CURSOR

128: IF DBMS_SQL.FETCH_ROWS(SOURCE_CURSOR) > 0 THEN
129: DBMS_SQL.COLUMN_VALUE_CHAR(SOURCE_CURSOR
130: ,1
131: ,L_FUNCTION_CODE);
132: DBMS_SQL.COLUMN_VALUE(SOURCE_CURSOR
133: ,2
134: ,L_FUNCTION_COUNT);
135: L_FUNCTION_CODE := RTRIM(L_FUNCTION_CODE);
136: IF (L_FT_EMP_COUNT > P_BPT_FT_EMP_COUNT AND L_ROW_COUNT <= 14) OR (L_FT_EMP_COUNT < P_BPT_FT_EMP_COUNT AND L_FUNCTION_COUNT > P_BPT_EMP_COUNT_FUNC) THEN

Line 151: DBMS_SQL.CLOSE_CURSOR(SOURCE_CURSOR);

147: ELSE
148: EXIT;
149: END IF;
150: END LOOP;
151: DBMS_SQL.CLOSE_CURSOR(SOURCE_CURSOR);
152: IF (L_FT_EMP_COUNT > P_BPT_FT_EMP_COUNT) THEN
153: P_EEO4_QUERY := 'SELECT job.job_information7 Job_function_code,
154: PQH_PQHEEO4_XMLP_PKG.CP_1_P CP_1,
155: PQH_PQHEEO4_XMLP_PKG.CF_TOTAL_TITLEFORMULA0005(DECODE(pqh_employment_category.identify_empl_category(ass.employment_category,' || L_FR || ',' || L_FT || ',' || L_PR || ',' || L_PT || '),