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_INVOICE_LINES_UTILITY_PKG dependencies on AP_INVOICE_LINES_UTILITY_PKG

Line 1: PACKAGE BODY AP_INVOICE_LINES_UTILITY_PKG AS

1: PACKAGE BODY AP_INVOICE_LINES_UTILITY_PKG AS
2: /* $Header: apilnutb.pls 120.31.12010000.3 2009/02/11 12:02:20 asansari ship $ */
3:
4: /*=============================================================================
5: | FUNCTION - get_encumbered_flag()

Line 1021: 'AP_INVOICE_LINES_UTILITY_PKG.ALLOCATION_EXISTS<-'||p_Calling_Sequence;

1017: Begin
1018: -- Update the calling sequence
1019: --
1020: current_calling_sequence :=
1021: 'AP_INVOICE_LINES_UTILITY_PKG.ALLOCATION_EXISTS<-'||p_Calling_Sequence;
1022:
1023: debug_info := 'Select from ap_allocation_rules';
1024:
1025: Select count(*)

Line 1078: 'AP_INVOICE_LINES_UTILITY_PKG.Inv_Reverse_Via_Qc<-'||p_Calling_Sequence;

1074: Begin
1075: -- Update the calling sequence
1076: --
1077: current_calling_sequence :=
1078: 'AP_INVOICE_LINES_UTILITY_PKG.Inv_Reverse_Via_Qc<-'||p_Calling_Sequence;
1079:
1080: debug_info := 'Select from ap_invoics_all';
1081:
1082: -- Bug 5261908. Added rownum condition to improve performance

Line 1143: 'AP_INVOICE_LINES_UTILITY_PKG.IS_LINE_DISTS_TRANS_FA<-'

1139: Begin
1140: -- Update the calling sequence
1141: --
1142: current_calling_sequence :=
1143: 'AP_INVOICE_LINES_UTILITY_PKG.IS_LINE_DISTS_TRANS_FA<-'
1144: ||p_Calling_Sequence;
1145:
1146: debug_info := 'Select from ap_invoice_distributions_all';
1147:

Line 1200: 'AP_INVOICE_LINES_UTILITY_PKG.LINE_DISTS_ACCT_EVENT_CREATED<-'

1196: Begin
1197: -- Update the calling sequence
1198: --
1199: current_calling_sequence :=
1200: 'AP_INVOICE_LINES_UTILITY_PKG.LINE_DISTS_ACCT_EVENT_CREATED<-'
1201: ||p_Calling_Sequence;
1202:
1203: debug_info := 'Select from ap_invoice_distributions_all';
1204:

Line 1257: 'AP_INVOICE_LINES_UTILITY_PKG.LINE_REFERRED_BY_CORR<-'

1253: Begin
1254: -- Update the calling sequence
1255: --
1256: current_calling_sequence :=
1257: 'AP_INVOICE_LINES_UTILITY_PKG.LINE_REFERRED_BY_CORR<-'
1258: ||p_Calling_Sequence;
1259:
1260: debug_info := 'Select from ap_invoice_lines_all';
1261:

Line 1316: 'AP_INVOICE_LINES_UTILITY_PKG.Line_Dists_Referred_By_Other <-'||

1312: Begin
1313: -- Update the calling sequence
1314: --
1315: current_calling_sequence :=
1316: 'AP_INVOICE_LINES_UTILITY_PKG.Line_Dists_Referred_By_Other <-'||
1317: p_Calling_Sequence;
1318: debug_info := 'Select from ap_invoic_distributions_all';
1319:
1320: Select count(*)

Line 1382: 'AP_INVOICE_LINES_UTILITY_PKG.Outstanding_Alloc_Exists <-'||

1378: Begin
1379: -- Update the calling sequence
1380: --
1381: current_calling_sequence :=
1382: 'AP_INVOICE_LINES_UTILITY_PKG.Outstanding_Alloc_Exists <-'||
1383: p_Calling_Sequence;
1384: debug_info := 'Select from ap_allocatin_rules';
1385:
1386: Select count(*)

Line 1441: 'AP_INVOICE_LINES_UTILITY_PKG.Line_Dists_Trans_PA <-'||

1437: Begin
1438: -- Update the calling sequence
1439: --
1440: current_calling_sequence :=
1441: 'AP_INVOICE_LINES_UTILITY_PKG.Line_Dists_Trans_PA <-'||
1442: p_Calling_Sequence;
1443: debug_info := 'Select from ap_invoic_distributions_all';
1444:
1445: Select count(*)

Line 1495: 'AP_INVOICE_LINES_UTILITY_PKG.Can_Line_Be_Deleted <-'||

1491: Begin
1492: -- Update the calling sequence
1493: --
1494: current_calling_sequence :=
1495: 'AP_INVOICE_LINES_UTILITY_PKG.Can_Line_Be_Deleted <-'||
1496: p_Calling_Sequence;
1497:
1498: If (Ap_Invoice_Lines_Utility_Pkg.Line_Dists_Acct_Event_Created
1499: (p_Line_Rec.Invoice_Id,

Line 1498: If (Ap_Invoice_Lines_Utility_Pkg.Line_Dists_Acct_Event_Created

1494: current_calling_sequence :=
1495: 'AP_INVOICE_LINES_UTILITY_PKG.Can_Line_Be_Deleted <-'||
1496: p_Calling_Sequence;
1497:
1498: If (Ap_Invoice_Lines_Utility_Pkg.Line_Dists_Acct_Event_Created
1499: (p_Line_Rec.Invoice_Id,
1500: p_Line_Rec.Line_Number,
1501: Current_calling_sequence) = TRUE) Then
1502: p_error_code := 'AP_INV_LINE_DELETE_VALIDATED';

Line 1504: ElsIf (Ap_Invoice_Lines_Utility_Pkg.Line_Referred_By_Corr

1500: p_Line_Rec.Line_Number,
1501: Current_calling_sequence) = TRUE) Then
1502: p_error_code := 'AP_INV_LINE_DELETE_VALIDATED';
1503: return False;
1504: ElsIf (Ap_Invoice_Lines_Utility_Pkg.Line_Referred_By_Corr
1505: (p_Line_Rec.Invoice_Id,
1506: p_Line_Rec.Line_Number,
1507: Current_calling_sequence) = TRUE) Then
1508: p_error_code := 'AP_INV_LINE_DELETE_CORR';

Line 1510: ElsIf (NVL(Ap_Invoice_Lines_Utility_Pkg.Get_Encumbered_Flag

1506: p_Line_Rec.Line_Number,
1507: Current_calling_sequence) = TRUE) Then
1508: p_error_code := 'AP_INV_LINE_DELETE_CORR';
1509: return False;
1510: ElsIf (NVL(Ap_Invoice_Lines_Utility_Pkg.Get_Encumbered_Flag
1511: (p_Line_Rec.Invoice_Id,
1512: p_Line_Rec.Line_Number), 'N')
1513: In ('Y', 'P')) Then
1514: p_error_code := 'AP_INV_LINE_DELETE_ENCUMBERED';

Line 1516: ElsIf (Ap_Invoice_Lines_Utility_Pkg.Get_Posting_Status

1512: p_Line_Rec.Line_Number), 'N')
1513: In ('Y', 'P')) Then
1514: p_error_code := 'AP_INV_LINE_DELETE_ENCUMBERED';
1515: return False;
1516: ElsIf (Ap_Invoice_Lines_Utility_Pkg.Get_Posting_Status
1517: (p_Line_Rec.Invoice_Id,
1518: p_Line_Rec.Line_Number)
1519: In ('Y', 'P', 'S')) Then
1520: p_error_code := 'AP_INV_LINE_DELETE_ACCOUNTED';

Line 1522: ElsIf (Ap_Invoice_Lines_Utility_Pkg.Line_Dists_Trans_PA

1518: p_Line_Rec.Line_Number)
1519: In ('Y', 'P', 'S')) Then
1520: p_error_code := 'AP_INV_LINE_DELETE_ACCOUNTED';
1521: return False;
1522: ElsIf (Ap_Invoice_Lines_Utility_Pkg.Line_Dists_Trans_PA
1523: (p_Line_Rec.Invoice_Id,
1524: p_Line_Rec.Line_Number,
1525: Current_calling_sequence) = TRUE) Then
1526: p_error_code := 'AP_INV_LINE_DELETE_PA';

Line 1528: ElsIf (Ap_Invoice_Lines_Utility_Pkg.Line_Dists_Referred_By_Other

1524: p_Line_Rec.Line_Number,
1525: Current_calling_sequence) = TRUE) Then
1526: p_error_code := 'AP_INV_LINE_DELETE_PA';
1527: return False;
1528: ElsIf (Ap_Invoice_Lines_Utility_Pkg.Line_Dists_Referred_By_Other
1529: (p_Line_Rec.Invoice_Id,
1530: p_Line_Rec.Line_Number,
1531: Current_calling_sequence) = TRUE) Then
1532: p_error_code := 'AP_INV_LINE_REF_BY_DISTS';

Line 1534: ElsIf (Ap_Invoice_Lines_Utility_Pkg.Outstanding_Alloc_Exists

1530: p_Line_Rec.Line_Number,
1531: Current_calling_sequence) = TRUE) Then
1532: p_error_code := 'AP_INV_LINE_REF_BY_DISTS';
1533: return False;
1534: ElsIf (Ap_Invoice_Lines_Utility_Pkg.Outstanding_Alloc_Exists
1535: (p_Line_Rec.Invoice_Id,
1536: p_Line_Rec.Line_Number,
1537: Current_calling_sequence) = TRUE) Then
1538: p_error_code := 'AP_INV_LINE_HAS_ALLOC_RULE';

Line 1644: current_calling_sequence := 'AP_INVOICE_LINES_UTILITY_PKG - Is_Line_Fully_Distributed';

1640: l_test_var VARCHAR2(50);
1641:
1642: BEGIN
1643: -------------------------------------------------------------
1644: current_calling_sequence := 'AP_INVOICE_LINES_UTILITY_PKG - Is_Line_Fully_Distributed';
1645: debug_info := 'Is_Line_Fully_Distributed - Open cursor';
1646: -------------------------------------------------------------
1647:
1648: OPEN Dist_Var_Cur;

Line 1729: current_calling_sequence := 'AP_INVOICE_LINES_UTILITY_PKG - Is_PO_RCV_Amount_Exceeded';

1725: l_return_var BOOLEAN := FALSE;
1726:
1727:
1728: BEGIN
1729: current_calling_sequence := 'AP_INVOICE_LINES_UTILITY_PKG - Is_PO_RCV_Amount_Exceeded';
1730: -------------------------------------------------------------
1731: debug_info := 'Is_PO_RCV_Amount_Exceeded - Open cursor';
1732: -------------------------------------------------------------
1733:

Line 1838: 'AP_INVOICE_LINES_UTILITY_PKG.Pending_Alloc_Exists_Chrg_Line <-'||

1834: Begin
1835: -- Update the calling sequence
1836: --
1837: current_calling_sequence :=
1838: 'AP_INVOICE_LINES_UTILITY_PKG.Pending_Alloc_Exists_Chrg_Line <-'||
1839: p_Calling_Sequence;
1840: debug_info := 'Select from ap_allocatin_rules';
1841:
1842: Select count(*)

Line 2131: l_curr_calling_sequence := 'AP_INVOICE_LINES_UTILITY_PKG.'||l_debug_loc;

2127:
2128:
2129: BEGIN
2130:
2131: l_curr_calling_sequence := 'AP_INVOICE_LINES_UTILITY_PKG.'||l_debug_loc;
2132:
2133: SELECT nvl(payment_cross_rate,0), payment_currency_code
2134: INTO l_payment_cross_rate, l_payment_currency_code
2135: FROM ap_invoices_all

Line 2224: END AP_INVOICE_LINES_UTILITY_PKG;

2220: WHEN Others THEN
2221: RETURN ('Z');
2222: END get_awt_flag;
2223:
2224: END AP_INVOICE_LINES_UTILITY_PKG;