APPS.PA_DRAFT_INVOICES_PKG dependencies on PA_DRAFT_INVOICES

Line 1: PACKAGE BODY PA_DRAFT_INVOICES_PKG as

1: PACKAGE BODY PA_DRAFT_INVOICES_PKG as
2: /* $Header: PAINDINB.pls 120.2.12010000.2 2008/11/27 09:37:16 rdegala ship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
5:

Line 52: CURSOR C IS SELECT rowid FROM PA_DRAFT_INVOICES

48: X_Attribute10 VARCHAR2,
49: X_Retention_Percentage NUMBER,
50: X_Invoice_Set_Id NUMBER
51: ) IS
52: CURSOR C IS SELECT rowid FROM PA_DRAFT_INVOICES
53: WHERE project_id = X_Project_Id
54: AND draft_invoice_num = X_Draft_Invoice_Num;
55:
56: l_rowid varchar2(30);

Line 66: INSERT INTO PA_DRAFT_INVOICES(

62: /* ATG Changes */
63: l_rowid := x_rowid;
64:
65:
66: INSERT INTO PA_DRAFT_INVOICES(
67:
68: project_id,
69: draft_invoice_num,
70: last_update_date,

Line 227: FROM PA_DRAFT_INVOICES

223: X_Credit_Memo_Reason_Code VARCHAR2
224: ) IS
225: CURSOR C IS
226: SELECT *
227: FROM PA_DRAFT_INVOICES
228: WHERE rowid = X_Rowid
229: FOR UPDATE of Project_Id NOWAIT;
230: Recinfo C%ROWTYPE;
231:

Line 494: UPDATE PA_DRAFT_INVOICES

490: X_Credit_Memo_Reason_Code VARCHAR2
491:
492: ) IS
493: BEGIN
494: UPDATE PA_DRAFT_INVOICES
495: SET
496: project_id = X_Project_Id,
497: draft_invoice_num = X_Draft_Invoice_Num,
498: last_update_date = X_Last_Update_Date,

Line 611: DELETE FROM PA_DRAFT_INVOICES

607: END Update_row;
608:
609: PROCEDURE Delete_Row(X_Rowid VARCHAR2) IS
610: BEGIN
611: DELETE FROM PA_DRAFT_INVOICES
612: WHERE rowid = X_Rowid;
613:
614: if (SQL%NOTFOUND) then
615: Raise NO_DATA_FOUND;

Line 620: END PA_DRAFT_INVOICES_PKG;

616: end if;
617: END Delete_Row;
618:
619:
620: END PA_DRAFT_INVOICES_PKG;