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.JAI_AR_TCS_REP_PKG dependencies on JAI_RGM_REFS_ALL

Line 11: || for the table jai_rgm_refs_all

7: lv_member_name jai_cmn_debug_contexts.LOG_CONTEXT%TYPE;
8: lv_context jai_cmn_debug_contexts.LOG_CONTEXT%TYPE;
9: /****
10: || Get the primary key
11: || for the table jai_rgm_refs_all
12: *****/
13: CURSOR cur_get_trx_ref_id
14: IS
15: SELECT

Line 16: jai_rgm_refs_all_s1.nextval

12: *****/
13: CURSOR cur_get_trx_ref_id
14: IS
15: SELECT
16: jai_rgm_refs_all_s1.nextval
17: FROM
18: dual;
19:
20: /****

Line 34: CURSOR cur_get_parent_transaction ( cp_source_document_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ,

30:
31: /*
32: ||Get the parent reference_id of source document , This gives the last line of the source document. (needs to be discussed )
33: */
34: CURSOR cur_get_parent_transaction ( cp_source_document_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ,
35: cp_source_document_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE
36: )
37: IS
38: SELECT

Line 35: cp_source_document_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE

31: /*
32: ||Get the parent reference_id of source document , This gives the last line of the source document. (needs to be discussed )
33: */
34: CURSOR cur_get_parent_transaction ( cp_source_document_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ,
35: cp_source_document_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE
36: )
37: IS
38: SELECT
39: max(transaction_id) parent_transaction_id

Line 41: jai_rgm_refs_all

37: IS
38: SELECT
39: max(transaction_id) parent_transaction_id
40: FROM
41: jai_rgm_refs_all
42: WHERE
43: source_document_id = cp_source_document_id
44: AND source_document_type = cp_source_document_type;
45:

Line 52: jai_rgm_refs_all_s2.nextval

48: */
49: CURSOR cur_get_transaction_id
50: IS
51: SELECT
52: jai_rgm_refs_all_s2.nextval
53: FROM
54: dual;
55:
56: ln_event VARCHAR2(100); /*package private variable*/

Line 57: ln_transaction_id JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE ;

53: FROM
54: dual;
55:
56: ln_event VARCHAR2(100); /*package private variable*/
57: ln_transaction_id JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE ;
58:
59: PROCEDURE set_debug_context
60: IS
61: BEGIN

Line 626: lv_first_itm_class JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;

622: lv_member_name jai_cmn_debug_contexts.LOG_CONTEXT%TYPE;
623: lv_context jai_cmn_debug_contexts.LOG_CONTEXT%TYPE;
624:
625: ln_exists NUMBER ;
626: lv_first_itm_class JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;
627: lv_item_classification JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;
628:
629: lv_process_flag VARCHAR2(2) ;
630: lv_process_message VARCHAR2(4000) ;

Line 627: lv_item_classification JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;

623: lv_context jai_cmn_debug_contexts.LOG_CONTEXT%TYPE;
624:
625: ln_exists NUMBER ;
626: lv_first_itm_class JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;
627: lv_item_classification JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;
628:
629: lv_process_flag VARCHAR2(2) ;
630: lv_process_message VARCHAR2(4000) ;
631:

Line 854: jai_rgm_refs_all

850: IS
851: SELECT
852: '1'
853: FROM
854: jai_rgm_refs_all
855: WHERE
856: source_document_id = cp_customer_trx_id
857: AND settlement_id IS NOT NULL ;
858:

Line 927: ln_threshold_slab_id JAI_RGM_REFS_ALL.THRESHOLD_SLAB_ID%TYPE ;

923: lv_trx_type RA_CUST_TRX_TYPES_ALL.TYPE%TYPE ;
924: lv_doc_type VARCHAR2(100) ;
925: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;
926: lv_org_tan_no JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;
927: ln_threshold_slab_id JAI_RGM_REFS_ALL.THRESHOLD_SLAB_ID%TYPE ;
928: ln_exists NUMBER(2) ;
929: lv_first_itm_class JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;
930: lv_item_classification JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;
931: lv_process_flag VARCHAR2(2) ;

Line 929: lv_first_itm_class JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;

925: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;
926: lv_org_tan_no JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;
927: ln_threshold_slab_id JAI_RGM_REFS_ALL.THRESHOLD_SLAB_ID%TYPE ;
928: ln_exists NUMBER(2) ;
929: lv_first_itm_class JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;
930: lv_item_classification JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;
931: lv_process_flag VARCHAR2(2) ;
932: lv_process_message VARCHAR2(4000) ;
933: ln_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;

Line 930: lv_item_classification JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;

926: lv_org_tan_no JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;
927: ln_threshold_slab_id JAI_RGM_REFS_ALL.THRESHOLD_SLAB_ID%TYPE ;
928: ln_exists NUMBER(2) ;
929: lv_first_itm_class JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;
930: lv_item_classification JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;
931: lv_process_flag VARCHAR2(2) ;
932: lv_process_message VARCHAR2(4000) ;
933: ln_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;
934: ln_surcharge_cnt NUMBER(2) := 0 ;

Line 933: ln_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;

929: lv_first_itm_class JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;
930: lv_item_classification JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;
931: lv_process_flag VARCHAR2(2) ;
932: lv_process_message VARCHAR2(4000) ;
933: ln_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;
934: ln_surcharge_cnt NUMBER(2) := 0 ;
935: ld_source_doc_date RA_CUST_TRX_LINE_GL_DIST_ALL.GL_DATE%TYPE ;
936: BEGIN
937:

Line 1320: p_item_classification OUT NOCOPY JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ,

1316:
1317: PROCEDURE validate_app_unapp (
1318: p_araa IN AR_RECEIVABLE_APPLICATIONS_ALL%ROWTYPE ,
1319: p_document_type OUT NOCOPY VARCHAR2 ,
1320: p_item_classification OUT NOCOPY JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ,
1321: p_process_flag OUT NOCOPY VARCHAR2 ,
1322: p_process_message OUT NOCOPY VARCHAR2
1323: )
1324: AS

