APPS.ARP_MISC_CASH_DIST dependencies on ARP_DISTRIBUTIONS_PKG

Line 87: ARP_DISTRIBUTIONS_PKG.delete_p(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);
88:
89: BEGIN
90: SELECT * into l_ard_rec
91: FROM ar_distributions

Line 109: ARP_DISTRIBUTIONS_PKG.update_p(l_ard_rec);

105: from ar_misc_cash_distributions
106: where cash_receipt_id = l_ard_rec.source_id_secondary
107: and reversal_gl_date is null);
108: l_ard_rec.source_id := l_ard_tax_source_id;
109: ARP_DISTRIBUTIONS_PKG.update_p(l_ard_rec);
110:
111:
112: EXCEPTION
113: WHEN no_data_found then

Line 473: -- "procedure ARP_DISTRIBUTIONS_PKG.insert_p(l_ard_tax_rec,l_ard_line_id);"

469: BEGIN
470: -- to select the tax record of AR distribution in local variable
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

Line 572: ARP_DISTRIBUTIONS_PKG.insert_p(ard_tbl_tbl(l_ctr),l_ard_line_id);

568:
569: -- strore back all records from above plsql table
570: IF update_flag='Y' THEN
571: FOR l_ctr IN ard_tbl_tbl.FIRST .. ard_tbl_tbl.LAST LOOP
572: ARP_DISTRIBUTIONS_PKG.insert_p(ard_tbl_tbl(l_ctr),l_ard_line_id);
573:
574: IF PG_DEBUG in ('Y', 'C') THEN
575: arp_standard.debug( 'line id for line:= '||to_char(l_ard_line_id));
576: END IF;

Line 590: ARP_DISTRIBUTIONS_PKG.insert_p(l_ard_rec,l_ard_line_id);

586: l_ard_rec.tax_link_id := 1;
587: end if;
588:
589: -- to insert new line record
590: ARP_DISTRIBUTIONS_PKG.insert_p(l_ard_rec,l_ard_line_id);
591:
592: IF PG_DEBUG in ('Y', 'C') THEN
593: arp_standard.debug( 'line id for line:= '||to_char(l_ard_line_id));
594: END IF;

Line 601: ARP_DISTRIBUTIONS_PKG.insert_p(l_ard_tax_rec,l_ard_line_id);

597: IF l_ard_tax_rec_flag = 'Y' THEN
598: if l_ard_tax_rec.source_id = 0 then
599: l_ard_tax_rec.source_id :=l_mcd_id;
600: end if;
601: ARP_DISTRIBUTIONS_PKG.insert_p(l_ard_tax_rec,l_ard_line_id);
602:
603: END IF;
604:
605: --end for 1543658

Line 1041: -- "procedure ARP_DISTRIBUTIONS_PKG.insert_p(l_ard_tax_rec,l_ard_line_id);"

1037: BEGIN
1038: -- to select the tax record of AR distribution in local variable
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

Line 1128: ARP_DISTRIBUTIONS_PKG.insert_p(ard_tbl_tbl(l_ctr),l_ard_line_id);

1124: -- end bug5655154
1125: -- strore back all records from above plsql table
1126: IF update_flag='Y' THEN
1127: FOR l_ctr IN ard_tbl_tbl.FIRST .. ard_tbl_tbl.LAST LOOP
1128: ARP_DISTRIBUTIONS_PKG.insert_p(ard_tbl_tbl(l_ctr),l_ard_line_id);
1129:
1130: END LOOP;
1131: END IF;
1132: -- cleaning up of plsql table

Line 1143: ARP_DISTRIBUTIONS_PKG.insert_p(l_ard_rec,l_ard_line_id);

1139: l_ard_rec.tax_link_id := 1;
1140: end if;
1141:
1142: -- to insert new line record
1143: ARP_DISTRIBUTIONS_PKG.insert_p(l_ard_rec,l_ard_line_id);
1144:
1145: IF PG_DEBUG in ('Y', 'C') THEN
1146: arp_standard.debug('line id for line:= '||to_char(l_ard_line_id));
1147: END IF;

Line 1154: ARP_DISTRIBUTIONS_PKG.insert_p(l_ard_tax_rec,l_ard_line_id);

1150: if l_ard_tax_rec_flag = 'Y' then
1151: if l_ard_tax_rec.source_id = 0 then
1152: l_ard_tax_rec.source_id :=p_misc_cash_distribution_id;
1153: end if;
1154: ARP_DISTRIBUTIONS_PKG.insert_p(l_ard_tax_rec,l_ard_line_id);
1155:
1156: end if;
1157:
1158: --end for 1543658