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.AP_PPA_PKG dependencies on AP_PPA_PKG

Line 1: PACKAGE BODY AP_PPA_PKG AS

1: PACKAGE BODY AP_PPA_PKG AS
2: /* $Header: aprddtsb.pls 120.9.12010000.5 2009/01/09 12:27:32 amitmukh ship $ */
3:
4: --==========================================================================
5: ---------------------------------------------------------------------------

Line 304: l_curr_calling_sequence := 'AP_PPA_PKG.'||l_debug_loc||'<-'||p_calling_sequence;

300: --AP_LOGGING_PKG.AP_Begin_Block(l_debug_loc);
301:
302: -- Update the calling sequence --
303:
304: l_curr_calling_sequence := 'AP_PPA_PKG.'||l_debug_loc||'<-'||p_calling_sequence;
305:
306: l_first_record := TRUE;
307: l_sub_total := 0;
308: l_sub_total_inv :=0;

Line 543: l_curr_calling_sequence := 'AP_PPA_PKG.'||l_debug_loc||'<-'||p_calling_sequence;

539: --AP_LOGGING_PKG.AP_Begin_Block(l_debug_loc);
540:
541: -- Update the calling sequence --
542:
543: l_curr_calling_sequence := 'AP_PPA_PKG.'||l_debug_loc||'<-'||p_calling_sequence;
544:
545: p_start_date := null;
546:
547: -------------------------------------------------

Line 647: l_curr_calling_sequence := 'AP_PPA_PKG.'||l_debug_loc||'<-'||p_calling_sequence;

643: BEGIN
644:
645: -- Update the calling sequence --
646:
647: l_curr_calling_sequence := 'AP_PPA_PKG.'||l_debug_loc||'<-'||p_calling_sequence;
648:
649:
650: SELECT
651: greatest(p_inv_date,

Line 693: l_curr_calling_sequence := 'AP_PPA_PKG.'||l_debug_loc||'<-'||p_calling_sequence;

689: --AP_LOGGING_PKG.AP_Begin_Block(l_debug_loc);
690:
691: -- Update the calling sequence --
692:
693: l_curr_calling_sequence := 'AP_PPA_PKG.'||l_debug_loc||'<-'||p_calling_sequence;
694:
695:
696: -- Retrieve po terms rank, and terms id and terms name
697:

Line 788: l_curr_calling_sequence := 'AP_PPA_PKG.'||l_debug_loc||'<-'||p_calling_sequence;

784: --AP_LOGGING_PKG.AP_Begin_Block(l_debug_loc);
785:
786: -- Update the calling sequence --
787:
788: l_curr_calling_sequence := 'AP_PPA_PKG.'||l_debug_loc||'<-'||p_calling_sequence;
789:
790:
791: --------------------------------------------
792: l_debug_info := 'Get Payment Schedule Info';

Line 1006: l_curr_calling_sequence := 'AP_PPA_PKG.'||l_debug_loc||'<-'||p_calling_sequence;

1002: --AP_LOGGING_PKG.AP_Begin_Block(l_debug_loc);
1003:
1004: -- Update the calling sequence --
1005:
1006: l_curr_calling_sequence := 'AP_PPA_PKG.'||l_debug_loc||'<-'||p_calling_sequence;
1007:
1008: ---------------------------------------------------------------------------
1009: l_debug_info := 'Retrieve invoice_amount and amount_applicable_to_disc';
1010: ---------------------------------------------------------------------------

Line 1063: l_curr_calling_sequence := 'AP_PPA_PKG.'||l_debug_loc||'<-'||p_calling_sequence;

1059: --AP_LOGGING_PKG.AP_Begin_Block(l_debug_loc);
1060:
1061: -- Update the calling sequence --
1062:
1063: l_curr_calling_sequence := 'AP_PPA_PKG.'||l_debug_loc||'<-'||p_calling_sequence;
1064:
1065:
1066: ----------------------------------------------------------------
1067: l_debug_info := 'Retrieve last_inv_ps_pay_num and gross_amount';

Line 1149: l_curr_calling_sequence := 'AP_PPA_PKG.'||l_debug_loc||'<-'||p_calling_sequence;

1145: --AP_LOGGING_PKG.AP_Begin_Block(l_debug_loc);
1146:
1147: -- Update the calling sequence --
1148:
1149: l_curr_calling_sequence := 'AP_PPA_PKG.'||l_debug_loc||'<-'||p_calling_sequence;
1150:
1151: --
1152: -- Update the amount_remaining and not updat discount_amount_remaining
1153: -- per discussion with shira and nnakos, this program will populate

Line 1238: l_curr_calling_sequence := 'AP_PPA_PKG.'||l_debug_loc||'<-'||p_calling_sequence;

1234: --AP_LOGGING_PKG.AP_Begin_Block(l_debug_loc);
1235:
1236: -- Update the calling sequence --
1237:
1238: l_curr_calling_sequence := 'AP_PPA_PKG.'||l_debug_loc||'<-'||p_calling_sequence;
1239:
1240:
1241: DELETE FROM ap_payment_schedules
1242: WHERE invoice_id = p_invoice_id

Line 1315: l_curr_calling_sequence := 'AP_PPA_PKG.'||l_debug_loc||'<-'||p_calling_sequence;

1311: --AP_LOGGING_PKG.AP_Begin_Block(l_debug_loc);
1312:
1313: -- Update the calling sequence --
1314:
1315: l_curr_calling_sequence := 'AP_PPA_PKG.'||l_debug_loc||'<-'||p_calling_sequence;
1316:
1317: l_debug_info := 'Get minimum_accountable_unit';
1318: SELECT nvl(minimum_accountable_unit,0), precision
1319: INTO l_min_unit, l_precision

Line 1596: l_curr_calling_sequence := 'AP_PPA_PKG.'||l_debug_loc||'<-'||p_calling_sequence;

1592: --AP_LOGGING_PKG.AP_Begin_Block(l_debug_loc);
1593:
1594: -- Update the calling sequence --
1595:
1596: l_curr_calling_sequence := 'AP_PPA_PKG.'||l_debug_loc||'<-'||p_calling_sequence;
1597:
1598: -- get payment currency code for rounding
1599: SELECT payment_currency_code, org_id
1600: INTO l_pay_curr_code, l_org_id /* Bug 3700128. MOAC Project */

Line 1757: l_curr_calling_sequence := 'AP_PPA_PKG.'||l_debug_loc||'<-'||p_calling_sequence;

1753: --AP_LOGGING_PKG.AP_Begin_Block(l_debug_loc);
1754:
1755: -- Update the calling sequence --
1756:
1757: l_curr_calling_sequence := 'AP_PPA_PKG.'||l_debug_loc||'<-'||p_calling_sequence;
1758:
1759:
1760: l_curr_ps_pay_num := p_curr_ps_pay_num;
1761:

Line 1905: l_curr_calling_sequence := 'AP_PPA_PKG.'||l_debug_loc||'<-'||p_calling_sequence;

1901:
1902: BEGIN
1903:
1904: l_debug_loc := 'Update ap_payment_schedules - set gross_amount';
1905: l_curr_calling_sequence := 'AP_PPA_PKG.'||l_debug_loc||'<-'||p_calling_sequence;
1906:
1907: SELECT SUM(gross_amount)
1908: INTO l_pay_sched_total
1909: FROM ap_payment_schedules

Line 1957: END AP_PPA_PKG;

1953:
1954:
1955: END Adj_Pay_Sched_For_Round;
1956:
1957: END AP_PPA_PKG;