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 1116: lv_first_itm_class JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;

1112: lv_member_name jai_cmn_debug_contexts.LOG_CONTEXT%TYPE;
1113: lv_context jai_cmn_debug_contexts.LOG_CONTEXT%TYPE;
1114:
1115: ln_exists NUMBER ;
1116: lv_first_itm_class JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;
1117: lv_item_classification JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;
1118:
1119: lv_process_flag VARCHAR2(2) ;
1120: lv_process_message VARCHAR2(4000) ;

Line 1117: lv_item_classification JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;

1113: lv_context jai_cmn_debug_contexts.LOG_CONTEXT%TYPE;
1114:
1115: ln_exists NUMBER ;
1116: lv_first_itm_class JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;
1117: lv_item_classification JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;
1118:
1119: lv_process_flag VARCHAR2(2) ;
1120: lv_process_message VARCHAR2(4000) ;
1121:

Line 1344: jai_rgm_refs_all

1340: IS
1341: SELECT
1342: '1'
1343: FROM
1344: jai_rgm_refs_all
1345: WHERE
1346: source_document_id = cp_customer_trx_id
1347: AND settlement_id IS NOT NULL ;
1348:

Line 1421: ln_threshold_slab_id JAI_RGM_REFS_ALL.THRESHOLD_SLAB_ID%TYPE ;

1417: lv_trx_type RA_CUST_TRX_TYPES_ALL.TYPE%TYPE ;
1418: lv_doc_type VARCHAR2(100) ;
1419: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;
1420: lv_org_tan_no JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;
1421: ln_threshold_slab_id JAI_RGM_REFS_ALL.THRESHOLD_SLAB_ID%TYPE ;
1422: ln_exists NUMBER(2) ;
1423: lv_first_itm_class JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;
1424: lv_item_classification JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;
1425: lv_process_flag VARCHAR2(2) ;

Line 1423: lv_first_itm_class JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;

1419: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;
1420: lv_org_tan_no JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;
1421: ln_threshold_slab_id JAI_RGM_REFS_ALL.THRESHOLD_SLAB_ID%TYPE ;
1422: ln_exists NUMBER(2) ;
1423: lv_first_itm_class JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;
1424: lv_item_classification JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;
1425: lv_process_flag VARCHAR2(2) ;
1426: lv_process_message VARCHAR2(4000) ;
1427: ln_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;

Line 1424: lv_item_classification JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;

1420: lv_org_tan_no JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;
1421: ln_threshold_slab_id JAI_RGM_REFS_ALL.THRESHOLD_SLAB_ID%TYPE ;
1422: ln_exists NUMBER(2) ;
1423: lv_first_itm_class JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;
1424: lv_item_classification JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;
1425: lv_process_flag VARCHAR2(2) ;
1426: lv_process_message VARCHAR2(4000) ;
1427: ln_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;
1428: ln_surcharge_cnt NUMBER(2) := 0 ;

Line 1427: ln_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;

1423: lv_first_itm_class JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;
1424: lv_item_classification JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;
1425: lv_process_flag VARCHAR2(2) ;
1426: lv_process_message VARCHAR2(4000) ;
1427: ln_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;
1428: ln_surcharge_cnt NUMBER(2) := 0 ;
1429: ld_source_doc_date RA_CUST_TRX_LINE_GL_DIST_ALL.GL_DATE%TYPE ;
1430:
1431: ln_open_interface number;--Added by zhiwei for Open Interface bug#11683927

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

1831:
1832: PROCEDURE validate_app_unapp (
1833: p_araa IN AR_RECEIVABLE_APPLICATIONS_ALL%ROWTYPE ,
1834: p_document_type OUT NOCOPY VARCHAR2 ,
1835: p_item_classification OUT NOCOPY JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ,
1836: p_process_flag OUT NOCOPY VARCHAR2 ,
1837: p_process_message OUT NOCOPY VARCHAR2
1838: )
1839: AS

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

1920:
1921: /*
1922: || Get the application details for the current unapplications from the repository
1923: */
1924: CURSOR cur_chk_parent_rec ( cp_applied_fr_doc_id JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE ,
1925: cp_applied_to_doc_id JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE
1926: )
1927: IS
1928: SELECT

Line 1925: cp_applied_to_doc_id JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE

1921: /*
1922: || Get the application details for the current unapplications from the repository
1923: */
1924: CURSOR cur_chk_parent_rec ( cp_applied_fr_doc_id JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE ,
1925: cp_applied_to_doc_id JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE
1926: )
1927: IS
1928: SELECT
1929: trx_ref_id ,

Line 1932: jai_rgm_refs_all

1928: SELECT
1929: trx_ref_id ,
1930: settlement_id
1931: FROM
1932: jai_rgm_refs_all
1933: WHERE
1934: app_from_document_id = cp_applied_fr_doc_id
1935: AND app_to_document_id = cp_applied_to_doc_id ;
1936:

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

2399:
2400: /*
2401: ||Get the last record pertaining to the cash receipt confirmation
2402: */
2403: CURSOR cur_chk_tcs_settlement ( cp_source_document_id jai_rgm_refs_all.source_document_id%TYPE ,
2404: cp_source_document_type jai_rgm_refs_all.source_document_type%TYPE
2405: )
2406: IS
2407: SELECT

Line 2404: cp_source_document_type jai_rgm_refs_all.source_document_type%TYPE

2400: /*
2401: ||Get the last record pertaining to the cash receipt confirmation
2402: */
2403: CURSOR cur_chk_tcs_settlement ( cp_source_document_id jai_rgm_refs_all.source_document_id%TYPE ,
2404: cp_source_document_type jai_rgm_refs_all.source_document_type%TYPE
2405: )
2406: IS
2407: SELECT
2408: trx_ref_id ,

Line 2411: jai_rgm_refs_all a

2407: SELECT
2408: trx_ref_id ,
2409: settlement_id
2410: FROM
2411: jai_rgm_refs_all a
2412: WHERE
2413: trx_ref_id = ( SELECT
2414: max(trx_ref_id)
2415: FROM

Line 2416: jai_rgm_refs_all b

2412: WHERE
2413: trx_ref_id = ( SELECT
2414: max(trx_ref_id)
2415: FROM
2416: jai_rgm_refs_all b
2417: WHERE
2418: b.source_document_id = cp_source_document_id
2419: AND b.source_document_type = cp_source_document_type
2420: );

Line 2423: ln_settlement_id JAI_RGM_REFS_ALL.SETTLEMENT_ID%TYPE ;

2419: AND b.source_document_type = cp_source_document_type
2420: );
2421:
2422: ln_exists NUMBER(2) ;
2423: ln_settlement_id JAI_RGM_REFS_ALL.SETTLEMENT_ID%TYPE ;
2424: rec_cur_chk_tcs_settlement CUR_CHK_TCS_SETTLEMENT%ROWTYPE ;
2425: BEGIN
2426:
2427: /*########################################################################################################

Line 2636: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;

2632: ln_last_line_flag VARCHAR2(1) := jai_constants.no ;
2633: lv_process_flag VARCHAR2(2) ;
2634: lv_process_message VARCHAR2(2000) ;
2635: lv_document_type VARCHAR2(100) ;
2636: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;
2637: ln_apportion_factor NUMBER(3) ;
2638: lv_item_classification JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;
2639: ln_total_inv_amount RA_CUST_TRX_LINE_GL_DIST_ALL.AMOUNT%TYPE ;
2640: ld_document_date JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_DATE%TYPE ;

Line 2638: lv_item_classification JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;

2634: lv_process_message VARCHAR2(2000) ;
2635: lv_document_type VARCHAR2(100) ;
2636: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;
2637: ln_apportion_factor NUMBER(3) ;
2638: lv_item_classification JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;
2639: ln_total_inv_amount RA_CUST_TRX_LINE_GL_DIST_ALL.AMOUNT%TYPE ;
2640: ld_document_date JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_DATE%TYPE ;
2641: BEGIN
2642: /*########################################################################################################

Line 2640: ld_document_date JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_DATE%TYPE ;

2636: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;
2637: ln_apportion_factor NUMBER(3) ;
2638: lv_item_classification JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;
2639: ln_total_inv_amount RA_CUST_TRX_LINE_GL_DIST_ALL.AMOUNT%TYPE ;
2640: ld_document_date JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_DATE%TYPE ;
2641: BEGIN
2642: /*########################################################################################################
2643: || VARIABLES INITIALIZATION
2644: ########################################################################################################*/

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

2926: /********
2927: || Get the details of the source receipt
2928: || from the repository
2929: ********/
2930: CURSOR cur_copy_src_rcpt (cp_source_document_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE)
2931: IS
2932: SELECT
2933: *
2934: FROM

Line 2935: jai_rgm_refs_all

2931: IS
2932: SELECT
2933: *
2934: FROM
2935: jai_rgm_refs_all
2936: WHERE
2937: source_document_id = cp_source_document_id;
2938:
2939: /********

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

2939: /********
2940: || Get the details of the source receipt taxes
2941: || from the repository
2942: ********/
2943: CURSOR cur_copy_tax_rcpt_rev ( cp_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE )
2944: IS
2945: SELECT
2946: *
2947: FROM

Line 2955: ln_rcpt_amount JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_AMT%TYPE ;

2951:
2952: p_araa AR_RECEIVABLE_APPLICATIONS_ALL%ROWTYPE ;
2953: rec_cur_get_cr_details CUR_GET_CR_DETAILS%ROWTYPE ;
2954: rec_cur_copy_src_rcpt CUR_COPY_SRC_RCPT%ROWTYPE ;
2955: ln_rcpt_amount JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_AMT%TYPE ;
2956: lv_process_flag VARCHAR2(2) ;
2957: lv_process_message VARCHAR2(2000) ;
2958: lv_document_type VARCHAR2(100) ;
2959: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;

Line 2959: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;

2955: ln_rcpt_amount JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_AMT%TYPE ;
2956: lv_process_flag VARCHAR2(2) ;
2957: lv_process_message VARCHAR2(2000) ;
2958: lv_document_type VARCHAR2(100) ;
2959: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;
2960: ln_apportion_factor NUMBER(3) ;
2961: ln_local_transaction_id JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE ;
2962: ln_parent_transaction_id JAI_RGM_REFS_ALL.PARENT_TRANSACTION_ID%TYPE ;
2963:

Line 2961: ln_local_transaction_id JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE ;

2957: lv_process_message VARCHAR2(2000) ;
2958: lv_document_type VARCHAR2(100) ;
2959: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;
2960: ln_apportion_factor NUMBER(3) ;
2961: ln_local_transaction_id JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE ;
2962: ln_parent_transaction_id JAI_RGM_REFS_ALL.PARENT_TRANSACTION_ID%TYPE ;
2963:
2964: BEGIN
2965:

Line 2962: ln_parent_transaction_id JAI_RGM_REFS_ALL.PARENT_TRANSACTION_ID%TYPE ;

2958: lv_document_type VARCHAR2(100) ;
2959: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;
2960: ln_apportion_factor NUMBER(3) ;
2961: ln_local_transaction_id JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE ;
2962: ln_parent_transaction_id JAI_RGM_REFS_ALL.PARENT_TRANSACTION_ID%TYPE ;
2963:
2964: BEGIN
2965:
2966: /*########################################################################################################

Line 3243: p_item_classification IN JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ,

3239:
3240:
3241: PROCEDURE process_applications ( p_araa IN AR_RECEIVABLE_APPLICATIONS_ALL%ROWTYPE ,
3242: p_document_type IN VARCHAR2 ,
3243: p_item_classification IN JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ,
3244: p_process_flag OUT NOCOPY VARCHAR2 ,
3245: p_process_message OUT NOCOPY VARCHAR2
3246: )
3247: IS

Line 3403: ln_app_fr_doc_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;

3399: AND jrttv.regime_code = jai_constants.tcs_regime;
3400:
3401: ln_app_fr_doc_amt NUMBER ;
3402: ld_app_fr_doc_date DATE ;
3403: ln_app_fr_doc_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;
3404: ln_app_fr_doc_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ;
3405: ln_app_fr_doc_table JAI_RGM_REFS_ALL.SOURCE_TABLE_NAME%TYPE ;
3406: ln_fr_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;
3407: ln_fr_party_id JAI_RGM_REFS_ALL.PARTY_ID%TYPE ;

Line 3404: ln_app_fr_doc_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ;

3400:
3401: ln_app_fr_doc_amt NUMBER ;
3402: ld_app_fr_doc_date DATE ;
3403: ln_app_fr_doc_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;
3404: ln_app_fr_doc_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ;
3405: ln_app_fr_doc_table JAI_RGM_REFS_ALL.SOURCE_TABLE_NAME%TYPE ;
3406: ln_fr_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;
3407: ln_fr_party_id JAI_RGM_REFS_ALL.PARTY_ID%TYPE ;
3408: ln_fr_party_site_id JAI_RGM_REFS_ALL.PARTY_SITE_ID%TYPE ;

Line 3405: ln_app_fr_doc_table JAI_RGM_REFS_ALL.SOURCE_TABLE_NAME%TYPE ;

3401: ln_app_fr_doc_amt NUMBER ;
3402: ld_app_fr_doc_date DATE ;
3403: ln_app_fr_doc_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;
3404: ln_app_fr_doc_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ;
3405: ln_app_fr_doc_table JAI_RGM_REFS_ALL.SOURCE_TABLE_NAME%TYPE ;
3406: ln_fr_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;
3407: ln_fr_party_id JAI_RGM_REFS_ALL.PARTY_ID%TYPE ;
3408: ln_fr_party_site_id JAI_RGM_REFS_ALL.PARTY_SITE_ID%TYPE ;
3409:

Line 3406: ln_fr_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;

3402: ld_app_fr_doc_date DATE ;
3403: ln_app_fr_doc_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;
3404: ln_app_fr_doc_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ;
3405: ln_app_fr_doc_table JAI_RGM_REFS_ALL.SOURCE_TABLE_NAME%TYPE ;
3406: ln_fr_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;
3407: ln_fr_party_id JAI_RGM_REFS_ALL.PARTY_ID%TYPE ;
3408: ln_fr_party_site_id JAI_RGM_REFS_ALL.PARTY_SITE_ID%TYPE ;
3409:
3410: ln_app_to_doc_amt NUMBER ;

Line 3407: ln_fr_party_id JAI_RGM_REFS_ALL.PARTY_ID%TYPE ;

3403: ln_app_fr_doc_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;
3404: ln_app_fr_doc_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ;
3405: ln_app_fr_doc_table JAI_RGM_REFS_ALL.SOURCE_TABLE_NAME%TYPE ;
3406: ln_fr_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;
3407: ln_fr_party_id JAI_RGM_REFS_ALL.PARTY_ID%TYPE ;
3408: ln_fr_party_site_id JAI_RGM_REFS_ALL.PARTY_SITE_ID%TYPE ;
3409:
3410: ln_app_to_doc_amt NUMBER ;
3411: ld_app_to_doc_date DATE ;

Line 3408: ln_fr_party_site_id JAI_RGM_REFS_ALL.PARTY_SITE_ID%TYPE ;

3404: ln_app_fr_doc_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ;
3405: ln_app_fr_doc_table JAI_RGM_REFS_ALL.SOURCE_TABLE_NAME%TYPE ;
3406: ln_fr_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;
3407: ln_fr_party_id JAI_RGM_REFS_ALL.PARTY_ID%TYPE ;
3408: ln_fr_party_site_id JAI_RGM_REFS_ALL.PARTY_SITE_ID%TYPE ;
3409:
3410: ln_app_to_doc_amt NUMBER ;
3411: ld_app_to_doc_date DATE ;
3412: ln_app_to_doc_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;

Line 3412: ln_app_to_doc_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;

3408: ln_fr_party_site_id JAI_RGM_REFS_ALL.PARTY_SITE_ID%TYPE ;
3409:
3410: ln_app_to_doc_amt NUMBER ;
3411: ld_app_to_doc_date DATE ;
3412: ln_app_to_doc_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;
3413: ln_app_to_doc_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ;
3414: ln_app_to_doc_table JAI_RGM_REFS_ALL.SOURCE_TABLE_NAME%TYPE ;
3415: ln_to_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;
3416: ln_to_party_id JAI_RGM_REFS_ALL.PARTY_ID%TYPE ;

Line 3413: ln_app_to_doc_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ;

3409:
3410: ln_app_to_doc_amt NUMBER ;
3411: ld_app_to_doc_date DATE ;
3412: ln_app_to_doc_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;
3413: ln_app_to_doc_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ;
3414: ln_app_to_doc_table JAI_RGM_REFS_ALL.SOURCE_TABLE_NAME%TYPE ;
3415: ln_to_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;
3416: ln_to_party_id JAI_RGM_REFS_ALL.PARTY_ID%TYPE ;
3417: ln_to_party_site_id JAI_RGM_REFS_ALL.PARTY_SITE_ID%TYPE ;

Line 3414: ln_app_to_doc_table JAI_RGM_REFS_ALL.SOURCE_TABLE_NAME%TYPE ;

3410: ln_app_to_doc_amt NUMBER ;
3411: ld_app_to_doc_date DATE ;
3412: ln_app_to_doc_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;
3413: ln_app_to_doc_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ;
3414: ln_app_to_doc_table JAI_RGM_REFS_ALL.SOURCE_TABLE_NAME%TYPE ;
3415: ln_to_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;
3416: ln_to_party_id JAI_RGM_REFS_ALL.PARTY_ID%TYPE ;
3417: ln_to_party_site_id JAI_RGM_REFS_ALL.PARTY_SITE_ID%TYPE ;
3418:

Line 3415: ln_to_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;

3411: ld_app_to_doc_date DATE ;
3412: ln_app_to_doc_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;
3413: ln_app_to_doc_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ;
3414: ln_app_to_doc_table JAI_RGM_REFS_ALL.SOURCE_TABLE_NAME%TYPE ;
3415: ln_to_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;
3416: ln_to_party_id JAI_RGM_REFS_ALL.PARTY_ID%TYPE ;
3417: ln_to_party_site_id JAI_RGM_REFS_ALL.PARTY_SITE_ID%TYPE ;
3418:
3419:

Line 3416: ln_to_party_id JAI_RGM_REFS_ALL.PARTY_ID%TYPE ;

3412: ln_app_to_doc_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;
3413: ln_app_to_doc_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ;
3414: ln_app_to_doc_table JAI_RGM_REFS_ALL.SOURCE_TABLE_NAME%TYPE ;
3415: ln_to_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;
3416: ln_to_party_id JAI_RGM_REFS_ALL.PARTY_ID%TYPE ;
3417: ln_to_party_site_id JAI_RGM_REFS_ALL.PARTY_SITE_ID%TYPE ;
3418:
3419:
3420: ln_app_amount NUMBER ;

Line 3417: ln_to_party_site_id JAI_RGM_REFS_ALL.PARTY_SITE_ID%TYPE ;

3413: ln_app_to_doc_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ;
3414: ln_app_to_doc_table JAI_RGM_REFS_ALL.SOURCE_TABLE_NAME%TYPE ;
3415: ln_to_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;
3416: ln_to_party_id JAI_RGM_REFS_ALL.PARTY_ID%TYPE ;
3417: ln_to_party_site_id JAI_RGM_REFS_ALL.PARTY_SITE_ID%TYPE ;
3418:
3419:
3420: ln_app_amount NUMBER ;
3421: ln_apportion_factor NUMBER ;

Line 3422: ln_app_ref_doc_id JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_ID%TYPE ;

3418:
3419:
3420: ln_app_amount NUMBER ;
3421: ln_apportion_factor NUMBER ;
3422: ln_app_ref_doc_id JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_ID%TYPE ;
3423: ln_app_ref_doc_type JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ;
3424: ln_app_ref_doc_table JAI_RGM_REFS_ALL.SOURCE_TABLE_NAME%TYPE ;
3425: ld_source_document_date JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_DATE%TYPE ;
3426: ln_parent_transaction_id JAI_RGM_REFS_ALL.parent_transaction_id%TYPE ;

Line 3423: ln_app_ref_doc_type JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ;

3419:
3420: ln_app_amount NUMBER ;
3421: ln_apportion_factor NUMBER ;
3422: ln_app_ref_doc_id JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_ID%TYPE ;
3423: ln_app_ref_doc_type JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ;
3424: ln_app_ref_doc_table JAI_RGM_REFS_ALL.SOURCE_TABLE_NAME%TYPE ;
3425: ld_source_document_date JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_DATE%TYPE ;
3426: ln_parent_transaction_id JAI_RGM_REFS_ALL.parent_transaction_id%TYPE ;
3427: ln_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;

Line 3424: ln_app_ref_doc_table JAI_RGM_REFS_ALL.SOURCE_TABLE_NAME%TYPE ;

3420: ln_app_amount NUMBER ;
3421: ln_apportion_factor NUMBER ;
3422: ln_app_ref_doc_id JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_ID%TYPE ;
3423: ln_app_ref_doc_type JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ;
3424: ln_app_ref_doc_table JAI_RGM_REFS_ALL.SOURCE_TABLE_NAME%TYPE ;
3425: ld_source_document_date JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_DATE%TYPE ;
3426: ln_parent_transaction_id JAI_RGM_REFS_ALL.parent_transaction_id%TYPE ;
3427: ln_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;
3428: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;

Line 3425: ld_source_document_date JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_DATE%TYPE ;

3421: ln_apportion_factor NUMBER ;
3422: ln_app_ref_doc_id JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_ID%TYPE ;
3423: ln_app_ref_doc_type JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ;
3424: ln_app_ref_doc_table JAI_RGM_REFS_ALL.SOURCE_TABLE_NAME%TYPE ;
3425: ld_source_document_date JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_DATE%TYPE ;
3426: ln_parent_transaction_id JAI_RGM_REFS_ALL.parent_transaction_id%TYPE ;
3427: ln_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;
3428: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;
3429: ln_party_id JAI_RGM_REFS_ALL.PARTY_ID%TYPE ;

Line 3426: ln_parent_transaction_id JAI_RGM_REFS_ALL.parent_transaction_id%TYPE ;

3422: ln_app_ref_doc_id JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_ID%TYPE ;
3423: ln_app_ref_doc_type JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ;
3424: ln_app_ref_doc_table JAI_RGM_REFS_ALL.SOURCE_TABLE_NAME%TYPE ;
3425: ld_source_document_date JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_DATE%TYPE ;
3426: ln_parent_transaction_id JAI_RGM_REFS_ALL.parent_transaction_id%TYPE ;
3427: ln_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;
3428: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;
3429: ln_party_id JAI_RGM_REFS_ALL.PARTY_ID%TYPE ;
3430: ln_party_site_id JAI_RGM_REFS_ALL.PARTY_SITE_ID%TYPE ;

Line 3427: ln_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;

3423: ln_app_ref_doc_type JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ;
3424: ln_app_ref_doc_table JAI_RGM_REFS_ALL.SOURCE_TABLE_NAME%TYPE ;
3425: ld_source_document_date JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_DATE%TYPE ;
3426: ln_parent_transaction_id JAI_RGM_REFS_ALL.parent_transaction_id%TYPE ;
3427: ln_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;
3428: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;
3429: ln_party_id JAI_RGM_REFS_ALL.PARTY_ID%TYPE ;
3430: ln_party_site_id JAI_RGM_REFS_ALL.PARTY_SITE_ID%TYPE ;
3431: ln_exchange_rate NUMBER ;

Line 3428: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;

3424: ln_app_ref_doc_table JAI_RGM_REFS_ALL.SOURCE_TABLE_NAME%TYPE ;
3425: ld_source_document_date JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_DATE%TYPE ;
3426: ln_parent_transaction_id JAI_RGM_REFS_ALL.parent_transaction_id%TYPE ;
3427: ln_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;
3428: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;
3429: ln_party_id JAI_RGM_REFS_ALL.PARTY_ID%TYPE ;
3430: ln_party_site_id JAI_RGM_REFS_ALL.PARTY_SITE_ID%TYPE ;
3431: ln_exchange_rate NUMBER ;
3432: rec_cur_get_app_to_det CUR_GET_APP_TO_DET%ROWTYPE ;

Line 3429: ln_party_id JAI_RGM_REFS_ALL.PARTY_ID%TYPE ;

3425: ld_source_document_date JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_DATE%TYPE ;
3426: ln_parent_transaction_id JAI_RGM_REFS_ALL.parent_transaction_id%TYPE ;
3427: ln_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;
3428: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;
3429: ln_party_id JAI_RGM_REFS_ALL.PARTY_ID%TYPE ;
3430: ln_party_site_id JAI_RGM_REFS_ALL.PARTY_SITE_ID%TYPE ;
3431: ln_exchange_rate NUMBER ;
3432: rec_cur_get_app_to_det CUR_GET_APP_TO_DET%ROWTYPE ;
3433: rec_cur_get_cr_details CUR_GET_CR_DETAILS%ROWTYPE ;

Line 3430: ln_party_site_id JAI_RGM_REFS_ALL.PARTY_SITE_ID%TYPE ;

3426: ln_parent_transaction_id JAI_RGM_REFS_ALL.parent_transaction_id%TYPE ;
3427: ln_organization_id JAI_RGM_REFS_ALL.ORGANIZATION_ID%TYPE ;
3428: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;
3429: ln_party_id JAI_RGM_REFS_ALL.PARTY_ID%TYPE ;
3430: ln_party_site_id JAI_RGM_REFS_ALL.PARTY_SITE_ID%TYPE ;
3431: ln_exchange_rate NUMBER ;
3432: rec_cur_get_app_to_det CUR_GET_APP_TO_DET%ROWTYPE ;
3433: rec_cur_get_cr_details CUR_GET_CR_DETAILS%ROWTYPE ;
3434: rec_cur_get_cm_details CUR_GET_CM_DETAILS%ROWTYPE ;

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

3813: ln_reg_id NUMBER;
3814: /*
3815: ||Get the parent record for an type of record
3816: */
3817: CURSOR cur_get_parent_trx ( cp_source_document_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE DEFAULT NULL ,
3818: cp_source_document_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ,
3819: cp_app_from_document_id JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE DEFAULT NULL ,
3820: cp_app_to_document_id JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE DEFAULT NULL
3821: )

