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_RGM_THHOLD_PROC_PKG dependencies on JAI_RGM_REFS_ALL

Line 43: ,p_transaction_id in jai_rgm_refs_all.transaction_id%type

39: end set_debug_context;
40: /*------------------------------------------END - PRIVATE MEMBERS DECLRATION --------------------------------*/
41: procedure generate_consolidated_doc
42: (p_threshold_id in jai_rgm_thresholds.threshold_id%type
43: ,p_transaction_id in jai_rgm_refs_all.transaction_id%type
44: ,p_org_id in jai_rgm_refs_all.org_id%type
45: ,p_process_flag out nocopy varchar2
46: ,p_process_message out nocopy varchar2
47: )

Line 44: ,p_org_id in jai_rgm_refs_all.org_id%type

40: /*------------------------------------------END - PRIVATE MEMBERS DECLRATION --------------------------------*/
41: procedure generate_consolidated_doc
42: (p_threshold_id in jai_rgm_thresholds.threshold_id%type
43: ,p_transaction_id in jai_rgm_refs_all.transaction_id%type
44: ,p_org_id in jai_rgm_refs_all.org_id%type
45: ,p_process_flag out nocopy varchar2
46: ,p_process_message out nocopy varchar2
47: )
48: is

Line 66: ln_trx_ref_id jai_rgm_refs_all.trx_ref_id%type;

62: ln_surcharge_cess_tax_id jai_rgm_taxes.tax_id%type;
63: ln_surcharge_tax_rate jai_rgm_taxes.tax_rate%type;
64: ln_surcharge_cess_tax_rate jai_rgm_taxes.tax_rate%type;
65:
66: ln_trx_ref_id jai_rgm_refs_all.trx_ref_id%type;
67: ln_currency_code jai_rgm_taxes.currency_code%type;
68:
69: ln_user_id fnd_user.user_id%type := fnd_global.user_id;
70: ln_login_id fnd_logins.login_id%type := fnd_global.login_id;

Line 96: cursor c_curr_code (cp_org_id jai_rgm_refs_all.org_id%type)

92: ,jai_rgm_thresholds hdr
93: where hdr.threshold_id = p_threshold_id
94: and dtls.threshold_id = hdr.threshold_id ;
95:
96: cursor c_curr_code (cp_org_id jai_rgm_refs_all.org_id%type)
97: is
98: select currency_code
99: from gl_sets_of_books gsb
100: , hr_operating_units hou

Line 104: cursor c_get_ref_dtls (cp_transaction_id jai_rgm_refs_all.transaction_id%type default null

100: , hr_operating_units hou
101: where gsb.set_of_books_id = hou.set_of_books_id
102: and hou.organization_id = cp_org_id;
103:
104: cursor c_get_ref_dtls (cp_transaction_id jai_rgm_refs_all.transaction_id%type default null
105: ,cp_trx_ref_id jai_rgm_refs_all.trx_ref_id%type default null
106: )
107: is
108: select *

Line 105: ,cp_trx_ref_id jai_rgm_refs_all.trx_ref_id%type default null

101: where gsb.set_of_books_id = hou.set_of_books_id
102: and hou.organization_id = cp_org_id;
103:
104: cursor c_get_ref_dtls (cp_transaction_id jai_rgm_refs_all.transaction_id%type default null
105: ,cp_trx_ref_id jai_rgm_refs_all.trx_ref_id%type default null
106: )
107: is
108: select *
109: from jai_rgm_refs_all

Line 109: from jai_rgm_refs_all

105: ,cp_trx_ref_id jai_rgm_refs_all.trx_ref_id%type default null
106: )
107: is
108: select *
109: from jai_rgm_refs_all
110: where ( (cp_transaction_id is not null and transaction_id = cp_transaction_id)
111: or (cp_trx_ref_id is not null and trx_ref_id = cp_trx_ref_id)
112: );
113:

Line 114: cursor c_get_taxes_for_last_doc ( cp_org_tan_no jai_rgm_refs_all.org_tan_no%type

110: where ( (cp_transaction_id is not null and transaction_id = cp_transaction_id)
111: or (cp_trx_ref_id is not null and trx_ref_id = cp_trx_ref_id)
112: );
113:
114: cursor c_get_taxes_for_last_doc ( cp_org_tan_no jai_rgm_refs_all.org_tan_no%type
115: , cp_party_id jai_rgm_refs_all.party_id%type
116: , cp_fin_year jai_rgm_refs_all.fin_year%type
117: , cp_item_classification jai_rgm_refs_all.item_classification%type
118: )

Line 115: , cp_party_id jai_rgm_refs_all.party_id%type

111: or (cp_trx_ref_id is not null and trx_ref_id = cp_trx_ref_id)
112: );
113:
114: cursor c_get_taxes_for_last_doc ( cp_org_tan_no jai_rgm_refs_all.org_tan_no%type
115: , cp_party_id jai_rgm_refs_all.party_id%type
116: , cp_fin_year jai_rgm_refs_all.fin_year%type
117: , cp_item_classification jai_rgm_refs_all.item_classification%type
118: )
119: is

Line 116: , cp_fin_year jai_rgm_refs_all.fin_year%type

112: );
113:
114: cursor c_get_taxes_for_last_doc ( cp_org_tan_no jai_rgm_refs_all.org_tan_no%type
115: , cp_party_id jai_rgm_refs_all.party_id%type
116: , cp_fin_year jai_rgm_refs_all.fin_year%type
117: , cp_item_classification jai_rgm_refs_all.item_classification%type
118: )
119: is
120: select tax_id

