APPS.AP_AIL_TABLE_HANDLER_PKG dependencies on AP_INVOICE_LINES_ALL

Line 39: debug_info := 'Select from ap_invoice_lines_all';

35:
36: current_calling_sequence := 'AP_AIL_TABLE_HANDLER_PKG.CHECK_UNIQUE<-'
37: ||p_Calling_Sequence;
38:
39: debug_info := 'Select from ap_invoice_lines_all';
40:
41: SELECT COUNT(1)
42: INTO dummy
43: FROM ap_invoice_Lines_all

Line 43: FROM ap_invoice_Lines_all

39: debug_info := 'Select from ap_invoice_lines_all';
40:
41: SELECT COUNT(1)
42: INTO dummy
43: FROM ap_invoice_Lines_all
44: where (invoice_id = p_INVOICE_ID AND
45: line_number = p_LINE_NUMBER)
46: AND ((p_ROWID is null) OR
47: (rowid <> p_ROWID));

Line 245: FROM AP_INVOICE_LINES_ALL

241: debug_info VARCHAR2(100);
242: l_dist_match_type VARCHAR2(25);
243: CURSOR C IS
244: SELECT rowid
245: FROM AP_INVOICE_LINES_ALL
246: WHERE invoice_id = p_Invoice_Id
247: AND line_number = p_Line_Number;
248:
249: BEGIN

Line 278: debug_info := 'Insert into ap_invoice_lines_all';

274: ELSE
275: l_dist_match_type := NULL;
276: END IF;
277:
278: debug_info := 'Insert into ap_invoice_lines_all';
279:
280: INSERT INTO AP_INVOICE_LINES_ALL(
281: INVOICE_ID ,
282: LINE_NUMBER ,

Line 280: INSERT INTO AP_INVOICE_LINES_ALL(

276: END IF;
277:
278: debug_info := 'Insert into ap_invoice_lines_all';
279:
280: INSERT INTO AP_INVOICE_LINES_ALL(
281: INVOICE_ID ,
282: LINE_NUMBER ,
283: LINE_TYPE_LOOKUP_CODE ,
284: LINE_GROUP_NUMBER ,

Line 979: FROM AP_INVOICE_LINES_ALL

975: RETAINED_AMOUNT ,
976: RETAINED_INVOICE_ID ,
977: RETAINED_LINE_NUMBER ,
978: TAX_CLASSIFICATION_CODE
979: FROM AP_INVOICE_LINES_ALL
980: WHERE rowid = P_Rowid
981: FOR UPDATE of Invoice_Id NOWAIT;
982: Recinfo C%ROWTYPE;
983:

Line 991: debug_info := 'Select from ap_invoice_lines_all';

987: --
988: current_calling_sequence := 'AP_INVOICE_LINES_PKG.Lock_Row<-'
989: ||P_Calling_Sequence;
990:
991: debug_info := 'Select from ap_invoice_lines_all';
992: OPEN C;
993:
994: debug_info := 'Fetch cursor C';
995: FETCH C INTO Recinfo;

Line 1703: debug_info := 'Update ap_invoice_lines_all';

1699: p_Invoice_Id,
1700: p_Line_Number,
1701: 'AP_AIL_TABLE_HANDLER_PKG.Update_Row');
1702:
1703: debug_info := 'Update ap_invoice_lines_all';
1704:
1705: UPDATE AP_INVOICE_LINES_ALL
1706: SET
1707: INVOICE_ID = P_INVOICE_ID,

Line 1705: UPDATE AP_INVOICE_LINES_ALL

1701: 'AP_AIL_TABLE_HANDLER_PKG.Update_Row');
1702:
1703: debug_info := 'Update ap_invoice_lines_all';
1704:
1705: UPDATE AP_INVOICE_LINES_ALL
1706: SET
1707: INVOICE_ID = P_INVOICE_ID,
1708: LINE_NUMBER = P_LINE_NUMBER,
1709: LINE_TYPE_LOOKUP_CODE = P_LINE_TYPE_LOOKUP_CODE,

Line 1902: l_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;

1898: current_calling_sequence VARCHAR2(2000);
1899: debug_info VARCHAR2(100);
1900: --Bugfix:4670908
1901: l_invoice_id AP_INVOICES_ALL.INVOICE_ID%TYPE;
1902: l_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
1903: l_invoice_distribution_id NUMBER;
1904: --Bug9295867
1905: l_line_type AP_INVOICE_LINES_ALL.LINE_TYPE_LOOKUP_CODE%TYPE;
1906: l_tax_calculated_flag VARCHAR2(3);

Line 1905: l_line_type AP_INVOICE_LINES_ALL.LINE_TYPE_LOOKUP_CODE%TYPE;

1901: l_invoice_id AP_INVOICES_ALL.INVOICE_ID%TYPE;
1902: l_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
1903: l_invoice_distribution_id NUMBER;
1904: --Bug9295867
1905: l_line_type AP_INVOICE_LINES_ALL.LINE_TYPE_LOOKUP_CODE%TYPE;
1906: l_tax_calculated_flag VARCHAR2(3);
1907: l_success BOOLEAN;
1908: l_error_code VARCHAR2(4000);
1909: l_api_name CONSTANT VARCHAR2(200) := 'Delete_Row';

Line 1924: FROM ap_invoice_lines_all

1920: --Bugfix:4670908
1921: --Bug9295867 : added l_line_type, l_tax_calculated_flag
1922: SELECT invoice_id,line_number,line_type_lookup_code,tax_already_calculated_flag
1923: INTO l_invoice_id,l_line_number, l_line_type, l_tax_calculated_flag
1924: FROM ap_invoice_lines_all
1925: WHERE rowid=p_rowid;
1926:
1927: DELETE FROM ap_invoice_distributions_all
1928: WHERE invoice_id = l_invoice_id

Line 1955: DELETE FROM AP_INVOICE_LINES_ALL

1951: END IF;
1952: --End of Bug9295867
1953:
1954: debug_info := 'Delete from ap_invoice_lines';
1955: DELETE FROM AP_INVOICE_LINES_ALL
1956: WHERE rowid = p_Rowid;
1957:
1958: IF (SQL%NOTFOUND) THEN
1959: Raise NO_DATA_FOUND;