APPS.QA_SEQUENCE_API dependencies on DBMS_SQL

Line 147: PROCEDURE get_all_rec_info_for_audit(p_plan_ids DBMS_SQL.number_table,

143: p_parent_plan_id NUMBER);
144:
145: PROCEDURE update_record(p_total_rec_count NUMBER);
146:
147: PROCEDURE get_all_rec_info_for_audit(p_plan_ids DBMS_SQL.number_table,
148: p_collection_ids DBMS_SQL.number_table,
149: p_occurrences DBMS_SQL.number_table);
150:
151: PROCEDURE audit_sequence_for_allchild(p_plan_id NUMBER,

Line 148: p_collection_ids DBMS_SQL.number_table,

144:
145: PROCEDURE update_record(p_total_rec_count NUMBER);
146:
147: PROCEDURE get_all_rec_info_for_audit(p_plan_ids DBMS_SQL.number_table,
148: p_collection_ids DBMS_SQL.number_table,
149: p_occurrences DBMS_SQL.number_table);
150:
151: PROCEDURE audit_sequence_for_allchild(p_plan_id NUMBER,
152: p_collection_id NUMBER,

Line 149: p_occurrences DBMS_SQL.number_table);

145: PROCEDURE update_record(p_total_rec_count NUMBER);
146:
147: PROCEDURE get_all_rec_info_for_audit(p_plan_ids DBMS_SQL.number_table,
148: p_collection_ids DBMS_SQL.number_table,
149: p_occurrences DBMS_SQL.number_table);
150:
151: PROCEDURE audit_sequence_for_allchild(p_plan_id NUMBER,
152: p_collection_id NUMBER,
153: p_occurrence NUMBER);

Line 2459: l_child_plan_ids DBMS_SQL.number_table;

2455: p_collection_id NUMBER,
2456: p_occurrence NUMBER,
2457: p_enabled_flag VARCHAR2) IS
2458:
2459: l_child_plan_ids DBMS_SQL.number_table;
2460: l_child_collection_ids DBMS_SQL.number_table;
2461: l_child_occurrences DBMS_SQL.number_table;
2462:
2463: l_status VARCHAR2(1);

Line 2460: l_child_collection_ids DBMS_SQL.number_table;

2456: p_occurrence NUMBER,
2457: p_enabled_flag VARCHAR2) IS
2458:
2459: l_child_plan_ids DBMS_SQL.number_table;
2460: l_child_collection_ids DBMS_SQL.number_table;
2461: l_child_occurrences DBMS_SQL.number_table;
2462:
2463: l_status VARCHAR2(1);
2464: BEGIN

Line 2461: l_child_occurrences DBMS_SQL.number_table;

2457: p_enabled_flag VARCHAR2) IS
2458:
2459: l_child_plan_ids DBMS_SQL.number_table;
2460: l_child_collection_ids DBMS_SQL.number_table;
2461: l_child_occurrences DBMS_SQL.number_table;
2462:
2463: l_status VARCHAR2(1);
2464: BEGIN
2465: -- capture audit only if enabled child records are deleted.

Line 2498: PROCEDURE audit_sequence_values(p_plan_ids DBMS_SQL.number_table,

2494:
2495: END audit_sequence_values;
2496:
2497:
2498: PROCEDURE audit_sequence_values(p_plan_ids DBMS_SQL.number_table,
2499: p_collection_ids DBMS_SQL.number_table,
2500: p_occurrences DBMS_SQL.number_table,
2501: p_parent_plan_id NUMBER,
2502: p_parent_collection_id NUMBER,

Line 2499: p_collection_ids DBMS_SQL.number_table,

2495: END audit_sequence_values;
2496:
2497:
2498: PROCEDURE audit_sequence_values(p_plan_ids DBMS_SQL.number_table,
2499: p_collection_ids DBMS_SQL.number_table,
2500: p_occurrences DBMS_SQL.number_table,
2501: p_parent_plan_id NUMBER,
2502: p_parent_collection_id NUMBER,
2503: p_parent_occurrence NUMBER) IS

Line 2500: p_occurrences DBMS_SQL.number_table,

2496:
2497:
2498: PROCEDURE audit_sequence_values(p_plan_ids DBMS_SQL.number_table,
2499: p_collection_ids DBMS_SQL.number_table,
2500: p_occurrences DBMS_SQL.number_table,
2501: p_parent_plan_id NUMBER,
2502: p_parent_collection_id NUMBER,
2503: p_parent_occurrence NUMBER) IS
2504:

Line 2531: PROCEDURE get_all_rec_info_for_audit(p_plan_ids DBMS_SQL.number_table,

2527: WHEN OTHERS THEN
2528: Raise;
2529: END audit_sequence_values;
2530:
2531: PROCEDURE get_all_rec_info_for_audit(p_plan_ids DBMS_SQL.number_table,
2532: p_collection_ids DBMS_SQL.number_table,
2533: p_occurrences DBMS_SQL.number_table) IS
2534:
2535: -- This procedure is similar to create_recordgroup

Line 2532: p_collection_ids DBMS_SQL.number_table,

2528: Raise;
2529: END audit_sequence_values;
2530:
2531: PROCEDURE get_all_rec_info_for_audit(p_plan_ids DBMS_SQL.number_table,
2532: p_collection_ids DBMS_SQL.number_table,
2533: p_occurrences DBMS_SQL.number_table) IS
2534:
2535: -- This procedure is similar to create_recordgroup
2536: -- pack all the record information into collection

Line 2533: p_occurrences DBMS_SQL.number_table) IS

2529: END audit_sequence_values;
2530:
2531: PROCEDURE get_all_rec_info_for_audit(p_plan_ids DBMS_SQL.number_table,
2532: p_collection_ids DBMS_SQL.number_table,
2533: p_occurrences DBMS_SQL.number_table) IS
2534:
2535: -- This procedure is similar to create_recordgroup
2536: -- pack all the record information into collection
2537: