DBA Data[Home] [Help]

APPS.WSM_JOBPURGE_GRP dependencies on WIP_WICTPG

Line 12: p_rec in wip_wictpg.purge_report_type,

8: ===========================================================================*/
9:
10:
11: procedure append_report(
12: p_rec in wip_wictpg.purge_report_type,
13: p_option in number
14: )
15: is
16: begin

Line 59: p_purge_rec in wip_wictpg.purge_report_type,

55: end append_report;
56:
57: procedure before_append_report(
58: p_option in number,
59: p_purge_rec in wip_wictpg.purge_report_type,
60: num_rows in number
61: )
62: is
63: x_purge_rec wip_wictpg.purge_report_type;

Line 63: x_purge_rec wip_wictpg.purge_report_type;

59: p_purge_rec in wip_wictpg.purge_report_type,
60: num_rows in number
61: )
62: is
63: x_purge_rec wip_wictpg.purge_report_type;
64: begin
65:
66: fnd_message.set_name('WIP', 'WIP_PURGE_ROWS');
67: fnd_message.set_token('NUMBER', to_char(num_rows));

Line 109: p_purge_request in wip_wictpg.get_purge_requests%rowtype,

105:
106: procedure delete_osfm_tables(
107: p_option in number,
108: p_group_id in number,
109: p_purge_request in wip_wictpg.get_purge_requests%rowtype,
110: -- ST Fix for bug 4918553 (Added the parameter p_detail_flag)
111: p_detail_flag IN BOOLEAN DEFAULT TRUE,
112: p_return_status out NOCOPY varchar2
113: )

Line 121: x_purge_rec wip_wictpg.purge_report_type;

117: x_wie_rows number := 0;
118: x_wsmti_rows number := 0;
119: x_wsji_rows number := 0;
120: x_wrji_rows number := 0;
121: x_purge_rec wip_wictpg.purge_report_type;
122: x_wip_entity_name VARCHAR2(240);
123: x_entity_type number;
124: x_header_id NUMBER;
125: x_request_id NUMBER;