DBA Data[Home] [Help]

APPS.ARP_PROCESS_SALESCREDIT dependencies on ARP_CTLS_PKG

Line 63: arp_ctls_pkg.display_salescredit_rec(p_srep_rec);

59:
60: arp_util.debug('');
61: arp_util.debug('---------- val_insert_salescredit() ---------');
62: arp_util.debug('');
63: arp_ctls_pkg.display_salescredit_rec(p_srep_rec);
64:
65: RAISE;
66:
67: END;

Line 120: arp_ctls_pkg.display_salescredit_rec(p_srep_rec);

116:
117: arp_util.debug('');
118: arp_util.debug('---------- val_update_salescredit() ---------');
119: arp_util.debug('');
120: arp_ctls_pkg.display_salescredit_rec(p_srep_rec);
121:
122: RAISE;
123:
124: END;

Line 177: arp_ctls_pkg.display_salescredit_rec(p_srep_rec);

173:
174: arp_util.debug('');
175: arp_util.debug('---------- val_update_salescredit() ---------');
176: arp_util.debug('');
177: arp_ctls_pkg.display_salescredit_rec(p_srep_rec);
178:
179: RAISE;
180:
181: END;

Line 243: arp_ctls_pkg.fetch_p(l_old_srep_rec,

239: BEGIN
240:
241: arp_util.debug('arp_process_salescredit.set_flags()+');
242:
243: arp_ctls_pkg.fetch_p(l_old_srep_rec,
244: p_cust_trx_line_salesrep_id);
245:
246: IF (l_old_srep_rec.customer_trx_line_id IS NULL )
247: THEN l_default_record_flag := TRUE;

Line 386: arp_ctls_pkg.display_salescredit_rec( p_new_srep_rec );

382:
383: arp_util.debug('');
384:
385: arp_util.debug('---------- new salescredit record ----------');
386: arp_ctls_pkg.display_salescredit_rec( p_new_srep_rec );
387: arp_util.debug('');
388:
389: RAISE;
390:

Line 787: arp_ctls_pkg.merge_srep_recs(l_old_srep_rec,

783: | update_salescredit(). use that value. Otherwise, use the |
784: | value from the original salescredit line. |
785: +---------------------------------------------------------------*/
786:
787: arp_ctls_pkg.merge_srep_recs(l_old_srep_rec,
788: l_new_srep_rec,
789: l_new_srep_rec);
790:
791: /*-------------------------------------------------------------+

Line 795: arp_ctls_pkg.insert_p( l_new_srep_rec,

791: /*-------------------------------------------------------------+
792: | Call the table handler to insert the new salesrep record |
793: +-------------------------------------------------------------*/
794:
795: arp_ctls_pkg.insert_p( l_new_srep_rec,
796: l_cust_trx_line_salesrep_id);
797:
798: IF ( p_run_auto_accounting_flag = TRUE )
799: THEN

Line 822: arp_ctls_pkg.insert_p( l_old_srep_rec,

818:
819: l_old_srep_rec.non_revenue_percent_split :=
820: -1 * l_old_srep_rec.non_revenue_percent_split;
821:
822: arp_ctls_pkg.insert_p( l_old_srep_rec,
823: l_cust_trx_line_salesrep_id);
824:
825: IF ( p_run_auto_accounting_flag = TRUE )
826: THEN

Line 934: arp_ctls_pkg.merge_srep_recs(l_old_srep_rec,

930: | update_salescredit(). use that value. Otherwise, use the |
931: | value from the original salescredit line. |
932: +---------------------------------------------------------------*/
933:
934: arp_ctls_pkg.merge_srep_recs(l_old_srep_rec,
935: l_new_srep_rec,
936: l_old_srep_rec);
937:
938: arp_ctls_pkg.insert_p( l_old_srep_rec,

Line 938: arp_ctls_pkg.insert_p( l_old_srep_rec,

934: arp_ctls_pkg.merge_srep_recs(l_old_srep_rec,
935: l_new_srep_rec,
936: l_old_srep_rec);
937:
938: arp_ctls_pkg.insert_p( l_old_srep_rec,
939: l_cust_trx_line_salesrep_id);
940:
941: IF ( p_run_auto_accounting_flag = TRUE )
942: THEN

Line 1089: arp_ctls_pkg.insert_p( p_srep_rec,

1085:
1086: arp_trx_util.lock_transaction(p_srep_rec.customer_trx_id);
1087:
1088:
1089: arp_ctls_pkg.insert_p( p_srep_rec,
1090: l_cust_trx_line_salesrep_id);
1091:
1092: p_cust_trx_line_salesrep_id := l_cust_trx_line_salesrep_id;
1093:

Line 1157: arp_ctls_pkg.display_salescredit_rec( p_srep_rec );

1153: arp_util.debug('p_run_auto_accounting_flag = ' ||
1154: arp_trx_util.boolean_to_varchar2(p_run_auto_accounting_flag));
1155:
1156: arp_util.debug('');
1157: arp_ctls_pkg.display_salescredit_rec( p_srep_rec );
1158: arp_util.debug('');
1159:
1160: RAISE;
1161:

Line 1290: arp_ctls_pkg.update_p( p_srep_rec,

1286: | Do a simple update with no backout. |
1287: +--------------------------------------*/
1288:
1289: arp_util.debug('simple update - case 1');
1290: arp_ctls_pkg.update_p( p_srep_rec,
1291: p_cust_trx_line_salesrep_id);
1292:
1293: ELSE
1294: arp_ctls_pkg.fetch_p(l_old_srep_rec, p_cust_trx_line_salesrep_id);

Line 1294: arp_ctls_pkg.fetch_p(l_old_srep_rec, p_cust_trx_line_salesrep_id);

1290: arp_ctls_pkg.update_p( p_srep_rec,
1291: p_cust_trx_line_salesrep_id);
1292:
1293: ELSE
1294: arp_ctls_pkg.fetch_p(l_old_srep_rec, p_cust_trx_line_salesrep_id);
1295:
1296:
1297: IF ( l_salesrep_changed_flag = TRUE)
1298: THEN

Line 1334: arp_ctls_pkg.update_p(p_srep_rec,

1330: +--------------------------------------*/
1331:
1332: arp_util.debug('simple update - case 2');
1333:
1334: arp_ctls_pkg.update_p(p_srep_rec,
1335: p_cust_trx_line_salesrep_id);
1336: END IF;
1337:
1338: END IF;

Line 1375: arp_ctls_pkg.erase_foreign_key_references(

1371: AND l_backout_flag = FALSE
1372: )
1373: THEN
1374:
1375: arp_ctls_pkg.erase_foreign_key_references(
1376: p_cust_trx_line_salesrep_id,
1377: NULL,
1378: NULL);
1379: END IF;

Line 1443: arp_ctls_pkg.display_salescredit_rec( p_srep_rec );

1439: arp_util.debug('p_customer_trx_id = ' || p_customer_trx_id);
1440: arp_util.debug('p_customer_trx_line_id = ' || p_customer_trx_line_id);
1441:
1442: arp_util.debug('');
1443: arp_ctls_pkg.display_salescredit_rec( p_srep_rec );
1444: arp_util.debug('');
1445:
1446: RAISE;
1447:

Line 1562: arp_ctls_pkg.delete_p(p_cust_trx_line_salesrep_id,

1558: /*-----------------------------------------------------------+
1559: | call the table-handler to delete the salescredit record |
1560: +-----------------------------------------------------------*/
1561:
1562: arp_ctls_pkg.delete_p(p_cust_trx_line_salesrep_id,
1563: p_customer_trx_line_id);
1564:
1565: ELSE
1566: arp_ctls_pkg.fetch_p(l_old_srep_rec, p_cust_trx_line_salesrep_id);

Line 1566: arp_ctls_pkg.fetch_p(l_old_srep_rec, p_cust_trx_line_salesrep_id);

1562: arp_ctls_pkg.delete_p(p_cust_trx_line_salesrep_id,
1563: p_customer_trx_line_id);
1564:
1565: ELSE
1566: arp_ctls_pkg.fetch_p(l_old_srep_rec, p_cust_trx_line_salesrep_id);
1567:
1568: l_temp_srep_rec := l_old_srep_rec;
1569: l_temp_srep_rec.revenue_amount_split := 0;
1570: l_temp_srep_rec.revenue_percent_split := 0;

Line 1658: arp_ctls_pkg.display_salescredit_rec( p_srep_rec );

1654: arp_util.debug('p_backout_flag = ' ||
1655: arp_trx_util.boolean_to_varchar2(p_backout_flag));
1656:
1657: arp_util.debug('');
1658: arp_ctls_pkg.display_salescredit_rec( p_srep_rec );
1659: arp_util.debug('');
1660:
1661: RAISE;
1662:

Line 1755: arp_ctls_pkg.delete_f_ctl_id( p_customer_trx_line_id );

1751: IF ( p_delete_scredits_first_flag = 'Y' )
1752: THEN
1753: IF ( p_customer_trx_line_id IS NOT NULL )
1754: THEN
1755: arp_ctls_pkg.delete_f_ctl_id( p_customer_trx_line_id );
1756: ELSIF ( p_customer_trx_id IS NOT NULL )
1757: THEN arp_ctls_pkg.delete_f_ct_id( p_customer_trx_id, FALSE );
1758: END IF;
1759:

Line 1757: THEN arp_ctls_pkg.delete_f_ct_id( p_customer_trx_id, FALSE );

1753: IF ( p_customer_trx_line_id IS NOT NULL )
1754: THEN
1755: arp_ctls_pkg.delete_f_ctl_id( p_customer_trx_line_id );
1756: ELSIF ( p_customer_trx_id IS NOT NULL )
1757: THEN arp_ctls_pkg.delete_f_ct_id( p_customer_trx_id, FALSE );
1758: END IF;
1759:
1760: END IF;
1761:

Line 1772: |then call arp_ctls_pkg.insert_f_cmn_ct_ctl_id |

1768: +-------------------------------------------------------*/
1769:
1770: /*-------------------------------------------------+
1771: |Bug 1157776 If this is a Credit Memo, |
1772: |then call arp_ctls_pkg.insert_f_cmn_ct_ctl_id |
1773: +-------------------------------------------------*/
1774: /*------------------------------------------------------------------+
1775: | Bug 1485133. |
1776: | We need to check if the RA_CUSTOMER_TRX.PRIMARY_SALESREP_ID |

Line 1777: | is not null before calling arp_ctls_pkg.insert_f_cmn_ct_ctl_id |

1773: +-------------------------------------------------*/
1774: /*------------------------------------------------------------------+
1775: | Bug 1485133. |
1776: | We need to check if the RA_CUSTOMER_TRX.PRIMARY_SALESREP_ID |
1777: | is not null before calling arp_ctls_pkg.insert_f_cmn_ct_ctl_id |
1778: +------------------------------------------------------------------*/
1779:
1780: IF (prev_customer_trx_id is not null) then
1781:

Line 1783: arp_ctls_pkg.insert_f_cmn_ct_ctl_id( p_customer_trx_id,

1779:
1780: IF (prev_customer_trx_id is not null) then
1781:
1782: IF (p_salesrep_id is not null) then
1783: arp_ctls_pkg.insert_f_cmn_ct_ctl_id( p_customer_trx_id,
1784: p_customer_trx_line_id );
1785: END IF;
1786: ELSE
1787: arp_ctls_pkg.insert_f_ct_ctl_id( p_customer_trx_id,

Line 1787: arp_ctls_pkg.insert_f_ct_ctl_id( p_customer_trx_id,

1783: arp_ctls_pkg.insert_f_cmn_ct_ctl_id( p_customer_trx_id,
1784: p_customer_trx_line_id );
1785: END IF;
1786: ELSE
1787: arp_ctls_pkg.insert_f_ct_ctl_id( p_customer_trx_id,
1788: p_customer_trx_line_id );
1789: END IF;
1790:
1791: /*----------------------------------+

Line 2221: arp_ctls_pkg.set_to_dummy(l_srep_rec);

2217: | Populate the salescredit record group with |
2218: | the values passed in as parameters. |
2219: +------------------------------------------------*/
2220:
2221: arp_ctls_pkg.set_to_dummy(l_srep_rec);
2222:
2223: l_srep_rec.customer_trx_id := p_customer_trx_id;
2224: l_srep_rec.customer_trx_line_id := p_customer_trx_line_id;
2225: l_srep_rec.salesrep_id := p_salesrep_id;

Line 2465: arp_ctls_pkg.set_to_dummy(l_srep_rec);

2461: | Populate the salescredit record group with |
2462: | the values passed in as parameters. |
2463: +------------------------------------------------*/
2464:
2465: arp_ctls_pkg.set_to_dummy(l_srep_rec);
2466:
2467: l_srep_rec.customer_trx_id := p_customer_trx_id;
2468: l_srep_rec.customer_trx_line_id := p_customer_trx_line_id;
2469: l_srep_rec.salesrep_id := p_salesrep_id;

Line 2576: pg_number_dummy := arp_ctls_pkg.get_number_dummy;

2572: +---------------------------------------------*/
2573:
2574: BEGIN
2575:
2576: pg_number_dummy := arp_ctls_pkg.get_number_dummy;
2577:
2578: /* Bug 3607146 */
2579: pg_base_precision := arp_global.base_precision;
2580: pg_base_min_acc_unit := arp_global.base_min_acc_unit;