Line 117: , cp_item_classification jai_rgm_refs_all.item_classification%type

113:
114: cursor c_get_taxes_for_last_doc ( cp_org_tan_no jai_rgm_refs_all.org_tan_no%type
115: , cp_party_id jai_rgm_refs_all.party_id%type
116: , cp_fin_year jai_rgm_refs_all.fin_year%type
117: , cp_item_classification jai_rgm_refs_all.item_classification%type
118: )
119: is
120: select tax_id
121: ,tax_type

Line 125: from jai_rgm_refs_all

121: ,tax_type
122: ,tax_rate
123: from jai_rgm_taxes
124: where trx_ref_id = ( select max(trx_ref_id)
125: from jai_rgm_refs_all
126: where source_document_id = jai_constants.tcs_surcharge_id
127: and org_tan_no = cp_org_tan_no
128: and fin_year = cp_fin_year
129: and party_id = cp_party_id

Line 136: ln_transaction_id JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE;

132: );
133:
134:
135: r_ref_dtls c_get_ref_dtls%rowtype;
136: ln_transaction_id JAI_RGM_REFS_ALL.TRANSACTION_ID%TYPE;
137:
138: /*
139: || Generate the transaction_id from the sequence
140: */

Line 144: jai_rgm_refs_all_s2.nextval

140: */
141: CURSOR cur_get_transaction_id
142: IS
143: SELECT
144: jai_rgm_refs_all_s2.nextval
145: FROM
146: dual;
147:
148:

Line 1346: ( p_transaction_id in jai_rgm_refs_all.transaction_id%type

1342: end default_thhold_taxes;
1343:
1344: /*------------------------------------------------------------------------------------------------------------*/
1345: procedure maintain_threshold
1346: ( p_transaction_id in jai_rgm_refs_all.transaction_id%type
1347: , p_last_line_flag in varchar2 default jai_constants.yes
1348: , p_process_flag out nocopy varchar2
1349: , p_process_message out nocopy varchar2
1350: )

Line 1367: from jai_rgm_refs_all trxref

1363: , source_document_type
1364: , sum(nvl(source_document_amt,0)) source_document_amt
1365: , source_document_date
1366: , org_id
1367: from jai_rgm_refs_all trxref
1368: where trxref.transaction_id = p_transaction_id
1369: group by
1370: regime_id
1371: , org_tan_no

Line 1426: , jai_rgm_refs_all refs

1422: cursor c_get_ref_thhold_base_amt (cp_base_tax_type jai_rgm_taxes.tax_type%type)
1423: is
1424: select sum(rtax.func_tax_amt)
1425: from jai_rgm_taxes rtax
1426: , jai_rgm_refs_all refs
1427: where rtax.trx_ref_id = refs.trx_ref_id
1428: and refs.transaction_id = p_transaction_id
1429: and rtax.tax_type = cp_base_tax_type;
1430:

Line 1437: , jai_rgm_refs_all refs

1433: )
1434: is
1435: select sum(rtax.func_tax_amt)
1436: from jai_rgm_taxes rtax
1437: , jai_rgm_refs_all refs
1438: where rtax.trx_ref_id = refs.trx_ref_id
1439: and rtax.tax_type = cp_tax_type
1440: and refs.transaction_id = p_transaction_id
1441: and rtax.tax_modified_by = nvl(cp_tax_modified_by,rtax.tax_modified_by);

Line 1454: , jai_rgm_refs_all refs

1450: cursor c_get_surcharge_cess (cp_thhold_tax_cat_id jai_ap_tds_thhold_taxes.tax_category_id%type)
1451: is
1452: select sum(rtax.func_tax_amt)
1453: from jai_rgm_taxes rtax
1454: , jai_rgm_refs_all refs
1455: , JAI_CMN_TAX_CTG_LINES srch
1456: , JAI_CMN_TAX_CTG_LINES srchcess
1457: , JAI_CMN_TAXES_ALL tax
1458: where rtax.trx_ref_id = refs.trx_ref_id

Line 1474: , jai_rgm_refs_all refs

1470: cursor c_get_surcharge_sh_cess (cp_thhold_tax_cat_id jai_ap_tds_thhold_taxes.tax_category_id%type)
1471: is
1472: select sum(rtax.func_tax_amt)
1473: from jai_rgm_taxes rtax
1474: , jai_rgm_refs_all refs
1475: , JAI_CMN_TAX_CTG_LINES srch
1476: , JAI_CMN_TAX_CTG_LINES srchcess
1477: , JAI_CMN_TAXES_ALL tax
1478: where rtax.trx_ref_id = refs.trx_ref_id

Line 1940: /** Update jai_rgm_refs_all to punch the threshold_slab_id against all the transaction lines */

1936: if p_process_flag <> jai_constants.successful then
1937: return;
1938: end if;
1939:
1940: /** Update jai_rgm_refs_all to punch the threshold_slab_id against all the transaction lines */
1941:
1942: if ln_new_thhold_slab_id is not null then
1943: update jai_rgm_refs_all
1944: set threshold_slab_id = ln_new_thhold_slab_id

Line 1943: update jai_rgm_refs_all

1939:
1940: /** Update jai_rgm_refs_all to punch the threshold_slab_id against all the transaction lines */
1941:
1942: if ln_new_thhold_slab_id is not null then
1943: update jai_rgm_refs_all
1944: set threshold_slab_id = ln_new_thhold_slab_id
1945: where transaction_id = p_transaction_id;
1946: end if;
1947: