[Home] [Help]
29: --org_id added as part of MOAC uptake
30: CURSOR get_candidate_packages IS
31: SELECT distinct package_id,
32: netting_trx_type_id
33: FROM igi_stp_candidates_all
34: WHERE batch_id =p_batch_id
35: AND org_id = p_org_id;
36:
37: -- get_ap_amount : to calculate the sum of the invoice
37: -- get_ap_amount : to calculate the sum of the invoice
38: -- amounts selected for a package and netting transaction
39: CURSOR get_ap_amount IS
40: SELECT sum(amount) ap_amount
41: FROM igi_stp_candidates
42: WHERE batch_id = p_batch_id
43: AND application = 'AP'
44: AND netting_trx_type_id = p_netting_trx_type_id
45: AND package_id = p_package_id;
47: -- get_ar_amount : to calculate the sum of the invoice
48: -- amounts selected for a package and netting transaction
49: CURSOR get_ar_amount IS
50: SELECT sum(amount) ar_amount
51: FROM igi_stp_candidates_ALL
52: WHERE batch_id = p_batch_id
53: AND application = 'AR'
54: AND ORG_ID = P_ORG_ID
55: AND netting_trx_type_id = p_netting_trx_type_id
61: -- amounts selected for a package and netting transaction
62: /*
63: CURSOR get_ap_only_amount IS
64: SELECT sum(amount) ap_amount
65: FROM igi_stp_candidates cand,
66: igi_stp_net_type_alloc net
67: WHERE cand.batch_id = p_batch_id
68: AND cand.application = 'AP'
69: AND cand.netting_trx_type_id = p_netting_trx_type_id
100: currency_code,
101: exchange_rate,
102: exchange_rate_type,
103: exchange_date
104: FROM igi_stp_candidates
105: WHERE batch_id = p_batch_id
106: AND package_id = p_package_id
107: AND netting_trx_type_id = p_netting_trx_type_id
108: AND process_flag = 'S'
123: currency_code,
124: exchange_rate,
125: exchange_rate_type,
126: exchange_date
127: FROM igi_stp_candidates
128: WHERE batch_id = p_batch_id
129: AND package_id = p_package_id
130: AND netting_trx_type_id = p_netting_trx_type_id
131: AND process_flag = 'S'
147: currency_code,
148: exchange_rate,
149: exchange_rate_type,
150: exchange_date
151: FROM igi_stp_candidates_all cand,
152: igi_stp_net_type_alloc_all net
153: WHERE cand.batch_id = p_batch_id
154: AND cand.package_id = p_package_id
155: AND cand.netting_trx_type_id = p_netting_trx_type_id
358: IS
359: BEGIN
360: -- Delete Candidates --
361: --ssemwal for Bug 2437020 included where condition
362: DELETE FROM igi_stp_candidates
363: WHERE user_id = p_user_id ;
364: --shsaxena for bug 2713715
365: -- and process_flag = 'R';
366: --shsaxena for bug 2713715
466: SELECT dist.code_combination_id
467: INTO l_rec_ccid
468: FROM ra_customer_trx trx,
469: ra_cust_trx_line_gl_dist dist,
470: igi_stp_candidates candidates
471: WHERE dist.customer_trx_id = trx.customer_trx_id
472: AND dist.account_class = 'REC'
473: AND trx.trx_number = candidates.trx_number
474: AND candidates.package_id = p_package_id
543: IF l_liability_ccid is null THEN
544: SELECT api.accts_pay_code_combination_id
545: INTO l_liability_ccid
546: FROM ap_invoices api,
547: igi_stp_candidates candidates
548: WHERE api.invoice_id = candidates.trx_id
549: AND candidates.package_id = p_package_id
550: AND candidates.netting_trx_type_id = p_netting_trx_type_id
551: AND candidates.batch_id = p_batch_id
707: THEN
708: SELECT api.accts_pay_code_combination_id
709: INTO l_liability_ccid
710: FROM ap_invoices_all api,
711: igi_stp_candidates_all candidates
712: WHERE api.invoice_id = candidates.trx_id
713: AND candidates.package_id = p_package_id
714: AND candidates.netting_trx_type_id = p_netting_trx_type_id
715: AND candidates.batch_id = p_batch_id
1035: SELECT dist.code_combination_id
1036: INTO l_rec_ccid
1037: FROM ra_customer_trx trx,
1038: ra_cust_trx_line_gl_dist dist,
1039: igi_stp_candidates candidates
1040: WHERE dist.customer_trx_id = trx.customer_trx_id
1041: AND dist.account_class = 'REC'
1042: AND trx.trx_number = candidates.trx_number
1043: AND candidates.package_id = p_package_id
1181: IF l_liability_ccid is null THEN
1182: SELECT api.accts_pay_code_combination_id
1183: INTO l_liability_ccid
1184: FROM ap_invoices api,
1185: igi_stp_candidates candidates
1186: WHERE api.invoice_id = candidates.trx_id
1187: AND candidates.package_id = p_package_id
1188: AND candidates.netting_trx_type_id = p_netting_trx_type_id
1189: AND candidates.batch_id = p_batch_id