eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 2405: l_child_plan_ids DBMS_SQL.number_table;

2401: p_collection_id NUMBER,
2402: p_occurrence NUMBER,
2403: p_enabled_flag VARCHAR2) IS
2404:
2405: l_child_plan_ids DBMS_SQL.number_table;
2406: l_child_collection_ids DBMS_SQL.number_table;
2407: l_child_occurrences DBMS_SQL.number_table;
2408:
2409: l_status VARCHAR2(1);

Line 2406: l_child_collection_ids DBMS_SQL.number_table;

2402: p_occurrence NUMBER,
2403: p_enabled_flag VARCHAR2) IS
2404:
2405: l_child_plan_ids DBMS_SQL.number_table;
2406: l_child_collection_ids DBMS_SQL.number_table;
2407: l_child_occurrences DBMS_SQL.number_table;
2408:
2409: l_status VARCHAR2(1);
2410: BEGIN

Line 2407: l_child_occurrences DBMS_SQL.number_table;

2403: p_enabled_flag VARCHAR2) IS
2404:
2405: l_child_plan_ids DBMS_SQL.number_table;
2406: l_child_collection_ids DBMS_SQL.number_table;
2407: l_child_occurrences DBMS_SQL.number_table;
2408:
2409: l_status VARCHAR2(1);
2410: BEGIN
2411: -- capture audit only if enabled child records are deleted.

Line 2444: PROCEDURE audit_sequence_values(p_plan_ids DBMS_SQL.number_table,

2440:
2441: END audit_sequence_values;
2442:
2443:
2444: PROCEDURE audit_sequence_values(p_plan_ids DBMS_SQL.number_table,
2445: p_collection_ids DBMS_SQL.number_table,
2446: p_occurrences DBMS_SQL.number_table,
2447: p_parent_plan_id NUMBER,
2448: p_parent_collection_id NUMBER,

Line 2445: p_collection_ids DBMS_SQL.number_table,

2441: END audit_sequence_values;
2442:
2443:
2444: PROCEDURE audit_sequence_values(p_plan_ids DBMS_SQL.number_table,
2445: p_collection_ids DBMS_SQL.number_table,
2446: p_occurrences DBMS_SQL.number_table,
2447: p_parent_plan_id NUMBER,
2448: p_parent_collection_id NUMBER,
2449: p_parent_occurrence NUMBER) IS

Line 2446: p_occurrences DBMS_SQL.number_table,

2442:
2443:
2444: PROCEDURE audit_sequence_values(p_plan_ids DBMS_SQL.number_table,
2445: p_collection_ids DBMS_SQL.number_table,
2446: p_occurrences DBMS_SQL.number_table,
2447: p_parent_plan_id NUMBER,
2448: p_parent_collection_id NUMBER,
2449: p_parent_occurrence NUMBER) IS
2450:

Line 2477: PROCEDURE get_all_rec_info_for_audit(p_plan_ids DBMS_SQL.number_table,

2473: WHEN OTHERS THEN
2474: Raise;
2475: END audit_sequence_values;
2476:
2477: PROCEDURE get_all_rec_info_for_audit(p_plan_ids DBMS_SQL.number_table,
2478: p_collection_ids DBMS_SQL.number_table,
2479: p_occurrences DBMS_SQL.number_table) IS
2480:
2481: -- This procedure is similar to create_recordgroup

Line 2478: p_collection_ids DBMS_SQL.number_table,

2474: Raise;
2475: END audit_sequence_values;
2476:
2477: PROCEDURE get_all_rec_info_for_audit(p_plan_ids DBMS_SQL.number_table,
2478: p_collection_ids DBMS_SQL.number_table,
2479: p_occurrences DBMS_SQL.number_table) IS
2480:
2481: -- This procedure is similar to create_recordgroup
2482: -- pack all the record information into collection

Line 2479: p_occurrences DBMS_SQL.number_table) IS

2475: END audit_sequence_values;
2476:
2477: PROCEDURE get_all_rec_info_for_audit(p_plan_ids DBMS_SQL.number_table,
2478: p_collection_ids DBMS_SQL.number_table,
2479: p_occurrences DBMS_SQL.number_table) IS
2480:
2481: -- This procedure is similar to create_recordgroup
2482: -- pack all the record information into collection
2483: