APPS.AP_AIL_TABLE_HANDLER_PKG dependencies on AP_INVOICE_LINES_ALL

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

18:
19: current_calling_sequence := 'AP_AIL_TABLE_HANDLER_PKG.CHECK_UNIQUE<-'
20: ||p_Calling_Sequence;
21:
22: debug_info := 'Select from ap_invoice_lines_all';
23:
24: SELECT COUNT(1)
25: INTO dummy
26: FROM ap_invoice_Lines_all

Line 26: FROM ap_invoice_Lines_all

22: debug_info := 'Select from ap_invoice_lines_all';
23:
24: SELECT COUNT(1)
25: INTO dummy
26: FROM ap_invoice_Lines_all
27: where (invoice_id = p_INVOICE_ID AND
28: line_number = p_LINE_NUMBER)
29: AND ((p_ROWID is null) OR
30: (rowid <> p_ROWID));

Line 228: FROM AP_INVOICE_LINES_ALL

224: debug_info VARCHAR2(100);
225: l_dist_match_type VARCHAR2(25);
226: CURSOR C IS
227: SELECT rowid
228: FROM AP_INVOICE_LINES_ALL
229: WHERE invoice_id = p_Invoice_Id
230: AND line_number = p_Line_Number;
231:
232: BEGIN

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

257: ELSE
258: l_dist_match_type := NULL;
259: END IF;
260:
261: debug_info := 'Insert into ap_invoice_lines_all';
262:
263: INSERT INTO AP_INVOICE_LINES_ALL(
264: INVOICE_ID ,
265: LINE_NUMBER ,

Line 263: INSERT INTO AP_INVOICE_LINES_ALL(

259: END IF;
260:
261: debug_info := 'Insert into ap_invoice_lines_all';
262:
263: INSERT INTO AP_INVOICE_LINES_ALL(
264: INVOICE_ID ,
265: LINE_NUMBER ,
266: LINE_TYPE_LOOKUP_CODE ,
267: LINE_GROUP_NUMBER ,

Line 962: FROM AP_INVOICE_LINES_ALL

958: RETAINED_AMOUNT ,
959: RETAINED_INVOICE_ID ,
960: RETAINED_LINE_NUMBER ,
961: TAX_CLASSIFICATION_CODE
962: FROM AP_INVOICE_LINES_ALL
963: WHERE rowid = P_Rowid
964: FOR UPDATE of Invoice_Id NOWAIT;
965: Recinfo C%ROWTYPE;
966:

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

970: --
971: current_calling_sequence := 'AP_INVOICE_LINES_PKG.Lock_Row<-'
972: ||P_Calling_Sequence;
973:
974: debug_info := 'Select from ap_invoice_lines_all';
975: OPEN C;
976:
977: debug_info := 'Fetch cursor C';
978: FETCH C INTO Recinfo;

Line 1686: debug_info := 'Update ap_invoice_lines_all';

1682: p_Invoice_Id,
1683: p_Line_Number,
1684: 'AP_AIL_TABLE_HANDLER_PKG.Update_Row');
1685:
1686: debug_info := 'Update ap_invoice_lines_all';
1687:
1688: UPDATE AP_INVOICE_LINES_ALL
1689: SET
1690: INVOICE_ID = P_INVOICE_ID,

Line 1688: UPDATE AP_INVOICE_LINES_ALL

1684: 'AP_AIL_TABLE_HANDLER_PKG.Update_Row');
1685:
1686: debug_info := 'Update ap_invoice_lines_all';
1687:
1688: UPDATE AP_INVOICE_LINES_ALL
1689: SET
1690: INVOICE_ID = P_INVOICE_ID,
1691: LINE_NUMBER = P_LINE_NUMBER,
1692: LINE_TYPE_LOOKUP_CODE = P_LINE_TYPE_LOOKUP_CODE,

Line 1885: l_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;

1881: current_calling_sequence VARCHAR2(2000);
1882: debug_info VARCHAR2(100);
1883: --Bugfix:4670908
1884: l_invoice_id AP_INVOICES_ALL.INVOICE_ID%TYPE;
1885: l_line_number AP_INVOICE_LINES_ALL.LINE_NUMBER%TYPE;
1886: l_invoice_distribution_id NUMBER;
1887: BEGIN
1888: -- Update the calling sequence
1889:

Line 1897: FROM ap_invoice_lines_all

1893: debug_info := 'Delete from child entity ap_invoice_distributions_all';
1894: --Bugfix:4670908
1895: SELECT invoice_id,line_number
1896: INTO l_invoice_id,l_line_number
1897: FROM ap_invoice_lines_all
1898: WHERE rowid=p_rowid;
1899:
1900: DELETE FROM ap_invoice_distributions_all
1901: WHERE invoice_id = l_invoice_id

Line 1905: DELETE FROM AP_INVOICE_LINES_ALL

1901: WHERE invoice_id = l_invoice_id
1902: AND invoice_line_number = l_line_number;
1903:
1904: debug_info := 'Delete from ap_invoice_lines';
1905: DELETE FROM AP_INVOICE_LINES_ALL
1906: WHERE rowid = p_Rowid;
1907:
1908: IF (SQL%NOTFOUND) THEN
1909: Raise NO_DATA_FOUND;