APPS.PA_DRAFT_INVOICE_ITEMS_PKG dependencies on PA_DRAFT_INVOICE_ITEMS

Line 1: PACKAGE BODY PA_DRAFT_INVOICE_ITEMS_PKG as

1: PACKAGE BODY PA_DRAFT_INVOICE_ITEMS_PKG as
2: /* $Header: PAINDIIB.pls 120.4 2005/08/19 16:34:57 mwasowic noship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
5: X_Project_Id NUMBER,

Line 25: CURSOR C IS SELECT rowid FROM PA_DRAFT_INVOICE_ITEMS

21: X_Taxable_Flag VARCHAR2,
22: X_Draft_Inv_Line_Num_Credited NUMBER,
23: X_Last_Update_Login NUMBER
24: ) IS
25: CURSOR C IS SELECT rowid FROM PA_DRAFT_INVOICE_ITEMS
26: WHERE project_id = X_Project_Id
27: AND draft_invoice_num = X_Draft_Invoice_Num
28: AND line_num = X_Line_Num;
29:

Line 42: INSERT INTO PA_DRAFT_INVOICE_ITEMS(

38: l_rowid := x_rowid;
39:
40:
41:
42: INSERT INTO PA_DRAFT_INVOICE_ITEMS(
43:
44: project_id,
45: draft_invoice_num,
46: line_num,

Line 124: FROM PA_DRAFT_INVOICE_ITEMS

120: X_translated_text VARCHAR2
121: ) IS
122: CURSOR C IS
123: SELECT *
124: FROM PA_DRAFT_INVOICE_ITEMS
125: WHERE rowid = X_Rowid
126: FOR UPDATE of Project_Id NOWAIT;
127: Recinfo C%ROWTYPE;
128:

Line 234: UPDATE PA_DRAFT_INVOICE_ITEMS

230: X_translated_text VARCHAR2
231:
232: ) IS
233: BEGIN
234: UPDATE PA_DRAFT_INVOICE_ITEMS
235: SET
236: project_id = X_Project_Id,
237: draft_invoice_num = X_Draft_Invoice_Num,
238: line_num = X_Line_Num,

Line 267: DELETE FROM PA_DRAFT_INVOICE_ITEMS

263: end if;
264: END Update_Row;
265: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
266: BEGIN
267: DELETE FROM PA_DRAFT_INVOICE_ITEMS
268: WHERE rowid = X_Rowid;
269:
270: if (SQL%NOTFOUND) then
271: Raise NO_DATA_FOUND;

Line 276: END PA_DRAFT_INVOICE_ITEMS_PKG;

272: end if;
273: END Delete_Row;
274:
275:
276: END PA_DRAFT_INVOICE_ITEMS_PKG;