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.ARP_MISC_CASH_DIST dependencies on AR_DISTRIBUTIONS

Line 9: TYPE ard_tbl_type IS TABLE of ar_distributions%ROWTYPE

5:
6: SUBTYPE l_ae_doc_rec_type IS arp_acct_main.ae_doc_rec_type ;
7: --
8: -- new type defined for 1543658
9: TYPE ard_tbl_type IS TABLE of ar_distributions%ROWTYPE
10: INDEX BY BINARY_INTEGER;
11: ard_tbl_tbl ard_tbl_type; --for 1543658
12:
13: TYPE mcd_tbl_type IS TABLE of ar_misc_cash_distributions%ROWTYPE

Line 58: l_ard_line_id ar_distributions.line_id%TYPE;-- for 1543658

54: ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,
55: p_form_name IN varchar2,
56: p_form_version IN varchar2
57: ) IS
58: l_ard_line_id ar_distributions.line_id%TYPE;-- for 1543658
59: l_ard_rec ar_distributions%ROWTYPE;-- for 1543658
60: l_ard_tax_source_id ar_distributions.source_id%TYPE;-- for 1543658
61: BEGIN
62:

Line 59: l_ard_rec ar_distributions%ROWTYPE;-- for 1543658

55: p_form_name IN varchar2,
56: p_form_version IN varchar2
57: ) IS
58: l_ard_line_id ar_distributions.line_id%TYPE;-- for 1543658
59: l_ard_rec ar_distributions%ROWTYPE;-- for 1543658
60: l_ard_tax_source_id ar_distributions.source_id%TYPE;-- for 1543658
61: BEGIN
62:
63: -- arp_standard.enable_debug;

Line 60: l_ard_tax_source_id ar_distributions.source_id%TYPE;-- for 1543658

56: p_form_version IN varchar2
57: ) IS
58: l_ard_line_id ar_distributions.line_id%TYPE;-- for 1543658
59: l_ard_rec ar_distributions%ROWTYPE;-- for 1543658
60: l_ard_tax_source_id ar_distributions.source_id%TYPE;-- for 1543658
61: BEGIN
62:
63: -- arp_standard.enable_debug;
64: IF PG_DEBUG in ('Y', 'C') THEN

Line 83: FROM ar_distributions

79: -- if arp_global.sysparam.accounting_method = 'ACCRUAL' then
80: --end 1813186
81: BEGIN
82: SELECT line_id into l_ard_line_id
83: FROM ar_distributions
84: WHERE source_id = p_mcd_id AND
85: source_table = 'MCD' AND
86: source_type ='MISCCASH' ;
87: ARP_DISTRIBUTIONS_PKG.delete_p(l_ard_line_id);

Line 91: FROM ar_distributions

87: ARP_DISTRIBUTIONS_PKG.delete_p(l_ard_line_id);
88:
89: BEGIN
90: SELECT * into l_ard_rec
91: FROM ar_distributions
92: WHERE source_id = p_mcd_id AND
93: source_table = 'MCD' AND
94: source_type ='TAX' AND
95: source_id in (select misc_cash_distribution_id

Line 97: where cash_receipt_id = ar_distributions.source_id_secondary

93: source_table = 'MCD' AND
94: source_type ='TAX' AND
95: source_id in (select misc_cash_distribution_id
96: from ar_misc_cash_distributions
97: where cash_receipt_id = ar_distributions.source_id_secondary
98: and reversal_gl_date is null);
99:
100: select nvl(min(source_id),0) into l_ard_tax_source_id
101: FROM ar_distributions

Line 101: FROM ar_distributions

97: where cash_receipt_id = ar_distributions.source_id_secondary
98: and reversal_gl_date is null);
99:
100: select nvl(min(source_id),0) into l_ard_tax_source_id
101: FROM ar_distributions
102: WHERE source_table = 'MCD' AND
103: source_type ='MISCCASH' AND
104: source_id in (select misc_cash_distribution_id
105: from ar_misc_cash_distributions

Line 197: p_amount_ard IN ar_distributions.amount_dr%TYPE,--for 1543658

193: p_ussgl_tc IN ar_misc_cash_distributions.ussgl_transaction_code%TYPE,
194: p_mcd_id OUT NOCOPY ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,
195: p_form_name IN varchar2,
196: p_form_version IN varchar2,
197: p_amount_ard IN ar_distributions.amount_dr%TYPE,--for 1543658
198: p_acctd_amount_ard IN ar_distributions.acctd_amount_dr%TYPE --for 1543658
199: ) IS
200: l_mcd_rec ar_misc_cash_distributions%ROWTYPE;
201: l_mcd_id ar_misc_cash_distributions.misc_cash_distribution_id%TYPE;

Line 198: p_acctd_amount_ard IN ar_distributions.acctd_amount_dr%TYPE --for 1543658

194: p_mcd_id OUT NOCOPY ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,
195: p_form_name IN varchar2,
196: p_form_version IN varchar2,
197: p_amount_ard IN ar_distributions.amount_dr%TYPE,--for 1543658
198: p_acctd_amount_ard IN ar_distributions.acctd_amount_dr%TYPE --for 1543658
199: ) IS
200: l_mcd_rec ar_misc_cash_distributions%ROWTYPE;
201: l_mcd_id ar_misc_cash_distributions.misc_cash_distribution_id%TYPE;
202: l_ae_doc_rec l_ae_doc_rec_type;

Line 203: l_ard_line_id ar_distributions.line_id%TYPE;

199: ) IS
200: l_mcd_rec ar_misc_cash_distributions%ROWTYPE;
201: l_mcd_id ar_misc_cash_distributions.misc_cash_distribution_id%TYPE;
202: l_ae_doc_rec l_ae_doc_rec_type;
203: l_ard_line_id ar_distributions.line_id%TYPE;
204: l_ard_rec ar_distributions%ROWTYPE;
205: l_ard_tax_rec ar_distributions%ROWTYPE;
206: l_ard_tax_rec_flag char(1);
207: l_ard_chk_first_rec char(1);

Line 204: l_ard_rec ar_distributions%ROWTYPE;

200: l_mcd_rec ar_misc_cash_distributions%ROWTYPE;
201: l_mcd_id ar_misc_cash_distributions.misc_cash_distribution_id%TYPE;
202: l_ae_doc_rec l_ae_doc_rec_type;
203: l_ard_line_id ar_distributions.line_id%TYPE;
204: l_ard_rec ar_distributions%ROWTYPE;
205: l_ard_tax_rec ar_distributions%ROWTYPE;
206: l_ard_tax_rec_flag char(1);
207: l_ard_chk_first_rec char(1);
208: l_cr_rec ar_cash_receipts%ROWTYPE;

Line 205: l_ard_tax_rec ar_distributions%ROWTYPE;

201: l_mcd_id ar_misc_cash_distributions.misc_cash_distribution_id%TYPE;
202: l_ae_doc_rec l_ae_doc_rec_type;
203: l_ard_line_id ar_distributions.line_id%TYPE;
204: l_ard_rec ar_distributions%ROWTYPE;
205: l_ard_tax_rec ar_distributions%ROWTYPE;
206: l_ard_tax_rec_flag char(1);
207: l_ard_chk_first_rec char(1);
208: l_cr_rec ar_cash_receipts%ROWTYPE;
209: l_tax_account_id ar_vat_tax.tax_account_id%TYPE; -- code_combination_id for tax

Line 214: -- this cursor stores all AR Distributions lines except the one

210: l_vat_tax_id ar_vat_tax.vat_tax_id%TYPE; -- tax_code_id
211: ard_tbl_ctr number := 0; --counter to store AR Distribution record
212: -- in plsql Table
213: -- for 1543658
214: -- this cursor stores all AR Distributions lines except the one
215: -- which is processed presently
216: -- and which is not a Tax line for the present receipt
217: CURSOR cr_ard_cur
218: (p_mcd_id in ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,

Line 222: FROM ar_distributions

218: (p_mcd_id in ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,
219: p_cash_receipt_id in ar_cash_receipts.cash_receipt_id%TYPE)
220: IS
221: SELECT *
222: FROM ar_distributions
223: WHERE source_table = 'MCD' AND
224: source_type ='MISCCASH' and
225: source_id in (select misc_cash_distribution_id
226: from ar_misc_cash_distributions

Line 265: -- of AR Distributions

261:
262: --begin 1543658
263: -- this select will fetch some important information
264: -- which we need to pass in the table handler
265: -- of AR Distributions
266: select cr.cash_receipt_id ,
267: cr.amount ,
268: cr.vat_tax_id ,
269: cr.tax_rate ,

Line 475: from ar_distributions

471: -- which will be deleted by arp_acct_main.Delete_Acct_Entry(l_ae_doc_rec);
472: -- In the next call storing it back by
473: -- "procedure ARP_DISTRIBUTIONS_PKG.insert_p(l_ard_tax_rec,l_ard_line_id);"
474: select * into l_ard_tax_rec
475: from ar_distributions
476: where source_type ='TAX' and
477: source_table ='MCD' and
478: source_type_secondary = 'MISCCASH' and
479: source_id in (select misc_cash_distribution_id

Line 507: DELETE FROM ar_distributions

503: /arp_global.base_precision)
504: *arp_global.base_precision;
505:
506: end if;
507: DELETE FROM ar_distributions
508: WHERE source_table = 'MCD' AND
509: source_type ='TAX' and
510: source_id = 0
511: RETURNING line_id

Line 526: -- this loop stores all AR Distributions lines except the one

522:
523: END;
524:
525:
526: -- this loop stores all AR Distributions lines except the one
527: -- which is processed presently and which is not a Tax line for
528: -- the present receipt in a plsql table
529: update_flag:='N';
530: FOR cr_ard_rec IN cr_ard_cur(l_mcd_id,l_cr_rec.cash_receipt_id) LOOP

Line 556: FROM ar_distributions

552: update_flag:='Y';
553: END LOOP;
554:
555: SELECT count(*) cnt into l_ard_cnt
556: FROM ar_distributions
557: WHERE source_table = 'MCD' AND
558: source_type ='MISCCASH' and
559: source_id in (select misc_cash_distribution_id
560: from ar_misc_cash_distributions

Line 740: p_amount_ard IN ar_distributions.amount_dr%TYPE,--for 1543658

736: p_acctd_amount IN ar_misc_cash_distributions.acctd_amount%TYPE,
737: p_ussgl_tc IN ar_misc_cash_distributions.ussgl_transaction_code%TYPE,
738: p_form_name IN varchar2,
739: p_form_version IN varchar2,
740: p_amount_ard IN ar_distributions.amount_dr%TYPE,--for 1543658
741: p_acctd_amount_ard IN ar_distributions.acctd_amount_dr%TYPE --for 1543658
742: ) IS
743:
744: l_mcd_rec ar_misc_cash_distributions%ROWTYPE;

Line 741: p_acctd_amount_ard IN ar_distributions.acctd_amount_dr%TYPE --for 1543658

737: p_ussgl_tc IN ar_misc_cash_distributions.ussgl_transaction_code%TYPE,
738: p_form_name IN varchar2,
739: p_form_version IN varchar2,
740: p_amount_ard IN ar_distributions.amount_dr%TYPE,--for 1543658
741: p_acctd_amount_ard IN ar_distributions.acctd_amount_dr%TYPE --for 1543658
742: ) IS
743:
744: l_mcd_rec ar_misc_cash_distributions%ROWTYPE;
745: l_ard_line_id ar_distributions.line_id%TYPE;

Line 745: l_ard_line_id ar_distributions.line_id%TYPE;

741: p_acctd_amount_ard IN ar_distributions.acctd_amount_dr%TYPE --for 1543658
742: ) IS
743:
744: l_mcd_rec ar_misc_cash_distributions%ROWTYPE;
745: l_ard_line_id ar_distributions.line_id%TYPE;
746: l_ard_rec ar_distributions%ROWTYPE;
747: l_ard_tax_rec ar_distributions%ROWTYPE;
748: l_ard_tax_rec_flag char(1);
749: l_ard_chk_first_rec char(1);

Line 746: l_ard_rec ar_distributions%ROWTYPE;

742: ) IS
743:
744: l_mcd_rec ar_misc_cash_distributions%ROWTYPE;
745: l_ard_line_id ar_distributions.line_id%TYPE;
746: l_ard_rec ar_distributions%ROWTYPE;
747: l_ard_tax_rec ar_distributions%ROWTYPE;
748: l_ard_tax_rec_flag char(1);
749: l_ard_chk_first_rec char(1);
750: l_cr_rec ar_cash_receipts%ROWTYPE;

Line 747: l_ard_tax_rec ar_distributions%ROWTYPE;

743:
744: l_mcd_rec ar_misc_cash_distributions%ROWTYPE;
745: l_ard_line_id ar_distributions.line_id%TYPE;
746: l_ard_rec ar_distributions%ROWTYPE;
747: l_ard_tax_rec ar_distributions%ROWTYPE;
748: l_ard_tax_rec_flag char(1);
749: l_ard_chk_first_rec char(1);
750: l_cr_rec ar_cash_receipts%ROWTYPE;
751: l_tax_account_id ar_vat_tax.tax_account_id%TYPE; -- code_combination_id for tax

Line 756: -- this cursor stores all AR Distributions lines except the one

752: l_vat_tax_id ar_vat_tax.vat_tax_id%TYPE; -- tax_code_id
753: ard_tbl_ctr number := 0; --counter to store AR Distribution record
754: -- in plsql Table
755: -- for 1543658
756: -- this cursor stores all AR Distributions lines except the one
757: -- which is processed presently
758: -- and which is not a Tax line for the present receipt
759:
760: CURSOR cr_ard_cur

Line 765: FROM ar_distributions

761: (p_mcd_id in ar_misc_cash_distributions.misc_cash_distribution_id%TYPE,
762: p_cash_receipt_id in ar_cash_receipts.cash_receipt_id%TYPE)
763: IS
764: SELECT *
765: FROM ar_distributions
766: WHERE source_table = 'MCD' AND
767: source_type ='MISCCASH' and
768: source_id in (select misc_cash_distribution_id
769: from ar_misc_cash_distributions

Line 811: -- of AR Distributions

807: arp_misc_cash_dist_pkg.fetch_p(p_misc_cash_distribution_id, l_mcd_rec);
808: --begin 1543658
809: -- this select will fetch some important information
810: -- which we need to pass in the table handler
811: -- of AR Distributions
812: select cr.cash_receipt_id ,
813: cr.amount ,
814: cr.vat_tax_id ,
815: cr.tax_rate ,

Line 1043: from ar_distributions

1039: -- which will be deleted by arp_acct_main.Delete_Acct_Entry(l_ae_doc_rec);
1040: -- In the next call storing it back by
1041: -- "procedure ARP_DISTRIBUTIONS_PKG.insert_p(l_ard_tax_rec,l_ard_line_id);"
1042: select * into l_ard_tax_rec
1043: from ar_distributions
1044: where source_type ='TAX' and
1045: source_table ='MCD' and
1046: source_type_secondary = 'MISCCASH' and
1047: source_id in (select misc_cash_distribution_id

Line 1083: -- this loop stores all AR Distributions lines except the one

1079: END IF;
1080: l_ard_tax_rec_flag:='N';
1081: END;
1082:
1083: -- this loop stores all AR Distributions lines except the one
1084: -- which is processed presently and which is not a Tax line for
1085: -- the present receipt in a plsql table
1086:
1087: update_flag:='N';

Line 1112: FROM ar_distributions

1108: END LOOP;
1109:
1110: -- begin bug5655154, added to check if distributions exists or not
1111: SELECT count(*) cnt into l_ard_cnt
1112: FROM ar_distributions
1113: WHERE source_table = 'MCD' AND
1114: source_type ='MISCCASH' and
1115: source_id in ( select misc_cash_distribution_id
1116: from ar_misc_cash_distributions

Line 1276: | amount from ar_distributions table isntead of|

1272: | MODIFICATION HISTORY |
1273: | |
1274: | 05-OCT-95 OSTEINME created |
1275: | 09-SEP-99 GJWANG 941243: when distribution amount change, lock|
1276: | amount from ar_distributions table isntead of|
1277: | ar_misc_cash_distributions table |
1278: | 30-DEC-02 MRAMANAT Bugfix 2626083. Added code to compare |
1279: | gl_posted_date. |
1280: | |

Line 1316: l_dist_rec ar_distributions%ROWTYPE;

1312: ) IS
1313:
1314: l_mcd_rec ar_misc_cash_distributions%ROWTYPE;
1315: l_dist_rec_amt NUMBER;
1316: l_dist_rec ar_distributions%ROWTYPE;
1317: l_ard_cnt NUMBER := 0 ;
1318: BEGIN
1319:
1320: -- arp_standard.enable_debug;

Line 1344: FROM ar_distributions

1340: END IF;
1341:
1342: -- begin, bug5655154, to check if distributions already exist or not
1343: SELECT count(*) cnt into l_ard_cnt
1344: FROM ar_distributions
1345: WHERE source_table = 'MCD' AND
1346: source_type = 'MISCCASH' and
1347: source_id = p_misc_cash_distribution_id ;
1348:

Line 1354: FROM ar_distributions

1350: SELECT decode(sign(p_amount), 1, amount_cr,
1351: 0, amount_cr,
1352: -1, amount_dr )
1353: INTO l_dist_rec_amt
1354: FROM ar_distributions
1355: WHERE source_id = p_misc_cash_distribution_id
1356: AND source_table = 'MCD'
1357: AND source_type = 'MISCCASH'
1358: FOR UPDATE OF source_id NOWAIT;

Line 1550: -- of AR Distributions

1546: p_flag := 0;
1547:
1548: -- this select will fetch some important information
1549: -- which we need to pass in the table handler
1550: -- of AR Distributions
1551: select cr.cash_receipt_id ,
1552: cr.amount ,
1553: cr.vat_tax_id ,
1554: cr.tax_rate ,

Line 1674: FROM ar_distributions

1670: SELECT NVL(SUM(acctd_amount_cr),0),
1671: NVL(SUM(acctd_amount_dr),0)
1672: INTO l_ard_acctd_cr,
1673: l_ard_acctd_dr
1674: FROM ar_distributions
1675: where source_id in (select misc_cash_distribution_id
1676: from ar_misc_cash_distributions
1677: where cash_receipt_id = p_cash_receipt_id
1678: and reversal_gl_date is null ) and

Line 1695: UPDATE ar_distributions

1691:
1692:
1693: IF (l_ard_acctd_dr_rounding_diff <> 0) THEN
1694:
1695: UPDATE ar_distributions
1696: SET acctd_amount_dr = acctd_amount_dr + l_ard_acctd_dr_rounding_diff
1697:
1698: WHERE source_id in (select misc_cash_distribution_id
1699: from ar_misc_cash_distributions

Line 1710: UPDATE ar_distributions

1706: p_flag :=p_flag +1;
1707: END IF;
1708: IF (l_ard_acctd_cr_rounding_diff <>0) THEN
1709:
1710: UPDATE ar_distributions
1711: SET acctd_amount_cr = acctd_amount_cr + l_ard_acctd_cr_rounding_diff
1712: WHERE source_id in (select misc_cash_distribution_id
1713: from ar_misc_cash_distributions
1714: where cash_receipt_id = p_cash_receipt_id

Line 1747: from ar_distributions

1743:
1744: BEGIN
1745: BEGIN
1746: select code_combination_id into return_value
1747: from ar_distributions
1748: where source_id in (select MIN(misc_cash_distribution_id)
1749: from ar_misc_cash_distributions
1750: where cash_receipt_id=p_cash_receipt_id)
1751: and SOURCE_TABLE ='MCD'