Line 3818: cp_source_document_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ,

3814: /*
3815: ||Get the parent record for an type of record
3816: */
3817: CURSOR cur_get_parent_trx ( cp_source_document_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE DEFAULT NULL ,
3818: cp_source_document_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ,
3819: cp_app_from_document_id JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE DEFAULT NULL ,
3820: cp_app_to_document_id JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE DEFAULT NULL
3821: )
3822: IS

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

3815: ||Get the parent record for an type of record
3816: */
3817: CURSOR cur_get_parent_trx ( cp_source_document_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE DEFAULT NULL ,
3818: cp_source_document_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ,
3819: cp_app_from_document_id JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE DEFAULT NULL ,
3820: cp_app_to_document_id JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE DEFAULT NULL
3821: )
3822: IS
3823: SELECT

Line 3820: cp_app_to_document_id JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE DEFAULT NULL

3816: */
3817: CURSOR cur_get_parent_trx ( cp_source_document_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE DEFAULT NULL ,
3818: cp_source_document_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ,
3819: cp_app_from_document_id JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE DEFAULT NULL ,
3820: cp_app_to_document_id JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE DEFAULT NULL
3821: )
3822: IS
3823: SELECT
3824: to_number(max(transaction_id)) parent_transaction_id

Line 3826: jai_rgm_refs_all

3822: IS
3823: SELECT
3824: to_number(max(transaction_id)) parent_transaction_id
3825: FROM
3826: jai_rgm_refs_all
3827: WHERE
3828: source_document_id = nvl(cp_source_document_id , source_document_id)
3829: AND source_document_type = cp_source_document_type
3830: AND app_from_document_id = nvl(app_from_document_id , app_from_document_id )

Line 3833: ln_new_document_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;

3829: AND source_document_type = cp_source_document_type
3830: AND app_from_document_id = nvl(app_from_document_id , app_from_document_id )
3831: AND app_to_document_id = nvl(app_to_document_id , app_to_document_id ) ;
3832:
3833: ln_new_document_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;
3834: ln_source_document_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;
3835: ld_new_document_date JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_DATE%TYPE ;
3836: lv_source_document_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ;
3837: ln_app_from_document_id JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE ;

Line 3834: ln_source_document_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;

3830: AND app_from_document_id = nvl(app_from_document_id , app_from_document_id )
3831: AND app_to_document_id = nvl(app_to_document_id , app_to_document_id ) ;
3832:
3833: ln_new_document_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;
3834: ln_source_document_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;
3835: ld_new_document_date JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_DATE%TYPE ;
3836: lv_source_document_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ;
3837: ln_app_from_document_id JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE ;
3838: ln_app_to_document_id JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE ;

Line 3835: ld_new_document_date JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_DATE%TYPE ;

3831: AND app_to_document_id = nvl(app_to_document_id , app_to_document_id ) ;
3832:
3833: ln_new_document_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;
3834: ln_source_document_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;
3835: ld_new_document_date JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_DATE%TYPE ;
3836: lv_source_document_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ;
3837: ln_app_from_document_id JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE ;
3838: ln_app_to_document_id JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE ;
3839: ln_parent_transaction_id JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE ;

Line 3836: lv_source_document_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ;

3832:
3833: ln_new_document_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;
3834: ln_source_document_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;
3835: ld_new_document_date JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_DATE%TYPE ;
3836: lv_source_document_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ;
3837: ln_app_from_document_id JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE ;
3838: ln_app_to_document_id JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE ;
3839: ln_parent_transaction_id JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE ;
3840: lv_process_flag VARCHAR2(2) ;

Line 3837: ln_app_from_document_id JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE ;

3833: ln_new_document_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;
3834: ln_source_document_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;
3835: ld_new_document_date JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_DATE%TYPE ;
3836: lv_source_document_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ;
3837: ln_app_from_document_id JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE ;
3838: ln_app_to_document_id JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE ;
3839: ln_parent_transaction_id JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE ;
3840: lv_process_flag VARCHAR2(2) ;
3841: lv_process_message VARCHAR2(2000) ;

Line 3838: ln_app_to_document_id JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE ;

3834: ln_source_document_id JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ;
3835: ld_new_document_date JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_DATE%TYPE ;
3836: lv_source_document_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ;
3837: ln_app_from_document_id JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE ;
3838: ln_app_to_document_id JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE ;
3839: ln_parent_transaction_id JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE ;
3840: lv_process_flag VARCHAR2(2) ;
3841: lv_process_message VARCHAR2(2000) ;
3842:

Line 3839: ln_parent_transaction_id JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE ;

3835: ld_new_document_date JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_DATE%TYPE ;
3836: lv_source_document_type JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ;
3837: ln_app_from_document_id JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE ;
3838: ln_app_to_document_id JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE ;
3839: ln_parent_transaction_id JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE ;
3840: lv_process_flag VARCHAR2(2) ;
3841: lv_process_message VARCHAR2(2000) ;
3842:
3843: BEGIN

Line 4006: p_transaction_id IN JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE ,

4002: END process_unapp_rcpt_rev ;
4003:
4004:
4005: procedure insert_repository_references ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE DEFAULT NULL ,
4006: p_transaction_id IN JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE ,
4007: p_source_ref_document_id IN JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_ID%TYPE DEFAULT NULL ,
4008: p_source_ref_document_type IN JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ,
4009: p_app_from_document_id IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE DEFAULT NULL ,
4010: p_app_from_document_type IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_TYPE%TYPE DEFAULT NULL ,

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

4003:
4004:
4005: procedure insert_repository_references ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE DEFAULT NULL ,
4006: p_transaction_id IN JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE ,
4007: p_source_ref_document_id IN JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_ID%TYPE DEFAULT NULL ,
4008: p_source_ref_document_type IN JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ,
4009: p_app_from_document_id IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE DEFAULT NULL ,
4010: p_app_from_document_type IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_TYPE%TYPE DEFAULT NULL ,
4011: p_app_to_document_id IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE DEFAULT NULL ,

Line 4008: p_source_ref_document_type IN JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ,

4004:
4005: procedure insert_repository_references ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE DEFAULT NULL ,
4006: p_transaction_id IN JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE ,
4007: p_source_ref_document_id IN JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_ID%TYPE DEFAULT NULL ,
4008: p_source_ref_document_type IN JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ,
4009: p_app_from_document_id IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE DEFAULT NULL ,
4010: p_app_from_document_type IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_TYPE%TYPE DEFAULT NULL ,
4011: p_app_to_document_id IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE DEFAULT NULL ,
4012: p_app_to_document_type IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_TYPE%TYPE DEFAULT NULL ,

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

4005: procedure insert_repository_references ( p_regime_id IN JAI_RGM_DEFINITIONS.REGIME_ID%TYPE DEFAULT NULL ,
4006: p_transaction_id IN JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE ,
4007: p_source_ref_document_id IN JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_ID%TYPE DEFAULT NULL ,
4008: p_source_ref_document_type IN JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ,
4009: p_app_from_document_id IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE DEFAULT NULL ,
4010: p_app_from_document_type IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_TYPE%TYPE DEFAULT NULL ,
4011: p_app_to_document_id IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE DEFAULT NULL ,
4012: p_app_to_document_type IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_TYPE%TYPE DEFAULT NULL ,
4013: p_parent_transaction_id IN JAI_RGM_REFS_ALL.PARENT_TRANSACTION_ID%TYPE DEFAULT NULL ,

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

4006: p_transaction_id IN JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE ,
4007: p_source_ref_document_id IN JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_ID%TYPE DEFAULT NULL ,
4008: p_source_ref_document_type IN JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ,
4009: p_app_from_document_id IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE DEFAULT NULL ,
4010: p_app_from_document_type IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_TYPE%TYPE DEFAULT NULL ,
4011: p_app_to_document_id IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE DEFAULT NULL ,
4012: p_app_to_document_type IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_TYPE%TYPE DEFAULT NULL ,
4013: p_parent_transaction_id IN JAI_RGM_REFS_ALL.PARENT_TRANSACTION_ID%TYPE DEFAULT NULL ,
4014: p_org_tan_no IN JAI_RGM_REFS_ALL.ORG_TAN_NO%TYPE DEFAULT NULL ,

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

4007: p_source_ref_document_id IN JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_ID%TYPE DEFAULT NULL ,
4008: p_source_ref_document_type IN JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ,
4009: p_app_from_document_id IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE DEFAULT NULL ,
4010: p_app_from_document_type IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_TYPE%TYPE DEFAULT NULL ,
4011: p_app_to_document_id IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE DEFAULT NULL ,
4012: p_app_to_document_type IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_TYPE%TYPE DEFAULT NULL ,
4013: p_parent_transaction_id IN JAI_RGM_REFS_ALL.PARENT_TRANSACTION_ID%TYPE DEFAULT NULL ,
4014: p_org_tan_no IN JAI_RGM_REFS_ALL.ORG_TAN_NO%TYPE DEFAULT NULL ,
4015: p_document_id IN NUMBER ,

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

4008: p_source_ref_document_type IN JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ,
4009: p_app_from_document_id IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE DEFAULT NULL ,
4010: p_app_from_document_type IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_TYPE%TYPE DEFAULT NULL ,
4011: p_app_to_document_id IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE DEFAULT NULL ,
4012: p_app_to_document_type IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_TYPE%TYPE DEFAULT NULL ,
4013: p_parent_transaction_id IN JAI_RGM_REFS_ALL.PARENT_TRANSACTION_ID%TYPE DEFAULT NULL ,
4014: p_org_tan_no IN JAI_RGM_REFS_ALL.ORG_TAN_NO%TYPE DEFAULT NULL ,
4015: p_document_id IN NUMBER ,
4016: p_document_type IN VARCHAR2 ,

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

4009: p_app_from_document_id IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_ID%TYPE DEFAULT NULL ,
4010: p_app_from_document_type IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_TYPE%TYPE DEFAULT NULL ,
4011: p_app_to_document_id IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE DEFAULT NULL ,
4012: p_app_to_document_type IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_TYPE%TYPE DEFAULT NULL ,
4013: p_parent_transaction_id IN JAI_RGM_REFS_ALL.PARENT_TRANSACTION_ID%TYPE DEFAULT NULL ,
4014: p_org_tan_no IN JAI_RGM_REFS_ALL.ORG_TAN_NO%TYPE DEFAULT NULL ,
4015: p_document_id IN NUMBER ,
4016: p_document_type IN VARCHAR2 ,
4017: p_document_line_id IN NUMBER ,

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

4010: p_app_from_document_type IN JAI_RGM_REFS_ALL.APP_FROM_DOCUMENT_TYPE%TYPE DEFAULT NULL ,
4011: p_app_to_document_id IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_ID%TYPE DEFAULT NULL ,
4012: p_app_to_document_type IN JAI_RGM_REFS_ALL.APP_TO_DOCUMENT_TYPE%TYPE DEFAULT NULL ,
4013: p_parent_transaction_id IN JAI_RGM_REFS_ALL.PARENT_TRANSACTION_ID%TYPE DEFAULT NULL ,
4014: p_org_tan_no IN JAI_RGM_REFS_ALL.ORG_TAN_NO%TYPE DEFAULT NULL ,
4015: p_document_id IN NUMBER ,
4016: p_document_type IN VARCHAR2 ,
4017: p_document_line_id IN NUMBER ,
4018: p_document_date IN DATE ,

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

4023: p_organization_id IN NUMBER ,
4024: p_party_id IN NUMBER ,
4025: p_party_site_id IN NUMBER ,
4026: p_item_classification IN VARCHAR2 ,
4027: p_trx_ref_id OUT NOCOPY JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ,
4028: p_process_flag OUT NOCOPY VARCHAR2 ,
4029: p_process_message OUT NOCOPY VARCHAR2
4030: )
4031:

Line 4036: || for the table jai_rgm_refs_all

4032: IS
4033:
4034: /****
4035: ||Get the primary key
4036: || for the table jai_rgm_refs_all
4037: *****/
4038: ln_reg_id NUMBER;
4039: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;
4040: lv_org_tan_no JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;

Line 4041: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;

4037: *****/
4038: ln_reg_id NUMBER;
4039: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;
4040: lv_org_tan_no JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;
4041: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;
4042: lv_process_flag VARCHAR2(2) ;
4043: lv_process_message VARCHAR2(2000) ;
4044: ln_user_id JAI_RGM_REFS_ALL.CREATED_BY%TYPE ;
4045: ln_login_id JAI_RGM_REFS_ALL.LAST_UPDATE_LOGIN%TYPE ;

Line 4044: ln_user_id JAI_RGM_REFS_ALL.CREATED_BY%TYPE ;

4040: lv_org_tan_no JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;
4041: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;
4042: lv_process_flag VARCHAR2(2) ;
4043: lv_process_message VARCHAR2(2000) ;
4044: ln_user_id JAI_RGM_REFS_ALL.CREATED_BY%TYPE ;
4045: ln_login_id JAI_RGM_REFS_ALL.LAST_UPDATE_LOGIN%TYPE ;
4046: ln_fin_year JAI_AP_TDS_YEARS.FIN_YEAR%TYPE ;
4047: ln_source_ref_document_id JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_ID%TYPE ;
4048: ln_source_ref_document_type JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ;

Line 4045: ln_login_id JAI_RGM_REFS_ALL.LAST_UPDATE_LOGIN%TYPE ;

4041: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;
4042: lv_process_flag VARCHAR2(2) ;
4043: lv_process_message VARCHAR2(2000) ;
4044: ln_user_id JAI_RGM_REFS_ALL.CREATED_BY%TYPE ;
4045: ln_login_id JAI_RGM_REFS_ALL.LAST_UPDATE_LOGIN%TYPE ;
4046: ln_fin_year JAI_AP_TDS_YEARS.FIN_YEAR%TYPE ;
4047: ln_source_ref_document_id JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_ID%TYPE ;
4048: ln_source_ref_document_type JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ;
4049: ln_threshold_slab_id JAI_RGM_REFS_ALL.THRESHOLD_SLAB_ID%TYPE ;

Line 4047: ln_source_ref_document_id JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_ID%TYPE ;

4043: lv_process_message VARCHAR2(2000) ;
4044: ln_user_id JAI_RGM_REFS_ALL.CREATED_BY%TYPE ;
4045: ln_login_id JAI_RGM_REFS_ALL.LAST_UPDATE_LOGIN%TYPE ;
4046: ln_fin_year JAI_AP_TDS_YEARS.FIN_YEAR%TYPE ;
4047: ln_source_ref_document_id JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_ID%TYPE ;
4048: ln_source_ref_document_type JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ;
4049: ln_threshold_slab_id JAI_RGM_REFS_ALL.THRESHOLD_SLAB_ID%TYPE ;
4050: BEGIN
4051:

Line 4048: ln_source_ref_document_type JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ;

