APPS.CN_SCA_WF_PKG dependencies on CN_SCA_HEADERS_INTERFACE

Line 36: FROM cn_sca_headers_interface g_headers,

32: UPDATE cn_sca_lines_output lines
33: SET allocation_percentage =
34: (SELECT ROUND(lines.allocation_percentage +
35: (100 - SUM(g_lines.allocation_percentage)),4)
36: FROM cn_sca_headers_interface g_headers,
37: cn_sca_lines_output g_lines
38: WHERE g_headers.sca_headers_interface_id =
39: lines.sca_headers_interface_id
40: AND g_headers.sca_headers_interface_id =

Line 52: FROM cn_sca_headers_interface headers

48: WHERE lines.revenue_type = G_REVENUE
49: AND lines.sca_headers_interface_id
50: BETWEEN p_start_header_id AND p_end_header_id
51: AND EXISTS (SELECT 1
52: FROM cn_sca_headers_interface headers
53: WHERE headers.process_status = G_REV_NOT_100
54: AND headers.sca_headers_interface_id =
55: lines.sca_headers_interface_id)
56: AND lines.sca_lines_output_id = (SELECT MIN(sca_lines_output_id)

Line 89: FROM cn_sca_headers_interface_gtt g_headers,

85: UPDATE cn_sca_lines_output_gtt lines
86: SET allocation_percentage =
87: (SELECT ROUND(lines.allocation_percentage +
88: (100 - SUM(g_lines.allocation_percentage)),4)
89: FROM cn_sca_headers_interface_gtt g_headers,
90: cn_sca_lines_output_gtt g_lines
91: WHERE g_headers.sca_headers_interface_id =
92: lines.sca_headers_interface_id
93: AND g_headers.sca_headers_interface_id =

Line 101: FROM cn_sca_headers_interface_gtt headers

97: GROUP BY g_headers.sca_headers_interface_id)
98: WHERE lines.revenue_type = G_REVENUE
99: AND lines.sca_batch_id = p_sca_batch_id
100: AND EXISTS (SELECT 1
101: FROM cn_sca_headers_interface_gtt headers
102: WHERE headers.process_status = G_REV_NOT_100
103: AND headers.sca_headers_interface_id =
104: lines.sca_headers_interface_id)
105: AND lines.sca_lines_output_id = (SELECT MIN(sca_lines_output_id)

Line 149: FROM cn_sca_headers_interface_gtt g_headers,

145: SET allocation_percentage =
146: (SELECT ROUND(lines.allocation_percentage +
147: (100 - SUM(g_lines.allocation_percentage))
148: / COUNT(*),4)
149: FROM cn_sca_headers_interface_gtt g_headers,
150: cn_sca_lines_output_gtt g_lines
151: WHERE g_headers.sca_headers_interface_id =
152: lines.sca_headers_interface_id
153: AND g_headers.sca_headers_interface_id =

Line 161: FROM cn_sca_headers_interface_gtt headers

157: GROUP BY g_headers.sca_headers_interface_id)
158: WHERE lines.revenue_type = G_REVENUE
159: AND lines.sca_batch_id = p_sca_batch_id
160: AND EXISTS (SELECT 1
161: FROM cn_sca_headers_interface_gtt headers
162: WHERE headers.process_status = G_REV_NOT_100
163: AND headers.sca_headers_interface_id =
164: lines.sca_headers_interface_id);
165:

Line 170: UPDATE cn_sca_headers_interface_gtt headers

166: -- second update to address possible rounding error
167: ONLINE_POST_DIST_UPDATE(p_sca_batch_id => p_sca_batch_id);
168:
169: -- update header status to ALLOCATED
170: UPDATE cn_sca_headers_interface_gtt headers
171: SET process_status = G_ALLOCATED
172: WHERE headers.process_status = G_REV_NOT_100
173: AND headers.sca_batch_id = p_sca_batch_id;
174:

Line 224: FROM cn_sca_headers_interface g_headers,

220: SET allocation_percentage =
221: (SELECT ROUND(lines.allocation_percentage +
222: (100 - SUM(g_lines.allocation_percentage))
223: / COUNT(*),4)
224: FROM cn_sca_headers_interface g_headers,
225: cn_sca_lines_output g_lines
226: WHERE g_headers.sca_headers_interface_id =
227: lines.sca_headers_interface_id
228: AND g_headers.sca_headers_interface_id =

Line 240: FROM cn_sca_headers_interface headers

236: WHERE lines.revenue_type = G_REVENUE
237: AND lines.sca_headers_interface_id
238: BETWEEN p_start_header_id AND p_end_header_id
239: AND EXISTS (SELECT 1
240: FROM cn_sca_headers_interface headers
241: WHERE headers.process_status = G_REV_NOT_100
242: AND headers.sca_headers_interface_id =
243: lines.sca_headers_interface_id);
244:

Line 252: UPDATE cn_sca_headers_interface headers

248: p_user_id => l_user_id,
249: p_login_id => l_login_id);
250:
251: -- update header status to ALLOCATED
252: UPDATE cn_sca_headers_interface headers
253: SET process_status = G_ALLOCATED,
254: last_updated_by = l_user_id,
255: last_update_date = SYSDATE,
256: last_update_login = l_login_id

Line 306: FROM cn_sca_headers_interface_gtt g_headers,

302: (SELECT ROUND(
303: lines.allocation_percentage + lines.allocation_percentage *
304: (100 - SUM(g_lines.allocation_percentage)) /
305: SUM(g_lines.allocation_percentage),4)
306: FROM cn_sca_headers_interface_gtt g_headers,
307: cn_sca_lines_output_gtt g_lines
308: WHERE g_headers.sca_headers_interface_id =
309: lines.sca_headers_interface_id
310: AND g_headers.sca_headers_interface_id =

Line 318: FROM cn_sca_headers_interface_gtt headers

314: GROUP BY g_headers.sca_headers_interface_id)
315: WHERE lines.revenue_type = G_REVENUE
316: AND lines.sca_batch_id = p_sca_batch_id
317: AND EXISTS (SELECT 1
318: FROM cn_sca_headers_interface_gtt headers
319: WHERE headers.process_status = G_REV_NOT_100
320: AND headers.sca_headers_interface_id =
321: lines.sca_headers_interface_id);
322:

Line 327: UPDATE cn_sca_headers_interface_gtt headers

323: -- second update to address possible rounding error
324: ONLINE_POST_DIST_UPDATE(p_sca_batch_id => p_sca_batch_id);
325:
326: -- update header status to ALLOCATED
327: UPDATE cn_sca_headers_interface_gtt headers
328: SET process_status = G_ALLOCATED
329: WHERE headers.process_status = G_REV_NOT_100
330: AND headers.sca_batch_id = p_sca_batch_id;
331:

Line 381: FROM cn_sca_headers_interface g_headers,

377: (SELECT ROUND(
378: lines.allocation_percentage + lines.allocation_percentage *
379: (100 - SUM(g_lines.allocation_percentage)) /
380: SUM(g_lines.allocation_percentage),4)
381: FROM cn_sca_headers_interface g_headers,
382: cn_sca_lines_output g_lines
383: WHERE g_headers.sca_headers_interface_id =
384: lines.sca_headers_interface_id
385: AND g_headers.sca_headers_interface_id =

Line 397: FROM cn_sca_headers_interface headers

393: WHERE lines.revenue_type = G_REVENUE
394: AND lines.sca_headers_interface_id
395: BETWEEN p_start_header_id AND p_end_header_id
396: AND EXISTS (SELECT 1
397: FROM cn_sca_headers_interface headers
398: WHERE headers.process_status = G_REV_NOT_100
399: AND headers.sca_headers_interface_id =
400: lines.sca_headers_interface_id);
401:

Line 409: UPDATE cn_sca_headers_interface headers

405: p_user_id => l_user_id,
406: p_login_id => l_login_id);
407:
408: -- update header status to ALLOCATED
409: UPDATE cn_sca_headers_interface headers
410: SET process_status = G_ALLOCATED,
411: last_updated_by = l_user_id,
412: last_update_date = SYSDATE,
413: last_update_login = l_login_id

Line 587: FROM cn_sca_headers_interface_gtt shig

583: BEGIN
584: -- get trx_source
585: SELECT shig.transaction_source
586: INTO l_trxSrc
587: FROM cn_sca_headers_interface_gtt shig
588: WHERE shig.sca_batch_id = p_sca_batch_id
589: AND ROWNUM = 1;
590:
591: -- if not found, raise exception