Line 1409: CURSOR cur_chk_parent_rec ( cp_applied_fr_doc_id JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE ,

1405:
1406: /*
1407: || Get the application details for the current unapplications from the repository
1408: */
1409: CURSOR cur_chk_parent_rec ( cp_applied_fr_doc_id JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE ,
1410: cp_applied_to_doc_id JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE
1411: )
1412: IS
1413: SELECT

Line 1410: cp_applied_to_doc_id JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE

1406: /*
1407: || Get the application details for the current unapplications from the repository
1408: */
1409: CURSOR cur_chk_parent_rec ( cp_applied_fr_doc_id JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE ,
1410: cp_applied_to_doc_id JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE
1411: )
1412: IS
1413: SELECT
1414: trx_ref_id ,

Line 1417: jai_rgm_refs_all

1413: SELECT
1414: trx_ref_id ,
1415: settlement_id
1416: FROM
1417: jai_rgm_refs_all
1418: WHERE
1419: app_from_document_id = cp_applied_fr_doc_id
1420: AND app_to_document_id = cp_applied_to_doc_id ;
1421:

Line 1888: CURSOR cur_chk_tcs_settlement ( cp_source_document_id jai_rgm_refs_all.source_document_id%TYPE ,

1884:
1885: /*
1886: ||Get the last record pertaining to the cash receipt confirmation
1887: */
1888: CURSOR cur_chk_tcs_settlement ( cp_source_document_id jai_rgm_refs_all.source_document_id%TYPE ,
1889: cp_source_document_type jai_rgm_refs_all.source_document_type%TYPE
1890: )
1891: IS
1892: SELECT

Line 1889: cp_source_document_type jai_rgm_refs_all.source_document_type%TYPE

1885: /*
1886: ||Get the last record pertaining to the cash receipt confirmation
1887: */
1888: CURSOR cur_chk_tcs_settlement ( cp_source_document_id jai_rgm_refs_all.source_document_id%TYPE ,
1889: cp_source_document_type jai_rgm_refs_all.source_document_type%TYPE
1890: )
1891: IS
1892: SELECT
1893: trx_ref_id ,

Line 1896: jai_rgm_refs_all a

1892: SELECT
1893: trx_ref_id ,
1894: settlement_id
1895: FROM
1896: jai_rgm_refs_all a
1897: WHERE
1898: trx_ref_id = ( SELECT
1899: max(trx_ref_id)
1900: FROM

Line 1901: jai_rgm_refs_all b

1897: WHERE
1898: trx_ref_id = ( SELECT
1899: max(trx_ref_id)
1900: FROM
1901: jai_rgm_refs_all b
1902: WHERE
1903: b.source_document_id = cp_source_document_id
1904: AND b.source_document_type = cp_source_document_type
1905: );

Line 1908: ln_settlement_id JAI_RGM_REFS_ALL.SETTLEMENT_ID%TYPE ;

1904: AND b.source_document_type = cp_source_document_type
1905: );
1906:
1907: ln_exists NUMBER(2) ;
1908: ln_settlement_id JAI_RGM_REFS_ALL.SETTLEMENT_ID%TYPE ;
1909: rec_cur_chk_tcs_settlement CUR_CHK_TCS_SETTLEMENT%ROWTYPE ;
1910: BEGIN
1911:
1912: /*########################################################################################################

Line 2121: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;

2117: ln_last_line_flag VARCHAR2(1) := jai_constants.no ;
2118: lv_process_flag VARCHAR2(2) ;
2119: lv_process_message VARCHAR2(2000) ;
2120: lv_document_type VARCHAR2(100) ;
2121: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;
2122: ln_apportion_factor NUMBER(3) ;
2123: lv_item_classification JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;
2124: ln_total_inv_amount RA_CUST_TRX_LINE_GL_DIST_ALL.AMOUNT%TYPE ;
2125: ld_document_date JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_DATE%TYPE ;

Line 2123: lv_item_classification JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;

2119: lv_process_message VARCHAR2(2000) ;
2120: lv_document_type VARCHAR2(100) ;
2121: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;
2122: ln_apportion_factor NUMBER(3) ;
2123: lv_item_classification JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;
2124: ln_total_inv_amount RA_CUST_TRX_LINE_GL_DIST_ALL.AMOUNT%TYPE ;
2125: ld_document_date JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_DATE%TYPE ;
2126: BEGIN
2127: /*########################################################################################################

Line 2125: ld_document_date JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_DATE%TYPE ;

2121: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;
2122: ln_apportion_factor NUMBER(3) ;
2123: lv_item_classification JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;
2124: ln_total_inv_amount RA_CUST_TRX_LINE_GL_DIST_ALL.AMOUNT%TYPE ;
2125: ld_document_date JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_DATE%TYPE ;
2126: BEGIN
2127: /*########################################################################################################
2128: || VARIABLES INITIALIZATION
2129: ########################################################################################################*/

Line 2415: CURSOR cur_copy_src_rcpt (cp_source_document_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE)

2411: /********
2412: || Get the details of the source receipt
2413: || from the repository
2414: ********/
2415: CURSOR cur_copy_src_rcpt (cp_source_document_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE)
2416: IS
2417: SELECT
2418: *
2419: FROM

Line 2420: jai_rgm_refs_all

2416: IS
2417: SELECT
2418: *
2419: FROM
2420: jai_rgm_refs_all
2421: WHERE
2422: source_document_id = cp_source_document_id;
2423:
2424: /********

Line 2428: CURSOR cur_copy_tax_rcpt_rev ( cp_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE )

2424: /********
2425: || Get the details of the source receipt taxes
2426: || from the repository
2427: ********/
2428: CURSOR cur_copy_tax_rcpt_rev ( cp_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE )
2429: IS
2430: SELECT
2431: *
2432: FROM

Line 2440: ln_rcpt_amount JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_AMT%TYPE ;

2436:
2437: p_araa AR_RECEIVABLE_APPLICATIONS_ALL%ROWTYPE ;
2438: rec_cur_get_cr_details CUR_GET_CR_DETAILS%ROWTYPE ;
2439: rec_cur_copy_src_rcpt CUR_COPY_SRC_RCPT%ROWTYPE ;
2440: ln_rcpt_amount JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_AMT%TYPE ;
2441: lv_process_flag VARCHAR2(2) ;
2442: lv_process_message VARCHAR2(2000) ;
2443: lv_document_type VARCHAR2(100) ;
2444: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;

Line 2444: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;

2440: ln_rcpt_amount JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_AMT%TYPE ;
2441: lv_process_flag VARCHAR2(2) ;
2442: lv_process_message VARCHAR2(2000) ;
2443: lv_document_type VARCHAR2(100) ;
2444: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;
2445: ln_apportion_factor NUMBER(3) ;
2446: ln_local_transaction_id JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE ;
2447: ln_parent_transaction_id JAI_RGM_REFS_ALL.PARENT_TRANSACTION_ID%TYPE ;
2448:

Line 2446: ln_local_transaction_id JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE ;

2442: lv_process_message VARCHAR2(2000) ;
2443: lv_document_type VARCHAR2(100) ;
2444: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;
2445: ln_apportion_factor NUMBER(3) ;
2446: ln_local_transaction_id JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE ;
2447: ln_parent_transaction_id JAI_RGM_REFS_ALL.PARENT_TRANSACTION_ID%TYPE ;
2448:
2449: BEGIN
2450:

Line 2447: ln_parent_transaction_id JAI_RGM_REFS_ALL.PARENT_TRANSACTION_ID%TYPE ;

2443: lv_document_type VARCHAR2(100) ;
2444: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;
2445: ln_apportion_factor NUMBER(3) ;
2446: ln_local_transaction_id JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE ;
2447: ln_parent_transaction_id JAI_RGM_REFS_ALL.PARENT_TRANSACTION_ID%TYPE ;
2448:
2449: BEGIN
2450:
2451: /*########################################################################################################

Line 2728: p_item_classification IN JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ,

2724:
2725:
2726: PROCEDURE process_applications ( p_araa IN AR_RECEIVABLE_APPLICATIONS_ALL%ROWTYPE ,
2727: p_document_type IN VARCHAR2 ,
2728: p_item_classification IN JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ,
2729: p_process_flag OUT NOCOPY VARCHAR2 ,
2730: p_process_message OUT NOCOPY VARCHAR2
2731: )
2732: IS

Line 2878: ln_app_fr_doc_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;

2874: AND jrttv.regime_code = jai_constants.tcs_regime;
2875:
2876: ln_app_fr_doc_amt NUMBER ;
2877: ld_app_fr_doc_date DATE ;
2878: ln_app_fr_doc_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;
2879: ln_app_fr_doc_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ;
2880: ln_app_fr_doc_table JAI_RGM_REFS_ALL.SOURCE_TABLE_NAME%TYPE ;
2881: ln_fr_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;
2882: ln_fr_party_id JAI_RGM_REFS_ALL.PARTY_ID%TYPE ;

Line 2879: ln_app_fr_doc_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ;

2875:
2876: ln_app_fr_doc_amt NUMBER ;
2877: ld_app_fr_doc_date DATE ;
2878: ln_app_fr_doc_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;
2879: ln_app_fr_doc_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ;
2880: ln_app_fr_doc_table JAI_RGM_REFS_ALL.SOURCE_TABLE_NAME%TYPE ;
2881: ln_fr_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;
2882: ln_fr_party_id JAI_RGM_REFS_ALL.PARTY_ID%TYPE ;
2883: ln_fr_party_site_id JAI_RGM_REFS_ALL.PARTY_SITE_ID%TYPE ;

Line 2880: ln_app_fr_doc_table JAI_RGM_REFS_ALL.SOURCE_TABLE_NAME%TYPE ;

2876: ln_app_fr_doc_amt NUMBER ;
2877: ld_app_fr_doc_date DATE ;
2878: ln_app_fr_doc_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;
2879: ln_app_fr_doc_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ;
2880: ln_app_fr_doc_table JAI_RGM_REFS_ALL.SOURCE_TABLE_NAME%TYPE ;
2881: ln_fr_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;
2882: ln_fr_party_id JAI_RGM_REFS_ALL.PARTY_ID%TYPE ;
2883: ln_fr_party_site_id JAI_RGM_REFS_ALL.PARTY_SITE_ID%TYPE ;
2884:

Line 2881: ln_fr_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;

2877: ld_app_fr_doc_date DATE ;
2878: ln_app_fr_doc_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;
2879: ln_app_fr_doc_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ;
2880: ln_app_fr_doc_table JAI_RGM_REFS_ALL.SOURCE_TABLE_NAME%TYPE ;
2881: ln_fr_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;
2882: ln_fr_party_id JAI_RGM_REFS_ALL.PARTY_ID%TYPE ;
2883: ln_fr_party_site_id JAI_RGM_REFS_ALL.PARTY_SITE_ID%TYPE ;
2884:
2885: ln_app_to_doc_amt NUMBER ;

Line 2882: ln_fr_party_id JAI_RGM_REFS_ALL.PARTY_ID%TYPE ;

2878: ln_app_fr_doc_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;
2879: ln_app_fr_doc_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ;
2880: ln_app_fr_doc_table JAI_RGM_REFS_ALL.SOURCE_TABLE_NAME%TYPE ;
2881: ln_fr_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;
2882: ln_fr_party_id JAI_RGM_REFS_ALL.PARTY_ID%TYPE ;
2883: ln_fr_party_site_id JAI_RGM_REFS_ALL.PARTY_SITE_ID%TYPE ;
2884:
2885: ln_app_to_doc_amt NUMBER ;
2886: ld_app_to_doc_date DATE ;

Line 2883: ln_fr_party_site_id JAI_RGM_REFS_ALL.PARTY_SITE_ID%TYPE ;

2879: ln_app_fr_doc_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ;
2880: ln_app_fr_doc_table JAI_RGM_REFS_ALL.SOURCE_TABLE_NAME%TYPE ;
2881: ln_fr_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;
2882: ln_fr_party_id JAI_RGM_REFS_ALL.PARTY_ID%TYPE ;
2883: ln_fr_party_site_id JAI_RGM_REFS_ALL.PARTY_SITE_ID%TYPE ;
2884:
2885: ln_app_to_doc_amt NUMBER ;
2886: ld_app_to_doc_date DATE ;
2887: ln_app_to_doc_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;

Line 2887: ln_app_to_doc_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;

2883: ln_fr_party_site_id JAI_RGM_REFS_ALL.PARTY_SITE_ID%TYPE ;
2884:
2885: ln_app_to_doc_amt NUMBER ;
2886: ld_app_to_doc_date DATE ;
2887: ln_app_to_doc_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;
2888: ln_app_to_doc_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ;
2889: ln_app_to_doc_table JAI_RGM_REFS_ALL.SOURCE_TABLE_NAME%TYPE ;
2890: ln_to_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;
2891: ln_to_party_id JAI_RGM_REFS_ALL.PARTY_ID%TYPE ;

Line 2888: ln_app_to_doc_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ;

2884:
2885: ln_app_to_doc_amt NUMBER ;
2886: ld_app_to_doc_date DATE ;
2887: ln_app_to_doc_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;
2888: ln_app_to_doc_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ;
2889: ln_app_to_doc_table JAI_RGM_REFS_ALL.SOURCE_TABLE_NAME%TYPE ;
2890: ln_to_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;
2891: ln_to_party_id JAI_RGM_REFS_ALL.PARTY_ID%TYPE ;
2892: ln_to_party_site_id JAI_RGM_REFS_ALL.PARTY_SITE_ID%TYPE ;

Line 2889: ln_app_to_doc_table JAI_RGM_REFS_ALL.SOURCE_TABLE_NAME%TYPE ;

2885: ln_app_to_doc_amt NUMBER ;
2886: ld_app_to_doc_date DATE ;
2887: ln_app_to_doc_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;
2888: ln_app_to_doc_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ;
2889: ln_app_to_doc_table JAI_RGM_REFS_ALL.SOURCE_TABLE_NAME%TYPE ;
2890: ln_to_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;
2891: ln_to_party_id JAI_RGM_REFS_ALL.PARTY_ID%TYPE ;
2892: ln_to_party_site_id JAI_RGM_REFS_ALL.PARTY_SITE_ID%TYPE ;
2893:

Line 2890: ln_to_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;

2886: ld_app_to_doc_date DATE ;
2887: ln_app_to_doc_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;
2888: ln_app_to_doc_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ;
2889: ln_app_to_doc_table JAI_RGM_REFS_ALL.SOURCE_TABLE_NAME%TYPE ;
2890: ln_to_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;
2891: ln_to_party_id JAI_RGM_REFS_ALL.PARTY_ID%TYPE ;
2892: ln_to_party_site_id JAI_RGM_REFS_ALL.PARTY_SITE_ID%TYPE ;
2893:
2894:

Line 2891: ln_to_party_id JAI_RGM_REFS_ALL.PARTY_ID%TYPE ;

2887: ln_app_to_doc_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;
2888: ln_app_to_doc_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ;
2889: ln_app_to_doc_table JAI_RGM_REFS_ALL.SOURCE_TABLE_NAME%TYPE ;
2890: ln_to_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;
2891: ln_to_party_id JAI_RGM_REFS_ALL.PARTY_ID%TYPE ;
2892: ln_to_party_site_id JAI_RGM_REFS_ALL.PARTY_SITE_ID%TYPE ;
2893:
2894:
2895: ln_app_amount NUMBER ;

Line 2892: ln_to_party_site_id JAI_RGM_REFS_ALL.PARTY_SITE_ID%TYPE ;

2888: ln_app_to_doc_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ;
2889: ln_app_to_doc_table JAI_RGM_REFS_ALL.SOURCE_TABLE_NAME%TYPE ;
2890: ln_to_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;
2891: ln_to_party_id JAI_RGM_REFS_ALL.PARTY_ID%TYPE ;
2892: ln_to_party_site_id JAI_RGM_REFS_ALL.PARTY_SITE_ID%TYPE ;
2893:
2894:
2895: ln_app_amount NUMBER ;
2896: ln_apportion_factor NUMBER ;

Line 2897: ln_app_ref_doc_id JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_ID%TYPE ;

2893:
2894:
2895: ln_app_amount NUMBER ;
2896: ln_apportion_factor NUMBER ;
2897: ln_app_ref_doc_id JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_ID%TYPE ;
2898: ln_app_ref_doc_type JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ;
2899: ln_app_ref_doc_table JAI_RGM_REFS_ALL.SOURCE_TABLE_NAME%TYPE ;
2900: ld_source_document_date JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_DATE%TYPE ;
2901: ln_parent_transaction_id JAI_RGM_REFS_ALL.parent_transaction_id%TYPE ;

Line 2898: ln_app_ref_doc_type JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ;

2894:
2895: ln_app_amount NUMBER ;
2896: ln_apportion_factor NUMBER ;
2897: ln_app_ref_doc_id JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_ID%TYPE ;
2898: ln_app_ref_doc_type JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ;
2899: ln_app_ref_doc_table JAI_RGM_REFS_ALL.SOURCE_TABLE_NAME%TYPE ;
2900: ld_source_document_date JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_DATE%TYPE ;
2901: ln_parent_transaction_id JAI_RGM_REFS_ALL.parent_transaction_id%TYPE ;
2902: ln_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;

Line 2899: ln_app_ref_doc_table JAI_RGM_REFS_ALL.SOURCE_TABLE_NAME%TYPE ;

2895: ln_app_amount NUMBER ;
2896: ln_apportion_factor NUMBER ;
2897: ln_app_ref_doc_id JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_ID%TYPE ;
2898: ln_app_ref_doc_type JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ;
2899: ln_app_ref_doc_table JAI_RGM_REFS_ALL.SOURCE_TABLE_NAME%TYPE ;
2900: ld_source_document_date JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_DATE%TYPE ;
2901: ln_parent_transaction_id JAI_RGM_REFS_ALL.parent_transaction_id%TYPE ;
2902: ln_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;
2903: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;

Line 2900: ld_source_document_date JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_DATE%TYPE ;

2896: ln_apportion_factor NUMBER ;
2897: ln_app_ref_doc_id JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_ID%TYPE ;
2898: ln_app_ref_doc_type JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ;
2899: ln_app_ref_doc_table JAI_RGM_REFS_ALL.SOURCE_TABLE_NAME%TYPE ;
2900: ld_source_document_date JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_DATE%TYPE ;
2901: ln_parent_transaction_id JAI_RGM_REFS_ALL.parent_transaction_id%TYPE ;
2902: ln_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;
2903: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;
2904: ln_party_id JAI_RGM_REFS_ALL.PARTY_ID%TYPE ;

Line 2901: ln_parent_transaction_id JAI_RGM_REFS_ALL.parent_transaction_id%TYPE ;

2897: ln_app_ref_doc_id JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_ID%TYPE ;
2898: ln_app_ref_doc_type JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ;
2899: ln_app_ref_doc_table JAI_RGM_REFS_ALL.SOURCE_TABLE_NAME%TYPE ;
2900: ld_source_document_date JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_DATE%TYPE ;
2901: ln_parent_transaction_id JAI_RGM_REFS_ALL.parent_transaction_id%TYPE ;
2902: ln_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;
2903: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;
2904: ln_party_id JAI_RGM_REFS_ALL.PARTY_ID%TYPE ;
2905: ln_party_site_id JAI_RGM_REFS_ALL.PARTY_SITE_ID%TYPE ;

Line 2902: ln_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;

2898: ln_app_ref_doc_type JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ;
2899: ln_app_ref_doc_table JAI_RGM_REFS_ALL.SOURCE_TABLE_NAME%TYPE ;
2900: ld_source_document_date JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_DATE%TYPE ;
2901: ln_parent_transaction_id JAI_RGM_REFS_ALL.parent_transaction_id%TYPE ;
2902: ln_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;
2903: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;
2904: ln_party_id JAI_RGM_REFS_ALL.PARTY_ID%TYPE ;
2905: ln_party_site_id JAI_RGM_REFS_ALL.PARTY_SITE_ID%TYPE ;
2906: ln_exchange_rate NUMBER ;

Line 2903: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;

2899: ln_app_ref_doc_table JAI_RGM_REFS_ALL.SOURCE_TABLE_NAME%TYPE ;
2900: ld_source_document_date JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_DATE%TYPE ;
2901: ln_parent_transaction_id JAI_RGM_REFS_ALL.parent_transaction_id%TYPE ;
2902: ln_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;
2903: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;
2904: ln_party_id JAI_RGM_REFS_ALL.PARTY_ID%TYPE ;
2905: ln_party_site_id JAI_RGM_REFS_ALL.PARTY_SITE_ID%TYPE ;
2906: ln_exchange_rate NUMBER ;
2907: rec_cur_get_app_to_det CUR_GET_APP_TO_DET%ROWTYPE ;

Line 2904: ln_party_id JAI_RGM_REFS_ALL.PARTY_ID%TYPE ;

2900: ld_source_document_date JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_DATE%TYPE ;
2901: ln_parent_transaction_id JAI_RGM_REFS_ALL.parent_transaction_id%TYPE ;
2902: ln_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;
2903: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;
2904: ln_party_id JAI_RGM_REFS_ALL.PARTY_ID%TYPE ;
2905: ln_party_site_id JAI_RGM_REFS_ALL.PARTY_SITE_ID%TYPE ;
2906: ln_exchange_rate NUMBER ;
2907: rec_cur_get_app_to_det CUR_GET_APP_TO_DET%ROWTYPE ;
2908: rec_cur_get_cr_details CUR_GET_CR_DETAILS%ROWTYPE ;

Line 2905: ln_party_site_id JAI_RGM_REFS_ALL.PARTY_SITE_ID%TYPE ;

2901: ln_parent_transaction_id JAI_RGM_REFS_ALL.parent_transaction_id%TYPE ;
2902: ln_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;
2903: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;
2904: ln_party_id JAI_RGM_REFS_ALL.PARTY_ID%TYPE ;
2905: ln_party_site_id JAI_RGM_REFS_ALL.PARTY_SITE_ID%TYPE ;
2906: ln_exchange_rate NUMBER ;
2907: rec_cur_get_app_to_det CUR_GET_APP_TO_DET%ROWTYPE ;
2908: rec_cur_get_cr_details CUR_GET_CR_DETAILS%ROWTYPE ;
2909: rec_cur_get_cm_details CUR_GET_CM_DETAILS%ROWTYPE ;

Line 3281: CURSOR cur_get_parent_trx ( cp_source_document_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE DEFAULT NULL ,

3277: ln_reg_id NUMBER;
3278: /*
3279: ||Get the parent record for an type of record
3280: */
3281: CURSOR cur_get_parent_trx ( cp_source_document_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE DEFAULT NULL ,
3282: cp_source_document_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ,
3283: cp_app_from_document_id JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE DEFAULT NULL ,
3284: cp_app_to_document_id JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE DEFAULT NULL
3285: )

Line 3282: cp_source_document_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ,

3278: /*
3279: ||Get the parent record for an type of record
3280: */
3281: CURSOR cur_get_parent_trx ( cp_source_document_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE DEFAULT NULL ,
3282: cp_source_document_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ,
3283: cp_app_from_document_id JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE DEFAULT NULL ,
3284: cp_app_to_document_id JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE DEFAULT NULL
3285: )
3286: IS

Line 3283: cp_app_from_document_id JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE DEFAULT NULL ,

3279: ||Get the parent record for an type of record
3280: */
3281: CURSOR cur_get_parent_trx ( cp_source_document_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE DEFAULT NULL ,
3282: cp_source_document_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ,
3283: cp_app_from_document_id JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE DEFAULT NULL ,
3284: cp_app_to_document_id JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE DEFAULT NULL
3285: )
3286: IS
3287: SELECT

Line 3284: cp_app_to_document_id JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE DEFAULT NULL

3280: */
3281: CURSOR cur_get_parent_trx ( cp_source_document_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE DEFAULT NULL ,
3282: cp_source_document_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ,
3283: cp_app_from_document_id JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE DEFAULT NULL ,
3284: cp_app_to_document_id JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE DEFAULT NULL
3285: )
3286: IS
3287: SELECT
3288: to_number(max(transaction_id)) parent_transaction_id

Line 3290: jai_rgm_refs_all

3286: IS
3287: SELECT
3288: to_number(max(transaction_id)) parent_transaction_id
3289: FROM
3290: jai_rgm_refs_all
3291: WHERE
3292: source_document_id = nvl(cp_source_document_id , source_document_id)
3293: AND source_document_type = cp_source_document_type
3294: AND app_from_document_id = nvl(app_from_document_id , app_from_document_id )

Line 3297: ln_new_document_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;

3293: AND source_document_type = cp_source_document_type
3294: AND app_from_document_id = nvl(app_from_document_id , app_from_document_id )
3295: AND app_to_document_id = nvl(app_to_document_id , app_to_document_id ) ;
3296:
3297: ln_new_document_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;
3298: ln_source_document_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;
3299: ld_new_document_date JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_DATE%TYPE ;
3300: lv_source_document_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ;
3301: ln_app_from_document_id JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE ;

Line 3298: ln_source_document_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;

3294: AND app_from_document_id = nvl(app_from_document_id , app_from_document_id )
3295: AND app_to_document_id = nvl(app_to_document_id , app_to_document_id ) ;
3296:
3297: ln_new_document_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;
3298: ln_source_document_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;
3299: ld_new_document_date JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_DATE%TYPE ;
3300: lv_source_document_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ;
3301: ln_app_from_document_id JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE ;
3302: ln_app_to_document_id JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE ;

Line 3299: ld_new_document_date JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_DATE%TYPE ;

3295: AND app_to_document_id = nvl(app_to_document_id , app_to_document_id ) ;
3296:
3297: ln_new_document_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;
3298: ln_source_document_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;
3299: ld_new_document_date JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_DATE%TYPE ;
3300: lv_source_document_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ;
3301: ln_app_from_document_id JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE ;
3302: ln_app_to_document_id JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE ;
3303: ln_parent_transaction_id JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE ;

Line 3300: lv_source_document_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ;

3296:
3297: ln_new_document_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;
3298: ln_source_document_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;
3299: ld_new_document_date JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_DATE%TYPE ;
3300: lv_source_document_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ;
3301: ln_app_from_document_id JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE ;
3302: ln_app_to_document_id JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE ;
3303: ln_parent_transaction_id JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE ;
3304: lv_process_flag VARCHAR2(2) ;

Line 3301: ln_app_from_document_id JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE ;

3297: ln_new_document_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;
3298: ln_source_document_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;
3299: ld_new_document_date JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_DATE%TYPE ;
3300: lv_source_document_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ;
3301: ln_app_from_document_id JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE ;
3302: ln_app_to_document_id JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE ;
3303: ln_parent_transaction_id JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE ;
3304: lv_process_flag VARCHAR2(2) ;
3305: lv_process_message VARCHAR2(2000) ;

Line 3302: ln_app_to_document_id JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE ;

3298: ln_source_document_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;
3299: ld_new_document_date JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_DATE%TYPE ;
3300: lv_source_document_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ;
3301: ln_app_from_document_id JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE ;
3302: ln_app_to_document_id JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE ;
3303: ln_parent_transaction_id JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE ;
3304: lv_process_flag VARCHAR2(2) ;
3305: lv_process_message VARCHAR2(2000) ;
3306:

Line 3303: ln_parent_transaction_id JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE ;

3299: ld_new_document_date JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_DATE%TYPE ;
3300: lv_source_document_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ;
3301: ln_app_from_document_id JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE ;
3302: ln_app_to_document_id JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE ;
3303: ln_parent_transaction_id JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE ;
3304: lv_process_flag VARCHAR2(2) ;
3305: lv_process_message VARCHAR2(2000) ;
3306:
3307: BEGIN

Line 3470: p_transaction_id IN JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE ,

3466: END process_unapp_rcpt_rev ;
3467:
3468:
3469: procedure insert_repository_references ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE DEFAULT NULL ,
3470: p_transaction_id IN JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE ,
3471: p_source_ref_document_id IN JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_ID%TYPE DEFAULT NULL ,
3472: p_source_ref_document_type IN JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ,
3473: p_app_from_document_id IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE DEFAULT NULL ,
3474: p_app_from_document_type IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_TYPE%TYPE DEFAULT NULL ,

Line 3471: p_source_ref_document_id IN JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_ID%TYPE DEFAULT NULL ,

3467:
3468:
3469: procedure insert_repository_references ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE DEFAULT NULL ,
3470: p_transaction_id IN JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE ,
3471: p_source_ref_document_id IN JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_ID%TYPE DEFAULT NULL ,
3472: p_source_ref_document_type IN JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ,
3473: p_app_from_document_id IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE DEFAULT NULL ,
3474: p_app_from_document_type IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_TYPE%TYPE DEFAULT NULL ,
3475: p_app_to_document_id IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE DEFAULT NULL ,

Line 3472: p_source_ref_document_type IN JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ,

3468:
3469: procedure insert_repository_references ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE DEFAULT NULL ,
3470: p_transaction_id IN JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE ,
3471: p_source_ref_document_id IN JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_ID%TYPE DEFAULT NULL ,
3472: p_source_ref_document_type IN JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ,
3473: p_app_from_document_id IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE DEFAULT NULL ,
3474: p_app_from_document_type IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_TYPE%TYPE DEFAULT NULL ,
3475: p_app_to_document_id IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE DEFAULT NULL ,
3476: p_app_to_document_type IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_TYPE%TYPE DEFAULT NULL ,

Line 3473: p_app_from_document_id IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE DEFAULT NULL ,

3469: procedure insert_repository_references ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE DEFAULT NULL ,
3470: p_transaction_id IN JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE ,
3471: p_source_ref_document_id IN JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_ID%TYPE DEFAULT NULL ,
3472: p_source_ref_document_type IN JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ,
3473: p_app_from_document_id IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE DEFAULT NULL ,
3474: p_app_from_document_type IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_TYPE%TYPE DEFAULT NULL ,
3475: p_app_to_document_id IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE DEFAULT NULL ,
3476: p_app_to_document_type IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_TYPE%TYPE DEFAULT NULL ,
3477: p_parent_transaction_id IN JAI_RGM_REFS_ALL.PARENT_TRANSACTION_ID%TYPE DEFAULT NULL ,

Line 3474: p_app_from_document_type IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_TYPE%TYPE DEFAULT NULL ,

3470: p_transaction_id IN JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE ,
3471: p_source_ref_document_id IN JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_ID%TYPE DEFAULT NULL ,
3472: p_source_ref_document_type IN JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ,
3473: p_app_from_document_id IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE DEFAULT NULL ,
3474: p_app_from_document_type IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_TYPE%TYPE DEFAULT NULL ,
3475: p_app_to_document_id IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE DEFAULT NULL ,
3476: p_app_to_document_type IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_TYPE%TYPE DEFAULT NULL ,
3477: p_parent_transaction_id IN JAI_RGM_REFS_ALL.PARENT_TRANSACTION_ID%TYPE DEFAULT NULL ,
3478: p_org_tan_no IN JAI_RGM_REFS_ALL.ORG_TAN_NO%TYPE DEFAULT NULL ,

Line 3475: p_app_to_document_id IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE DEFAULT NULL ,

3471: p_source_ref_document_id IN JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_ID%TYPE DEFAULT NULL ,
3472: p_source_ref_document_type IN JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ,
3473: p_app_from_document_id IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE DEFAULT NULL ,
3474: p_app_from_document_type IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_TYPE%TYPE DEFAULT NULL ,
3475: p_app_to_document_id IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE DEFAULT NULL ,
3476: p_app_to_document_type IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_TYPE%TYPE DEFAULT NULL ,
3477: p_parent_transaction_id IN JAI_RGM_REFS_ALL.PARENT_TRANSACTION_ID%TYPE DEFAULT NULL ,
3478: p_org_tan_no IN JAI_RGM_REFS_ALL.ORG_TAN_NO%TYPE DEFAULT NULL ,
3479: p_document_id IN NUMBER ,

Line 3476: p_app_to_document_type IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_TYPE%TYPE DEFAULT NULL ,

3472: p_source_ref_document_type IN JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ,
3473: p_app_from_document_id IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE DEFAULT NULL ,
3474: p_app_from_document_type IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_TYPE%TYPE DEFAULT NULL ,
3475: p_app_to_document_id IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE DEFAULT NULL ,
3476: p_app_to_document_type IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_TYPE%TYPE DEFAULT NULL ,
3477: p_parent_transaction_id IN JAI_RGM_REFS_ALL.PARENT_TRANSACTION_ID%TYPE DEFAULT NULL ,
3478: p_org_tan_no IN JAI_RGM_REFS_ALL.ORG_TAN_NO%TYPE DEFAULT NULL ,
3479: p_document_id IN NUMBER ,
3480: p_document_type IN VARCHAR2 ,

Line 3477: p_parent_transaction_id IN JAI_RGM_REFS_ALL.PARENT_TRANSACTION_ID%TYPE DEFAULT NULL ,

3473: p_app_from_document_id IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE DEFAULT NULL ,
3474: p_app_from_document_type IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_TYPE%TYPE DEFAULT NULL ,
3475: p_app_to_document_id IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE DEFAULT NULL ,
3476: p_app_to_document_type IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_TYPE%TYPE DEFAULT NULL ,
3477: p_parent_transaction_id IN JAI_RGM_REFS_ALL.PARENT_TRANSACTION_ID%TYPE DEFAULT NULL ,
3478: p_org_tan_no IN JAI_RGM_REFS_ALL.ORG_TAN_NO%TYPE DEFAULT NULL ,
3479: p_document_id IN NUMBER ,
3480: p_document_type IN VARCHAR2 ,
3481: p_document_line_id IN NUMBER ,

Line 3478: p_org_tan_no IN JAI_RGM_REFS_ALL.ORG_TAN_NO%TYPE DEFAULT NULL ,

3474: p_app_from_document_type IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_TYPE%TYPE DEFAULT NULL ,
3475: p_app_to_document_id IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE DEFAULT NULL ,
3476: p_app_to_document_type IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_TYPE%TYPE DEFAULT NULL ,
3477: p_parent_transaction_id IN JAI_RGM_REFS_ALL.PARENT_TRANSACTION_ID%TYPE DEFAULT NULL ,
3478: p_org_tan_no IN JAI_RGM_REFS_ALL.ORG_TAN_NO%TYPE DEFAULT NULL ,
3479: p_document_id IN NUMBER ,
3480: p_document_type IN VARCHAR2 ,
3481: p_document_line_id IN NUMBER ,
3482: p_document_date IN DATE ,

Line 3491: p_trx_ref_id OUT NOCOPY JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ,

3487: p_organization_id IN NUMBER ,
3488: p_party_id IN NUMBER ,
3489: p_party_site_id IN NUMBER ,
3490: p_item_classification IN VARCHAR2 ,
3491: p_trx_ref_id OUT NOCOPY JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ,
3492: p_process_flag OUT NOCOPY VARCHAR2 ,
3493: p_process_message OUT NOCOPY VARCHAR2
3494: )
3495:

Line 3500: || for the table jai_rgm_refs_all

3496: IS
3497:
3498: /****
3499: ||Get the primary key
3500: || for the table jai_rgm_refs_all
3501: *****/
3502: ln_reg_id NUMBER;
3503: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;
3504: lv_org_tan_no JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;

Line 3505: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;

3501: *****/
3502: ln_reg_id NUMBER;
3503: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;
3504: lv_org_tan_no JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;
3505: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;
3506: lv_process_flag VARCHAR2(2) ;
3507: lv_process_message VARCHAR2(2000) ;
3508: ln_user_id JAI_RGM_REFS_ALL.CREATED_BY%TYPE ;
3509: ln_login_id JAI_RGM_REFS_ALL.LAST_UPDATE_LOGIN%TYPE ;

Line 3508: ln_user_id JAI_RGM_REFS_ALL.CREATED_BY%TYPE ;

3504: lv_org_tan_no JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;
3505: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;
3506: lv_process_flag VARCHAR2(2) ;
3507: lv_process_message VARCHAR2(2000) ;
3508: ln_user_id JAI_RGM_REFS_ALL.CREATED_BY%TYPE ;
3509: ln_login_id JAI_RGM_REFS_ALL.LAST_UPDATE_LOGIN%TYPE ;
3510: ln_fin_year JAI_AP_TDS_YEARS.FIN_YEAR%TYPE ;
3511: ln_source_ref_document_id JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_ID%TYPE ;
3512: ln_source_ref_document_type JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ;

Line 3509: ln_login_id JAI_RGM_REFS_ALL.LAST_UPDATE_LOGIN%TYPE ;

3505: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;
3506: lv_process_flag VARCHAR2(2) ;
3507: lv_process_message VARCHAR2(2000) ;
3508: ln_user_id JAI_RGM_REFS_ALL.CREATED_BY%TYPE ;
3509: ln_login_id JAI_RGM_REFS_ALL.LAST_UPDATE_LOGIN%TYPE ;
3510: ln_fin_year JAI_AP_TDS_YEARS.FIN_YEAR%TYPE ;
3511: ln_source_ref_document_id JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_ID%TYPE ;
3512: ln_source_ref_document_type JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ;
3513: ln_threshold_slab_id JAI_RGM_REFS_ALL.THRESHOLD_SLAB_ID%TYPE ;

Line 3511: ln_source_ref_document_id JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_ID%TYPE ;

3507: lv_process_message VARCHAR2(2000) ;
3508: ln_user_id JAI_RGM_REFS_ALL.CREATED_BY%TYPE ;
3509: ln_login_id JAI_RGM_REFS_ALL.LAST_UPDATE_LOGIN%TYPE ;
3510: ln_fin_year JAI_AP_TDS_YEARS.FIN_YEAR%TYPE ;
3511: ln_source_ref_document_id JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_ID%TYPE ;
3512: ln_source_ref_document_type JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ;
3513: ln_threshold_slab_id JAI_RGM_REFS_ALL.THRESHOLD_SLAB_ID%TYPE ;
3514: BEGIN
3515:

Line 3512: ln_source_ref_document_type JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ;

3508: ln_user_id JAI_RGM_REFS_ALL.CREATED_BY%TYPE ;
3509: ln_login_id JAI_RGM_REFS_ALL.LAST_UPDATE_LOGIN%TYPE ;
3510: ln_fin_year JAI_AP_TDS_YEARS.FIN_YEAR%TYPE ;
3511: ln_source_ref_document_id JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_ID%TYPE ;
3512: ln_source_ref_document_type JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ;
3513: ln_threshold_slab_id JAI_RGM_REFS_ALL.THRESHOLD_SLAB_ID%TYPE ;
3514: BEGIN
3515:
3516: /*################################################################################################################

Line 3513: ln_threshold_slab_id JAI_RGM_REFS_ALL.THRESHOLD_SLAB_ID%TYPE ;

3509: ln_login_id JAI_RGM_REFS_ALL.LAST_UPDATE_LOGIN%TYPE ;
3510: ln_fin_year JAI_AP_TDS_YEARS.FIN_YEAR%TYPE ;
3511: ln_source_ref_document_id JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_ID%TYPE ;
3512: ln_source_ref_document_type JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ;
3513: ln_threshold_slab_id JAI_RGM_REFS_ALL.THRESHOLD_SLAB_ID%TYPE ;
3514: BEGIN
3515:
3516: /*################################################################################################################
3517: || Initialize the variables

Line 3634: pv_log_msg => ' VALUES insert into JAI_RGM_REFS_ALL are : - ' ||fnd_global.local_chr(10)

3630:
3631:
3632: /*commented by csahoo for bug# 6401388
3633: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3634: pv_log_msg => ' VALUES insert into JAI_RGM_REFS_ALL are : - ' ||fnd_global.local_chr(10)
3635: ||', trx_ref_id -> '||p_trx_ref_id ||fnd_global.local_chr(10)
3636: ||', regime_id -> '||ln_regime_id ||fnd_global.local_chr(10)
3637: ||', transaction_id -> '||p_transaction_id ||fnd_global.local_chr(10)
3638: ||', source_ref_document_id -> '||ln_source_ref_document_id ||fnd_global.local_chr(10)

Line 3671: INSERT into jai_rgm_refs_all (

3667: ||', settlement_id -> '||NULL ||fnd_global.local_chr(10)
3668: ||', certificate_id -> '||NULL
3669: );*/
3670:
3671: INSERT into jai_rgm_refs_all (
3672: trx_ref_id ,
3673: regime_id ,
3674: transaction_id ,
3675: source_ref_document_id ,

Line 3749: p_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ,

3745: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
3746: END insert_repository_references;
3747:
3748: procedure insert_repository_taxes (
3749: p_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ,
3750: p_tax_id JAI_RGM_TAXES.TAX_ID%TYPE ,
3751: p_tax_type JAI_RGM_TAXES.TAX_TYPE%TYPE ,
3752: p_tax_rate JAI_RGM_TAXES.TAX_RATE%TYPE ,
3753: p_tax_amount JAI_RGM_TAXES.TAX_AMT%TYPE ,

Line 3962: jai_rgm_refs_all

3958: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3959: pv_log_msg => ' Insert successful'
3960: );*/
3961: UPDATE
3962: jai_rgm_refs_all
3963: SET
3964: total_tax_amt = nvl(total_tax_amt,0) + nvl(p_tax_amount,0)
3965: WHERE
3966: trx_ref_id = p_trx_ref_id;

Line 3970: pv_log_msg => ' jai_rgm_refs_all.total_tax_amt successfully updated '

3966: trx_ref_id = p_trx_ref_id;
3967:
3968: /*commented by csahoo for bug# 6401388
3969: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3970: pv_log_msg => ' jai_rgm_refs_all.total_tax_amt successfully updated '
3971: );*/
3972: /*commented by csahoo for bug# 6401388
3973: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
3974: pv_log_msg => '**************** END OF INSERT_REPOSITORY_TAXES ****************'

Line 3980: PROCEDURE copy_taxes_from_source ( p_source_document_type IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ,

3976: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
3977: END insert_repository_taxes ;
3978:
3979:
3980: PROCEDURE copy_taxes_from_source ( p_source_document_type IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ,
3981: p_source_document_id IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ,
3982: p_source_document_line_id IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE DEFAULT NULL ,
3983: p_apportion_factor IN NUMBER DEFAULT NULL ,
3984: p_trx_ref_id IN JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ,

Line 3981: p_source_document_id IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ,

3977: END insert_repository_taxes ;
3978:
3979:
3980: PROCEDURE copy_taxes_from_source ( p_source_document_type IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ,
3981: p_source_document_id IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ,
3982: p_source_document_line_id IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE DEFAULT NULL ,
3983: p_apportion_factor IN NUMBER DEFAULT NULL ,
3984: p_trx_ref_id IN JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ,
3985: p_process_flag OUT NOCOPY VARCHAR2 ,

Line 3982: p_source_document_line_id IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE DEFAULT NULL ,

3978:
3979:
3980: PROCEDURE copy_taxes_from_source ( p_source_document_type IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ,
3981: p_source_document_id IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ,
3982: p_source_document_line_id IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE DEFAULT NULL ,
3983: p_apportion_factor IN NUMBER DEFAULT NULL ,
3984: p_trx_ref_id IN JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ,
3985: p_process_flag OUT NOCOPY VARCHAR2 ,
3986: p_process_message OUT NOCOPY VARCHAR2

Line 3984: p_trx_ref_id IN JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ,

3980: PROCEDURE copy_taxes_from_source ( p_source_document_type IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ,
3981: p_source_document_id IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ,
3982: p_source_document_line_id IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE DEFAULT NULL ,
3983: p_apportion_factor IN NUMBER DEFAULT NULL ,
3984: p_trx_ref_id IN JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ,
3985: p_process_flag OUT NOCOPY VARCHAR2 ,
3986: p_process_message OUT NOCOPY VARCHAR2
3987: )
3988: IS

Line 4189: PROCEDURE copy_references ( p_parent_transaction_id IN JAI_RGM_REFS_ALL.PARENT_TRANSACTION_ID%TYPE DEFAULT NULL ,

4185: );
4186: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
4187: END copy_taxes_from_source;
4188:
4189: PROCEDURE copy_references ( p_parent_transaction_id IN JAI_RGM_REFS_ALL.PARENT_TRANSACTION_ID%TYPE DEFAULT NULL ,
4190: p_new_document_id IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ,
4191: p_new_document_type IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ,
4192: p_new_document_date IN DATE ,
4193: p_apportion_factor IN NUMBER DEFAULT 1 ,

Line 4190: p_new_document_id IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ,

4186: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
4187: END copy_taxes_from_source;
4188:
4189: PROCEDURE copy_references ( p_parent_transaction_id IN JAI_RGM_REFS_ALL.PARENT_TRANSACTION_ID%TYPE DEFAULT NULL ,
4190: p_new_document_id IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ,
4191: p_new_document_type IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ,
4192: p_new_document_date IN DATE ,
4193: p_apportion_factor IN NUMBER DEFAULT 1 ,
4194: p_process_flag OUT NOCOPY VARCHAR2 ,

Line 4191: p_new_document_type IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ,

4187: END copy_taxes_from_source;
4188:
4189: PROCEDURE copy_references ( p_parent_transaction_id IN JAI_RGM_REFS_ALL.PARENT_TRANSACTION_ID%TYPE DEFAULT NULL ,
4190: p_new_document_id IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ,
4191: p_new_document_type IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ,
4192: p_new_document_date IN DATE ,
4193: p_apportion_factor IN NUMBER DEFAULT 1 ,
4194: p_process_flag OUT NOCOPY VARCHAR2 ,
4195: p_process_message OUT NOCOPY VARCHAR2

Line 4205: jai_rgm_refs_all

4201: IS
4202: SELECT
4203: *
4204: FROM
4205: jai_rgm_refs_all
4206: WHERE
4207: transaction_id = p_parent_transaction_id;
4208:
4209: CURSOR cur_get_rgm_taxes ( cp_trx_ref_id JAI_RGM_TAXES.TRX_REF_ID%TYPE )

Line 4219: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;

4215: WHERE
4216: trx_ref_id = cp_trx_ref_id;
4217:
4218: rec_cur_get_refs CUR_GET_REFS%ROWTYPE ;
4219: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;
4220: ln_tax_det_id JAI_RGM_TAXES.TAX_DET_ID%TYPE ;
4221: ln_apportion_ratio NUMBER ;
4222: ln_user_id JAI_RGM_REFS_ALL.CREATED_BY%TYPE ;
4223: ln_login_id JAI_RGM_REFS_ALL.LAST_UPDATE_LOGIN%TYPE ;

Line 4222: ln_user_id JAI_RGM_REFS_ALL.CREATED_BY%TYPE ;

4218: rec_cur_get_refs CUR_GET_REFS%ROWTYPE ;
4219: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;
4220: ln_tax_det_id JAI_RGM_TAXES.TAX_DET_ID%TYPE ;
4221: ln_apportion_ratio NUMBER ;
4222: ln_user_id JAI_RGM_REFS_ALL.CREATED_BY%TYPE ;
4223: ln_login_id JAI_RGM_REFS_ALL.LAST_UPDATE_LOGIN%TYPE ;
4224: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;
4225: lv_org_tan_no JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;
4226: ln_threshold_slab_id JAI_RGM_REFS_ALL.THRESHOLD_SLAB_ID%TYPE ;

Line 4223: ln_login_id JAI_RGM_REFS_ALL.LAST_UPDATE_LOGIN%TYPE ;

4219: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;
4220: ln_tax_det_id JAI_RGM_TAXES.TAX_DET_ID%TYPE ;
4221: ln_apportion_ratio NUMBER ;
4222: ln_user_id JAI_RGM_REFS_ALL.CREATED_BY%TYPE ;
4223: ln_login_id JAI_RGM_REFS_ALL.LAST_UPDATE_LOGIN%TYPE ;
4224: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;
4225: lv_org_tan_no JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;
4226: ln_threshold_slab_id JAI_RGM_REFS_ALL.THRESHOLD_SLAB_ID%TYPE ;
4227: lv_process_flag VARCHAR2(2) ;

Line 4226: ln_threshold_slab_id JAI_RGM_REFS_ALL.THRESHOLD_SLAB_ID%TYPE ;

4222: ln_user_id JAI_RGM_REFS_ALL.CREATED_BY%TYPE ;
4223: ln_login_id JAI_RGM_REFS_ALL.LAST_UPDATE_LOGIN%TYPE ;
4224: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;
4225: lv_org_tan_no JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;
4226: ln_threshold_slab_id JAI_RGM_REFS_ALL.THRESHOLD_SLAB_ID%TYPE ;
4227: lv_process_flag VARCHAR2(2) ;
4228: lv_process_message VARCHAR2(4000) ;
4229: BEGIN
4230:

Line 4263: || POPULATE JAI_RGM_REFS_ALL ---- PART -2

4259: ln_login_id := fnd_global.login_id ;
4260:
4261:
4262: /*########################################################################################################
4263: || POPULATE JAI_RGM_REFS_ALL ---- PART -2
4264: ########################################################################################################*/
4265:
4266: /*
4267: ||Get the sequence generated unique key for the transaction

Line 4286: pv_log_msg => ' VALUES insert into JAI_RGM_REFS_ALL are : - ' ||fnd_global.local_chr(10)

4282:
4283:
4284: /*commented by csahoo for bug# 6401388
4285: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4286: pv_log_msg => ' VALUES insert into JAI_RGM_REFS_ALL are : - ' ||fnd_global.local_chr(10)
4287: ||', regime_id -> '||rec_cur_get_refs.regime_id ||fnd_global.local_chr(10)
4288: ||', trx_ref_id -> '||ln_trx_ref_id ||fnd_global.local_chr(10)
4289: ||', transaction_id -> '||ln_transaction_id ||fnd_global.local_chr(10)
4290: ||', parent_transaction_id -> '||p_parent_transaction_id ||fnd_global.local_chr(10)

Line 4323: INSERT into jai_rgm_refs_all (

4319: ||', settlement_id -> '||NULL
4320: ||', certificate_id -> '||NULL
4321: );*/
4322:
4323: INSERT into jai_rgm_refs_all (
4324: trx_ref_id ,
4325: regime_id ,
4326: transaction_id ,
4327: parent_transaction_id ,

Line 4398: pv_log_msg => ' After Insert into jai_rgm_refs_all'

4394: );
4395:
4396: /*commented by csahoo for bug# 6401388
4397: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4398: pv_log_msg => ' After Insert into jai_rgm_refs_all'
4399: );*/
4400:
4401: /*
4402: ||Taxes needs to be copied from source

Line 4416: pv_log_msg => ' VALUES insert into JAI_RGM_REFS_ALL are : - ' ||fnd_global.local_chr(10)

4412: CLOSE cur_get_tax_det_id;
4413:
4414: /*commented by csahoo for bug# 6401388
4415: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4416: pv_log_msg => ' VALUES insert into JAI_RGM_REFS_ALL are : - ' ||fnd_global.local_chr(10)
4417: ||', tax_det_id -> '||ln_tax_det_id ||fnd_global.local_chr(10)
4418: ||', trx_ref_id -> '||ln_trx_ref_id ||fnd_global.local_chr(10)
4419: ||', tax_type -> '||rec_cur_get_rgm_taxes.tax_type ||fnd_global.local_chr(10)
4420: ||', tax_amt -> '||round( p_apportion_factor * rec_cur_get_rgm_taxes.tax_amt ) ||fnd_global.local_chr(10)

Line 4474: END LOOP; /End of jai_rgm_refs_all population /

4470: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4471: pv_log_msg => ' After Insert into jai_rgm_taxes '
4472: );*/
4473: END LOOP; /* End of tax population */
4474: END LOOP; /*End of jai_rgm_refs_all population */
4475:
4476: /*commented by csahoo for bug# 6401388
4477: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4478: pv_log_msg => '**************** END OF COPY_REFERENCES ****************'

Line 4502: jai_rgm_refs_all jrra

4498: jrigd.rowid ,
4499: jrigd.generated_doc_id
4500: FROM
4501: jai_rgm_item_gen_docs jrigd,
4502: jai_rgm_refs_all jrra
4503: WHERE
4504: jrigd.generated_doc_trx_number = p_trx_number
4505: AND jrra.transaction_id = jrigd.transaction_id
4506: AND jrra.org_id = p_org_id

Line 4511: ln_user_id JAI_RGM_REFS_ALL.CREATED_BY%TYPE ;

4507: FOR UPDATE OF jrigd.generated_doc_id NOWAIT;
4508:
4509: lv_rowid ROWID ;
4510: ln_generated_doc_id JAI_RGM_ITEM_GEN_DOCS.GENERATED_DOC_ID%TYPE ;
4511: ln_user_id JAI_RGM_REFS_ALL.CREATED_BY%TYPE ;
4512: ln_login_id JAI_RGM_REFS_ALL.LAST_UPDATE_LOGIN%TYPE ;
4513:
4514: BEGIN
4515:

Line 4512: ln_login_id JAI_RGM_REFS_ALL.LAST_UPDATE_LOGIN%TYPE ;

4508:
4509: lv_rowid ROWID ;
4510: ln_generated_doc_id JAI_RGM_ITEM_GEN_DOCS.GENERATED_DOC_ID%TYPE ;
4511: ln_user_id JAI_RGM_REFS_ALL.CREATED_BY%TYPE ;
4512: ln_login_id JAI_RGM_REFS_ALL.LAST_UPDATE_LOGIN%TYPE ;
4513:
4514: BEGIN
4515:
4516: /*################################################################################################################

Line 4608: p_rgm_ref IN JAI_RGM_REFS_ALL%ROWTYPE ,

4604: END update_item_gen_docs;
4605:
4606:
4607: PROCEDURE generate_document (
4608: p_rgm_ref IN JAI_RGM_REFS_ALL%ROWTYPE ,
4609: p_total_tax_amt IN NUMBER ,
4610: p_process_flag OUT NOCOPY VARCHAR2 ,
4611: p_process_message OUT NOCOPY VARCHAR2
4612: )

Line 4623: CURSOR cur_get_batch_source ( cp_org_id JAI_RGM_REFS_ALL.ORG_ID%TYPE ,

4619:
4620: /*
4621: ||Customer would create a batch source with name TCS Debit Memo And TCS Credit Memo
4622: */
4623: CURSOR cur_get_batch_source ( cp_org_id JAI_RGM_REFS_ALL.ORG_ID%TYPE ,
4624: cp_name RA_BATCH_SOURCES_ALL.NAME%TYPE
4625: )
4626: IS
4627: SELECT

Line 4644: CURSOR cur_get_part_det ( cp_party_id JAI_RGM_REFS_ALL.PARTY_ID%TYPE ,

4640: AND bsa.org_id = rctt.org_id
4641: AND bsa.org_id = cp_org_id
4642: AND bsa.name = cp_name ;
4643:
4644: CURSOR cur_get_part_det ( cp_party_id JAI_RGM_REFS_ALL.PARTY_ID%TYPE ,
4645: cp_party_site_id JAI_RGM_REFS_ALL.PARTY_SITE_ID%TYPE
4646: )
4647: IS
4648: SELECT

Line 4645: cp_party_site_id JAI_RGM_REFS_ALL.PARTY_SITE_ID%TYPE

4641: AND bsa.org_id = cp_org_id
4642: AND bsa.name = cp_name ;
4643:
4644: CURSOR cur_get_part_det ( cp_party_id JAI_RGM_REFS_ALL.PARTY_ID%TYPE ,
4645: cp_party_site_id JAI_RGM_REFS_ALL.PARTY_SITE_ID%TYPE
4646: )
4647: IS
4648: SELECT
4649: hzcas.cust_acct_site_id bill_to_address_id

Line 4661: CURSOR cur_get_sob ( cp_org_id jai_rgm_refs_all.org_id%TYPE )

4657: AND hzcsu.site_use_code = jai_constants.site_use_bill_to
4658: AND hca.cust_account_id = cp_party_id
4659: AND hzcsu.site_use_id = cp_party_site_id ;-- site_use_id is the party_site_id ;
4660:
4661: CURSOR cur_get_sob ( cp_org_id jai_rgm_refs_all.org_id%TYPE )
4662: IS
4663: SELECT
4664: set_of_books_id
4665: FROM

Line 4681: ln_user_id JAI_RGM_REFS_ALL.CREATED_BY%TYPE ;

4677: ln_ccid_tax_type_tcs NUMBER ;
4678: rec_cur_get_batch_source CUR_GET_BATCH_SOURCE%ROWTYPE ;
4679: lv_set_of_books_id HR_OPERATING_UNITS.SET_OF_BOOKS_ID%TYPE ;
4680: ln_amount NUMBER ;
4681: ln_user_id JAI_RGM_REFS_ALL.CREATED_BY%TYPE ;
4682: ln_login_id JAI_RGM_REFS_ALL.LAST_UPDATE_LOGIN%TYPE ;
4683: lv_process_message VARCHAR2(4000) ;
4684:
4685: BEGIN

Line 4682: ln_login_id JAI_RGM_REFS_ALL.LAST_UPDATE_LOGIN%TYPE ;

4678: rec_cur_get_batch_source CUR_GET_BATCH_SOURCE%ROWTYPE ;
4679: lv_set_of_books_id HR_OPERATING_UNITS.SET_OF_BOOKS_ID%TYPE ;
4680: ln_amount NUMBER ;
4681: ln_user_id JAI_RGM_REFS_ALL.CREATED_BY%TYPE ;
4682: ln_login_id JAI_RGM_REFS_ALL.LAST_UPDATE_LOGIN%TYPE ;
4683: lv_process_message VARCHAR2(4000) ;
4684:
4685: BEGIN
4686:

Line 5259: CURSOR cur_get_refs (cp_transaction_id JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE )

5255:
5256: ***************************************************************************/
5257:
5258:
5259: CURSOR cur_get_refs (cp_transaction_id JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE )
5260: IS
5261: SELECT
5262: *
5263: FROM

Line 5264: jai_rgm_refs_all ref

5260: IS
5261: SELECT
5262: *
5263: FROM
5264: jai_rgm_refs_all ref
5265: WHERE
5266: transaction_id = cp_transaction_id;
5267:
5268:

Line 5269: CURSOR cur_get_total_tax (cp_transaction_id JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE )

5265: WHERE
5266: transaction_id = cp_transaction_id;
5267:
5268:
5269: CURSOR cur_get_total_tax (cp_transaction_id JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE )
5270: IS
5271: SELECT
5272: sum(nvl(jrt.func_tax_amt,0)) total_tax_amount
5273: FROM

Line 5274: jai_rgm_refs_all jrra,

5270: IS
5271: SELECT
5272: sum(nvl(jrt.func_tax_amt,0)) total_tax_amount
5273: FROM
5274: jai_rgm_refs_all jrra,
5275: jai_rgm_taxes jrt
5276: WHERE
5277: jrra.trx_ref_id = jrt.trx_ref_id
5278: AND jrra.transaction_id = cp_transaction_id;

Line 5283: lv_item_classification JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;

5279:
5280: rec_cur_get_refs CUR_GET_REFS%ROWTYPE ;
5281: ln_tax_tot_amt NUMBER ;
5282: lv_document_type VARCHAR2(100) ;
5283: lv_item_classification JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;
5284: lv_process_flag VARCHAR2(2) ;
5285: lv_process_message VARCHAR2(2000) ;
5286:
5287: /* Added by JMEENA for TCS issue bug#7277211*/

Line 5997: p_party_id IN JAI_RGM_REFS_ALL.PARTY_ID%TYPE ,

5993: END process_transactions ;
5994:
5995: PROCEDURE update_pan_for_tcs ( p_return_code OUT NOCOPY VARCHAR2 ,
5996: p_errbuf OUT NOCOPY VARCHAR2 ,
5997: p_party_id IN JAI_RGM_REFS_ALL.PARTY_ID%TYPE ,
5998: p_old_pan_no IN JAI_CMN_CUS_ADDRESSES.PAN_NO%TYPE ,
5999: p_new_pan_no IN JAI_CMN_CUS_ADDRESSES.PAN_NO%TYPE
6000:
6001: )