4044: ln_user_id JAI_RGM_REFS_ALL.CREATED_BY%TYPE ;
4045: ln_login_id JAI_RGM_REFS_ALL.LAST_UPDATE_LOGIN%TYPE ;
4046: ln_fin_year JAI_AP_TDS_YEARS.FIN_YEAR%TYPE ;
4047: ln_source_ref_document_id JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_ID%TYPE ;
4048: ln_source_ref_document_type JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ;
4049: ln_threshold_slab_id JAI_RGM_REFS_ALL.THRESHOLD_SLAB_ID%TYPE ;
4050: BEGIN
4051:
4052: /*################################################################################################################

Line 4049: ln_threshold_slab_id JAI_RGM_REFS_ALL.THRESHOLD_SLAB_ID%TYPE ;

4045: ln_login_id JAI_RGM_REFS_ALL.LAST_UPDATE_LOGIN%TYPE ;
4046: ln_fin_year JAI_AP_TDS_YEARS.FIN_YEAR%TYPE ;
4047: ln_source_ref_document_id JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_ID%TYPE ;
4048: ln_source_ref_document_type JAI_RGM_REFS_ALL.SOURCE_REF_DOCUMENT_TYPE%TYPE ;
4049: ln_threshold_slab_id JAI_RGM_REFS_ALL.THRESHOLD_SLAB_ID%TYPE ;
4050: BEGIN
4051:
4052: /*################################################################################################################
4053: || Initialize the variables

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

4171:
4172:
4173: /*commented by csahoo for bug# 6401388
4174: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4175: pv_log_msg => ' VALUES insert into JAI_RGM_REFS_ALL are : - ' ||fnd_global.local_chr(10)
4176: ||', trx_ref_id -> '||p_trx_ref_id ||fnd_global.local_chr(10)
4177: ||', regime_id -> '||ln_regime_id ||fnd_global.local_chr(10)
4178: ||', transaction_id -> '||p_transaction_id ||fnd_global.local_chr(10)
4179: ||', source_ref_document_id -> '||ln_source_ref_document_id ||fnd_global.local_chr(10)

Line 4212: INSERT into jai_rgm_refs_all (

4208: ||', settlement_id -> '||NULL ||fnd_global.local_chr(10)
4209: ||', certificate_id -> '||NULL
4210: );*/
4211:
4212: INSERT into jai_rgm_refs_all (
4213: trx_ref_id ,
4214: regime_id ,
4215: transaction_id ,
4216: source_ref_document_id ,

Line 4290: p_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ,

4286: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
4287: END insert_repository_references;
4288:
4289: procedure insert_repository_taxes (
4290: p_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ,
4291: p_tax_id JAI_RGM_TAXES.TAX_ID%TYPE ,
4292: p_tax_type JAI_RGM_TAXES.TAX_TYPE%TYPE ,
4293: p_tax_rate JAI_RGM_TAXES.TAX_RATE%TYPE ,
4294: p_tax_amount JAI_RGM_TAXES.TAX_AMT%TYPE ,

Line 4533: jai_rgm_refs_all

4529: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4530: pv_log_msg => ' Insert successful'
4531: );*/
4532: UPDATE
4533: jai_rgm_refs_all
4534: SET
4535: total_tax_amt = nvl(total_tax_amt,0) + nvl(p_tax_amount,0)
4536: WHERE
4537: trx_ref_id = p_trx_ref_id;

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

4537: trx_ref_id = p_trx_ref_id;
4538:
4539: /*commented by csahoo for bug# 6401388
4540: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4541: pv_log_msg => ' jai_rgm_refs_all.total_tax_amt successfully updated '
4542: );*/
4543: /*commented by csahoo for bug# 6401388
4544: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4545: pv_log_msg => '**************** END OF INSERT_REPOSITORY_TAXES ****************'

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

4547: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
4548: END insert_repository_taxes ;
4549:
4550:
4551: PROCEDURE copy_taxes_from_source ( p_source_document_type IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ,
4552: p_source_document_id IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ,
4553: p_source_document_line_id IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE DEFAULT NULL ,
4554: p_apportion_factor IN NUMBER DEFAULT NULL ,
4555: p_trx_ref_id IN JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ,

Line 4552: p_source_document_id IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ,

4548: END insert_repository_taxes ;
4549:
4550:
4551: PROCEDURE copy_taxes_from_source ( p_source_document_type IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ,
4552: p_source_document_id IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ,
4553: p_source_document_line_id IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE DEFAULT NULL ,
4554: p_apportion_factor IN NUMBER DEFAULT NULL ,
4555: p_trx_ref_id IN JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ,
4556: p_process_flag OUT NOCOPY VARCHAR2 ,

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

4549:
4550:
4551: PROCEDURE copy_taxes_from_source ( p_source_document_type IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ,
4552: p_source_document_id IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ,
4553: p_source_document_line_id IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE DEFAULT NULL ,
4554: p_apportion_factor IN NUMBER DEFAULT NULL ,
4555: p_trx_ref_id IN JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ,
4556: p_process_flag OUT NOCOPY VARCHAR2 ,
4557: p_process_message OUT NOCOPY VARCHAR2

Line 4555: p_trx_ref_id IN JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ,

4551: PROCEDURE copy_taxes_from_source ( p_source_document_type IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ,
4552: p_source_document_id IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ,
4553: p_source_document_line_id IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_LINE_ID%TYPE DEFAULT NULL ,
4554: p_apportion_factor IN NUMBER DEFAULT NULL ,
4555: p_trx_ref_id IN JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ,
4556: p_process_flag OUT NOCOPY VARCHAR2 ,
4557: p_process_message OUT NOCOPY VARCHAR2
4558: )
4559: IS

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

4756: );
4757: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
4758: END copy_taxes_from_source;
4759:
4760: PROCEDURE copy_references ( p_parent_transaction_id IN JAI_RGM_REFS_ALL.PARENT_TRANSACTION_ID%TYPE DEFAULT NULL ,
4761: p_new_document_id IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ,
4762: p_new_document_type IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ,
4763: p_new_document_date IN DATE ,
4764: p_apportion_factor IN NUMBER DEFAULT 1 ,

Line 4761: p_new_document_id IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ,

4757: jai_cmn_debug_contexts_pkg.deregister (pn_reg_id => ln_reg_id);*/
4758: END copy_taxes_from_source;
4759:
4760: PROCEDURE copy_references ( p_parent_transaction_id IN JAI_RGM_REFS_ALL.PARENT_TRANSACTION_ID%TYPE DEFAULT NULL ,
4761: p_new_document_id IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ,
4762: p_new_document_type IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ,
4763: p_new_document_date IN DATE ,
4764: p_apportion_factor IN NUMBER DEFAULT 1 ,
4765: p_process_flag OUT NOCOPY VARCHAR2 ,

Line 4762: p_new_document_type IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ,

4758: END copy_taxes_from_source;
4759:
4760: PROCEDURE copy_references ( p_parent_transaction_id IN JAI_RGM_REFS_ALL.PARENT_TRANSACTION_ID%TYPE DEFAULT NULL ,
4761: p_new_document_id IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_ID%TYPE ,
4762: p_new_document_type IN JAI_RGM_REFS_ALL.SOURCE_DOCUMENT_TYPE%TYPE ,
4763: p_new_document_date IN DATE ,
4764: p_apportion_factor IN NUMBER DEFAULT 1 ,
4765: p_process_flag OUT NOCOPY VARCHAR2 ,
4766: p_process_message OUT NOCOPY VARCHAR2

Line 4776: jai_rgm_refs_all

4772: IS
4773: SELECT
4774: *
4775: FROM
4776: jai_rgm_refs_all
4777: WHERE
4778: transaction_id = p_parent_transaction_id;
4779:
4780: CURSOR cur_get_rgm_taxes ( cp_trx_ref_id JAI_RGM_TAXES.TRX_REF_ID%TYPE )

Line 4790: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;

4786: WHERE
4787: trx_ref_id = cp_trx_ref_id;
4788:
4789: rec_cur_get_refs CUR_GET_REFS%ROWTYPE ;
4790: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;
4791: ln_tax_det_id JAI_RGM_TAXES.TAX_DET_ID%TYPE ;
4792: ln_apportion_ratio NUMBER ;
4793: ln_user_id JAI_RGM_REFS_ALL.CREATED_BY%TYPE ;
4794: ln_login_id JAI_RGM_REFS_ALL.LAST_UPDATE_LOGIN%TYPE ;

Line 4793: ln_user_id JAI_RGM_REFS_ALL.CREATED_BY%TYPE ;

4789: rec_cur_get_refs CUR_GET_REFS%ROWTYPE ;
4790: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;
4791: ln_tax_det_id JAI_RGM_TAXES.TAX_DET_ID%TYPE ;
4792: ln_apportion_ratio NUMBER ;
4793: ln_user_id JAI_RGM_REFS_ALL.CREATED_BY%TYPE ;
4794: ln_login_id JAI_RGM_REFS_ALL.LAST_UPDATE_LOGIN%TYPE ;
4795: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;
4796: lv_org_tan_no JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;
4797: ln_threshold_slab_id JAI_RGM_REFS_ALL.THRESHOLD_SLAB_ID%TYPE ;

Line 4794: ln_login_id JAI_RGM_REFS_ALL.LAST_UPDATE_LOGIN%TYPE ;

4790: ln_trx_ref_id JAI_RGM_REFS_ALL.TRX_REF_ID%TYPE ;
4791: ln_tax_det_id JAI_RGM_TAXES.TAX_DET_ID%TYPE ;
4792: ln_apportion_ratio NUMBER ;
4793: ln_user_id JAI_RGM_REFS_ALL.CREATED_BY%TYPE ;
4794: ln_login_id JAI_RGM_REFS_ALL.LAST_UPDATE_LOGIN%TYPE ;
4795: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;
4796: lv_org_tan_no JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;
4797: ln_threshold_slab_id JAI_RGM_REFS_ALL.THRESHOLD_SLAB_ID%TYPE ;
4798: lv_process_flag VARCHAR2(2) ;

Line 4797: ln_threshold_slab_id JAI_RGM_REFS_ALL.THRESHOLD_SLAB_ID%TYPE ;

4793: ln_user_id JAI_RGM_REFS_ALL.CREATED_BY%TYPE ;
4794: ln_login_id JAI_RGM_REFS_ALL.LAST_UPDATE_LOGIN%TYPE ;
4795: ln_regime_id JAI_RGM_DEFINITIONS.REGIME_ID%TYPE ;
4796: lv_org_tan_no JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;
4797: ln_threshold_slab_id JAI_RGM_REFS_ALL.THRESHOLD_SLAB_ID%TYPE ;
4798: lv_process_flag VARCHAR2(2) ;
4799: lv_process_message VARCHAR2(4000) ;
4800: BEGIN
4801:

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

4830: ln_login_id := fnd_global.login_id ;
4831:
4832:
4833: /*########################################################################################################
4834: || POPULATE JAI_RGM_REFS_ALL ---- PART -2
4835: ########################################################################################################*/
4836:
4837: /*
4838: ||Get the sequence generated unique key for the transaction

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

4853:
4854:
4855: /*commented by csahoo for bug# 6401388
4856: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4857: pv_log_msg => ' VALUES insert into JAI_RGM_REFS_ALL are : - ' ||fnd_global.local_chr(10)
4858: ||', regime_id -> '||rec_cur_get_refs.regime_id ||fnd_global.local_chr(10)
4859: ||', trx_ref_id -> '||ln_trx_ref_id ||fnd_global.local_chr(10)
4860: ||', transaction_id -> '||ln_transaction_id ||fnd_global.local_chr(10)
4861: ||', parent_transaction_id -> '||p_parent_transaction_id ||fnd_global.local_chr(10)

Line 4894: INSERT into jai_rgm_refs_all (

4890: ||', settlement_id -> '||NULL
4891: ||', certificate_id -> '||NULL
4892: );*/
4893:
4894: INSERT into jai_rgm_refs_all (
4895: trx_ref_id ,
4896: regime_id ,
4897: transaction_id ,
4898: parent_transaction_id ,

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

4965: );
4966:
4967: /*commented by csahoo for bug# 6401388
4968: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4969: pv_log_msg => ' After Insert into jai_rgm_refs_all'
4970: );*/
4971:
4972: /*
4973: ||Taxes needs to be copied from source

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

4983: CLOSE cur_get_tax_det_id;
4984:
4985: /*commented by csahoo for bug# 6401388
4986: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
4987: pv_log_msg => ' VALUES insert into JAI_RGM_REFS_ALL are : - ' ||fnd_global.local_chr(10)
4988: ||', tax_det_id -> '||ln_tax_det_id ||fnd_global.local_chr(10)
4989: ||', trx_ref_id -> '||ln_trx_ref_id ||fnd_global.local_chr(10)
4990: ||', tax_type -> '||rec_cur_get_rgm_taxes.tax_type ||fnd_global.local_chr(10)
4991: ||', tax_amt -> '||round( p_apportion_factor * rec_cur_get_rgm_taxes.tax_amt ) ||fnd_global.local_chr(10)

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

5041: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5042: pv_log_msg => ' After Insert into jai_rgm_taxes '
5043: );*/
5044: END LOOP; /* End of tax population */
5045: END LOOP; /*End of jai_rgm_refs_all population */
5046:
5047: /*commented by csahoo for bug# 6401388
5048: jai_cmn_debug_contexts_pkg.print ( pn_reg_id => ln_reg_id ,
5049: pv_log_msg => '**************** END OF COPY_REFERENCES ****************'

Line 5073: jai_rgm_refs_all jrra

5069: jrigd.rowid ,
5070: jrigd.generated_doc_id
5071: FROM
5072: jai_rgm_item_gen_docs jrigd,
5073: jai_rgm_refs_all jrra
5074: WHERE
5075: jrigd.generated_doc_trx_number = p_trx_number
5076: AND jrra.transaction_id = jrigd.transaction_id
5077: AND jrra.org_id = p_org_id

Line 5082: ln_user_id JAI_RGM_REFS_ALL.CREATED_BY%TYPE ;

5078: FOR UPDATE OF jrigd.generated_doc_id NOWAIT;
5079:
5080: lv_rowid ROWID ;
5081: ln_generated_doc_id JAI_RGM_ITEM_GEN_DOCS.GENERATED_DOC_ID%TYPE ;
5082: ln_user_id JAI_RGM_REFS_ALL.CREATED_BY%TYPE ;
5083: ln_login_id JAI_RGM_REFS_ALL.LAST_UPDATE_LOGIN%TYPE ;
5084:
5085: BEGIN
5086:

Line 5083: ln_login_id JAI_RGM_REFS_ALL.LAST_UPDATE_LOGIN%TYPE ;

5079:
5080: lv_rowid ROWID ;
5081: ln_generated_doc_id JAI_RGM_ITEM_GEN_DOCS.GENERATED_DOC_ID%TYPE ;
5082: ln_user_id JAI_RGM_REFS_ALL.CREATED_BY%TYPE ;
5083: ln_login_id JAI_RGM_REFS_ALL.LAST_UPDATE_LOGIN%TYPE ;
5084:
5085: BEGIN
5086:
5087: /*################################################################################################################

Line 5179: p_rgm_ref IN JAI_RGM_REFS_ALL%ROWTYPE ,

5175: END update_item_gen_docs;
5176:
5177:
5178: PROCEDURE generate_document (
5179: p_rgm_ref IN JAI_RGM_REFS_ALL%ROWTYPE ,
5180: p_total_tax_amt IN NUMBER ,
5181: p_process_flag OUT NOCOPY VARCHAR2 ,
5182: p_process_message OUT NOCOPY VARCHAR2
5183: )

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

5190:
5191: /*
5192: ||Customer would create a batch source with name TCS Debit Memo And TCS Credit Memo
5193: */
5194: CURSOR cur_get_batch_source ( cp_org_id JAI_RGM_REFS_ALL.ORG_ID%TYPE ,
5195: cp_name RA_BATCH_SOURCES_ALL.NAME%TYPE
5196: )
5197: IS
5198: SELECT

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

5211: AND bsa.org_id = rctt.org_id
5212: AND bsa.org_id = cp_org_id
5213: AND bsa.name = cp_name ;
5214:
5215: CURSOR cur_get_part_det ( cp_party_id JAI_RGM_REFS_ALL.PARTY_ID%TYPE ,
5216: cp_party_site_id JAI_RGM_REFS_ALL.PARTY_SITE_ID%TYPE
5217: )
5218: IS
5219: SELECT

Line 5216: cp_party_site_id JAI_RGM_REFS_ALL.PARTY_SITE_ID%TYPE

5212: AND bsa.org_id = cp_org_id
5213: AND bsa.name = cp_name ;
5214:
5215: CURSOR cur_get_part_det ( cp_party_id JAI_RGM_REFS_ALL.PARTY_ID%TYPE ,
5216: cp_party_site_id JAI_RGM_REFS_ALL.PARTY_SITE_ID%TYPE
5217: )
5218: IS
5219: SELECT
5220: hzcas.cust_acct_site_id bill_to_address_id

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

5228: AND hzcsu.site_use_code = jai_constants.site_use_bill_to
5229: AND hca.cust_account_id = cp_party_id
5230: AND hzcsu.site_use_id = cp_party_site_id ;-- site_use_id is the party_site_id ;
5231:
5232: CURSOR cur_get_sob ( cp_org_id jai_rgm_refs_all.org_id%TYPE )
5233: IS
5234: SELECT
5235: set_of_books_id
5236: FROM

Line 5242: CURSOR cur_get_salesrep_req_flag (cp_org_id jai_rgm_refs_all.org_id%TYPE )

5238: WHERE
5239: organization_id = cp_org_id ;
5240:
5241: /*--added for bug#8214204,start
5242: CURSOR cur_get_salesrep_req_flag (cp_org_id jai_rgm_refs_all.org_id%TYPE )
5243: IS
5244: SELECT salesrep_required_flag
5245: from ar_system_parameters_all
5246: where org_id = cp_org_id;

Line 5261: ln_user_id JAI_RGM_REFS_ALL.CREATED_BY%TYPE ;

5257: ln_ccid_tax_type_tcs NUMBER ;
5258: rec_cur_get_batch_source CUR_GET_BATCH_SOURCE%ROWTYPE ;
5259: lv_set_of_books_id HR_OPERATING_UNITS.SET_OF_BOOKS_ID%TYPE ;
5260: ln_amount NUMBER ;
5261: ln_user_id JAI_RGM_REFS_ALL.CREATED_BY%TYPE ;
5262: ln_login_id JAI_RGM_REFS_ALL.LAST_UPDATE_LOGIN%TYPE ;
5263: lv_process_message VARCHAR2(4000) ;
5264:
5265: BEGIN

Line 5262: ln_login_id JAI_RGM_REFS_ALL.LAST_UPDATE_LOGIN%TYPE ;

5258: rec_cur_get_batch_source CUR_GET_BATCH_SOURCE%ROWTYPE ;
5259: lv_set_of_books_id HR_OPERATING_UNITS.SET_OF_BOOKS_ID%TYPE ;
5260: ln_amount NUMBER ;
5261: ln_user_id JAI_RGM_REFS_ALL.CREATED_BY%TYPE ;
5262: ln_login_id JAI_RGM_REFS_ALL.LAST_UPDATE_LOGIN%TYPE ;
5263: lv_process_message VARCHAR2(4000) ;
5264:
5265: BEGIN
5266:

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

5867:
5868: ***************************************************************************/
5869:
5870:
5871: CURSOR cur_get_refs (cp_transaction_id JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE )
5872: IS
5873: SELECT
5874: *
5875: FROM

Line 5876: jai_rgm_refs_all ref

5872: IS
5873: SELECT
5874: *
5875: FROM
5876: jai_rgm_refs_all ref
5877: WHERE
5878: transaction_id = cp_transaction_id;
5879:
5880:

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

5877: WHERE
5878: transaction_id = cp_transaction_id;
5879:
5880:
5881: CURSOR cur_get_total_tax (cp_transaction_id JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE )
5882: IS
5883: SELECT
5884: sum(nvl(jrt.func_tax_amt,0)) total_tax_amount
5885: FROM

Line 5886: jai_rgm_refs_all jrra,

5882: IS
5883: SELECT
5884: sum(nvl(jrt.func_tax_amt,0)) total_tax_amount
5885: FROM
5886: jai_rgm_refs_all jrra,
5887: jai_rgm_taxes jrt
5888: WHERE
5889: jrra.trx_ref_id = jrt.trx_ref_id
5890: AND jrra.transaction_id = cp_transaction_id;

Line 5895: lv_item_classification JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;

5891:
5892: rec_cur_get_refs CUR_GET_REFS%ROWTYPE ;
5893: ln_tax_tot_amt NUMBER ;
5894: lv_document_type VARCHAR2(100) ;
5895: lv_item_classification JAI_RGM_REFS_ALL.ITEM_CLASSIFICATION%TYPE ;
5896: lv_process_flag VARCHAR2(2) ;
5897: lv_process_message VARCHAR2(2000) ;
5898:
5899: /* Added by JMEENA for TCS issue bug#7277211*/

Line 6614: p_party_id IN JAI_RGM_REFS_ALL.PARTY_ID%TYPE ,

6610: END process_transactions ;
6611:
6612: PROCEDURE update_pan_for_tcs ( p_return_code OUT NOCOPY VARCHAR2 ,
6613: p_errbuf OUT NOCOPY VARCHAR2 ,
6614: p_party_id IN JAI_RGM_REFS_ALL.PARTY_ID%TYPE ,
6615: p_old_pan_no IN JAI_CMN_CUS_ADDRESSES.PAN_NO%TYPE ,
6616: p_new_pan_no IN JAI_CMN_CUS_ADDRESSES.PAN_NO%TYPE
6617:
6618: )