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_PARENT_CHILD_PKG dependencies on DBMS_SQL

Line 59: PROCEDURE delete_child_rows( p_plan_ids IN dbms_sql.number_table,

55: PROCEDURE enable_and_fire_actions(p_collection_id NUMBER);
56:
57: -- Gapless Sequence Proj. rponnusa Wed Jul 30 04:52:45 PDT 2003
58: -- Changed procedure signature
59: PROCEDURE delete_child_rows( p_plan_ids IN dbms_sql.number_table,
60: p_collection_ids IN dbms_sql.number_table,
61: p_occurrences IN dbms_sql.number_table,
62: p_parent_plan_id NUMBER,
63: p_parent_collection_id NUMBER,

Line 60: p_collection_ids IN dbms_sql.number_table,

56:
57: -- Gapless Sequence Proj. rponnusa Wed Jul 30 04:52:45 PDT 2003
58: -- Changed procedure signature
59: PROCEDURE delete_child_rows( p_plan_ids IN dbms_sql.number_table,
60: p_collection_ids IN dbms_sql.number_table,
61: p_occurrences IN dbms_sql.number_table,
62: p_parent_plan_id NUMBER,
63: p_parent_collection_id NUMBER,
64: p_parent_occurrence NUMBER,

Line 61: p_occurrences IN dbms_sql.number_table,

57: -- Gapless Sequence Proj. rponnusa Wed Jul 30 04:52:45 PDT 2003
58: -- Changed procedure signature
59: PROCEDURE delete_child_rows( p_plan_ids IN dbms_sql.number_table,
60: p_collection_ids IN dbms_sql.number_table,
61: p_occurrences IN dbms_sql.number_table,
62: p_parent_plan_id NUMBER,
63: p_parent_collection_id NUMBER,
64: p_parent_occurrence NUMBER,
65: p_enabled_flag VARCHAR2);

Line 123: x_plan_ids OUT NOCOPY dbms_sql.number_table,

119: RETURN VARCHAR2;
120:
121: FUNCTION get_descendants(p_plan_id NUMBER, p_collection_id NUMBER,
122: p_occurrence NUMBER,
123: x_plan_ids OUT NOCOPY dbms_sql.number_table,
124: x_collection_ids OUT NOCOPY dbms_sql.number_table,
125: x_occurrences OUT NOCOPY dbms_sql.number_table)
126: RETURN VARCHAR2;
127:

Line 124: x_collection_ids OUT NOCOPY dbms_sql.number_table,

120:
121: FUNCTION get_descendants(p_plan_id NUMBER, p_collection_id NUMBER,
122: p_occurrence NUMBER,
123: x_plan_ids OUT NOCOPY dbms_sql.number_table,
124: x_collection_ids OUT NOCOPY dbms_sql.number_table,
125: x_occurrences OUT NOCOPY dbms_sql.number_table)
126: RETURN VARCHAR2;
127:
128: FUNCTION get_disabled_descendants(p_plan_id NUMBER,

Line 125: x_occurrences OUT NOCOPY dbms_sql.number_table)

121: FUNCTION get_descendants(p_plan_id NUMBER, p_collection_id NUMBER,
122: p_occurrence NUMBER,
123: x_plan_ids OUT NOCOPY dbms_sql.number_table,
124: x_collection_ids OUT NOCOPY dbms_sql.number_table,
125: x_occurrences OUT NOCOPY dbms_sql.number_table)
126: RETURN VARCHAR2;
127:
128: FUNCTION get_disabled_descendants(p_plan_id NUMBER,
129: p_collection_id NUMBER,

Line 132: x_plan_ids OUT NOCOPY dbms_sql.number_table,

128: FUNCTION get_disabled_descendants(p_plan_id NUMBER,
129: p_collection_id NUMBER,
130: p_occurrence NUMBER,
131: --p_enabled NUMBER,
132: x_plan_ids OUT NOCOPY dbms_sql.number_table,
133: x_collection_ids OUT NOCOPY dbms_sql.number_table,
134: x_occurrences OUT NOCOPY dbms_sql.number_table)
135: RETURN VARCHAR2;
136:

Line 133: x_collection_ids OUT NOCOPY dbms_sql.number_table,

129: p_collection_id NUMBER,
130: p_occurrence NUMBER,
131: --p_enabled NUMBER,
132: x_plan_ids OUT NOCOPY dbms_sql.number_table,
133: x_collection_ids OUT NOCOPY dbms_sql.number_table,
134: x_occurrences OUT NOCOPY dbms_sql.number_table)
135: RETURN VARCHAR2;
136:
137:

Line 134: x_occurrences OUT NOCOPY dbms_sql.number_table)

130: p_occurrence NUMBER,
131: --p_enabled NUMBER,
132: x_plan_ids OUT NOCOPY dbms_sql.number_table,
133: x_collection_ids OUT NOCOPY dbms_sql.number_table,
134: x_occurrences OUT NOCOPY dbms_sql.number_table)
135: RETURN VARCHAR2;
136:
137:
138: FUNCTION evaluate_child_lov_criteria(p_plan_id IN NUMBER,

Line 426: x_parent_plan_ids OUT NOCOPY dbms_sql.number_table,

422: --
423: FUNCTION get_ancestors( p_child_plan_id IN NUMBER,
424: p_child_occurrence IN NUMBER,
425: p_child_collection_id IN NUMBER,
426: x_parent_plan_ids OUT NOCOPY dbms_sql.number_table,
427: x_parent_collection_ids OUT NOCOPY dbms_sql.number_table,
428: x_parent_occurrences OUT NOCOPY dbms_sql.number_table)
429: RETURN VARCHAR2;
430:

Line 427: x_parent_collection_ids OUT NOCOPY dbms_sql.number_table,

423: FUNCTION get_ancestors( p_child_plan_id IN NUMBER,
424: p_child_occurrence IN NUMBER,
425: p_child_collection_id IN NUMBER,
426: x_parent_plan_ids OUT NOCOPY dbms_sql.number_table,
427: x_parent_collection_ids OUT NOCOPY dbms_sql.number_table,
428: x_parent_occurrences OUT NOCOPY dbms_sql.number_table)
429: RETURN VARCHAR2;
430:
431: -- Bug 5435657

Line 428: x_parent_occurrences OUT NOCOPY dbms_sql.number_table)

424: p_child_occurrence IN NUMBER,
425: p_child_collection_id IN NUMBER,
426: x_parent_plan_ids OUT NOCOPY dbms_sql.number_table,
427: x_parent_collection_ids OUT NOCOPY dbms_sql.number_table,
428: x_parent_occurrences OUT NOCOPY dbms_sql.number_table)
429: RETURN VARCHAR2;
430:
431: -- Bug 5435657
432: -- New procedure to update the aggregate values