APPS.MSC_PHUB_FILE_PKG dependencies on MSC_HUB_QUERY

Line 88: from msc_hub_query

84: msc_phub_util.log('msc_phub_file_pkg.prepare_transfer_tables_ui('||p_query_id||')');
85: l_transfer_id := msc_phub_pkg.create_staging_partitions(null, null);
86:
87: select count(*) into n
88: from msc_hub_query
89: where query_id=p_query_id and number1=1;
90:
91: if (n <> 1) then
92: retcode := 2;

Line 98: from msc_hub_query

94: raise e_prepare_transfer_tables_ui;
95: end if;
96:
97: select count(*) into n
98: from msc_hub_query
99: where query_id=p_query_id and number1=2 and blob1 is not null;
100:
101: if (n < 1) then
102: retcode := 2;

Line 135: from msc_hub_query

131: date1 plan_start_date,
132: date2 plan_cutoff_date,
133: sysdate plan_completion_date,
134: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate, fnd_global.login_id
135: from msc_hub_query
136: where query_id=p_query_id
137: and number1=1;
138:
139: insert into msc_apcc_upload_detail (

Line 153: from msc_hub_query

149: char3 file_name,
150: blob1 file_data,
151: date1 overwrite_after_date,
152: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate, fnd_global.login_id
153: from msc_hub_query
154: where query_id=p_query_id
155: and number1=2
156: and blob1 is not null;
157: commit;