APPS.CN_SCA_CREDITS_BATCH_PUB dependencies on CN_SCA_CREDITS_BATCH_PUB

Line 1: PACKAGE BODY cn_sca_credits_batch_pub AS

1: PACKAGE BODY cn_sca_credits_batch_pub AS
2: -- $Header: cnpscabb.pls 120.27 2010/10/29 06:22:47 ppillai ship $
3: -- +======================================================================+
4: -- | Copyright (c) 1994 Oracle Corporation |
5: -- | Redwood Shores, California, USA |

Line 10: -- CN_SCA_CREDITS_BATCH_PUB

6: -- | All rights reserved. |
7: -- +======================================================================+
8: --
9: -- Package Name
10: -- CN_SCA_CREDITS_BATCH_PUB
11: -- Purpose
12: -- Package Body to process the Sales Credit Allocations
13: -- Add the flow diagram here.
14: -- History

Line 22: g_pkg_name CONSTANT VARCHAR2(30) := 'CN_SCA_CREDITS_BATCH_PUB';

18: --
19: -- Added fnd_request.set_org_id
20: -- call in conc_submit proc
21: --
22: g_pkg_name CONSTANT VARCHAR2(30) := 'CN_SCA_CREDITS_BATCH_PUB';
23: g_file_name CONSTANT VARCHAR2(12) := 'cnpscabb.pls';
24: no_trx EXCEPTION;
25: conc_fail EXCEPTION;
26: api_call_failed EXCEPTION;

Line 260: cn_sca_credits_batch_pub.conc_submit

256: || 'physical_rec.sca_process_batch_id = '
257: || physical_rec.sca_process_batch_id
258: );
259: debugmsg('SCA : Conc_Dispatch : call SCA_BATCH_RUNNER');
260: cn_sca_credits_batch_pub.conc_submit
261: (
262: x_conc_program => 'CN_SCA_PROCESS_BATCH_RULES'
263: , x_parent_proc_audit_id => x_parent_proc_audit_id
264: , x_physical_batch_id => physical_rec.sca_process_batch_id

Line 778: cn_sca_credits_batch_pub.split_batches(l_logical_batch_id, l_start_date, l_end_date

774: --+
775: --+ Call this procedure to to find out the number of records and split
776: --+ them into multiple physical batches.
777: --+
778: cn_sca_credits_batch_pub.split_batches(l_logical_batch_id, l_start_date, l_end_date
779: , p_transaction_source, p_org_id, x_size);
780: COMMIT;
781:
782: IF (x_size = 0) THEN

Line 860: cn_sca_credits_batch_pub.conc_dispatch(

856: --+
857: --+ Once physical batches are created, this procedure assign each physical
858: --+ batch as a concurrent program
859: --+
860: cn_sca_credits_batch_pub.conc_dispatch(
861: x_parent_proc_audit_id => l_process_audit_id
862: , x_start_date => l_start_date
863: , x_end_date => l_end_date
864: , x_transaction_source => p_transaction_source

Line 1536: --, table ( cast ( cn_sca_credits_batch_pub.convert_to_table()

1532: WHERE ccla.comm_lines_api_id = p_trans_object_id_tbl(i)
1533: AND ccla.org_id = p_org_id
1534: AND p_del_flag_tbl(i) <> 'Y';
1535:
1536: --, table ( cast ( cn_sca_credits_batch_pub.convert_to_table()
1537: -- as cn_sca_insert_tbl_type)) parent
1538: -- WHERE ccla.comm_lines_api_id = parent.trans_object_id
1539: -- AND ccla.org_id = p_org_id
1540: -- AND parent.del_flag <> 'Y';

Line 3567: END cn_sca_credits_batch_pub;

3563: RETURN g_sca_insert_tbl_type;
3564:
3565: END convert_to_table;
3566:
3567: END cn_sca_credits_batch_pub;