[Home] [Help]
PACKAGE: APPS.PA_DRAFT_INVOICE_ITEMS_PKG
Source
1 PACKAGE PA_DRAFT_INVOICE_ITEMS_PKG as
2 /* $Header: PAINDIIS.pls 120.3 2005/08/19 16:35:00 mwasowic noship $ */
3
4
5 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
6 X_Project_Id NUMBER,
7 X_Draft_Invoice_Num NUMBER,
8 X_Line_Num NUMBER,
9 X_Last_Update_Date DATE,
10 X_Last_Updated_By NUMBER,
11 X_Creation_Date DATE,
12 X_Created_By NUMBER,
13 X_Amount NUMBER,
14 X_Text VARCHAR2,
15 X_Invoice_Line_Type VARCHAR2,
16 X_Unearned_Revenue_Cr NUMBER,
17 X_Unbilled_Receivable_Dr NUMBER,
18 X_Task_Id NUMBER,
19 X_Event_Task_Id NUMBER,
20 X_Event_Num NUMBER,
21 X_Ship_To_Address_Id NUMBER,
22 X_Taxable_Flag VARCHAR2,
23 X_Draft_Inv_Line_Num_Credited NUMBER,
24 X_Last_Update_Login NUMBER
25 );
26
27 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
28 X_Project_Id NUMBER,
29 X_Draft_Invoice_Num NUMBER,
30 X_Line_Num NUMBER,
31 X_Amount NUMBER,
32 X_Text VARCHAR2,
33 X_Invoice_Line_Type VARCHAR2,
34 X_Unearned_Revenue_Cr NUMBER,
35 X_Unbilled_Receivable_Dr NUMBER,
36 X_Task_Id NUMBER,
37 X_Event_Task_Id NUMBER,
38 X_Event_Num NUMBER,
39 X_Ship_To_Address_Id NUMBER,
40 X_Taxable_Flag VARCHAR2,
41 X_Draft_Inv_Line_Num_Credited NUMBER,
42 X_output_tax_code VARCHAR2,
43 X_output_tax_exempt_flag VARCHAR2,
44 X_out_tax_exempt_reason_code VARCHAR2,
45 X_output_tax_exempt_number VARCHAR2,
46 X_translated_text VARCHAR2
47 );
48
49
50
51 PROCEDURE Update_Row(X_Rowid VARCHAR2,
52 X_Project_Id NUMBER,
53 X_Draft_Invoice_Num NUMBER,
54 X_Line_Num NUMBER,
55 X_Last_Update_Date DATE,
56 X_Last_Updated_By NUMBER,
57 X_Amount NUMBER,
58 X_Text VARCHAR2,
59 X_Invoice_Line_Type VARCHAR2,
60 X_Unearned_Revenue_Cr NUMBER,
61 X_Unbilled_Receivable_Dr NUMBER,
62 X_Task_Id NUMBER,
63 X_Event_Task_Id NUMBER,
64 X_Event_Num NUMBER,
65 X_Ship_To_Address_Id NUMBER,
66 X_Taxable_Flag VARCHAR2,
67 X_Draft_Inv_Line_Num_Credited NUMBER,
68 X_Last_Update_Login NUMBER,
69 X_output_tax_code VARCHAR2,
70 X_output_tax_exempt_flag VARCHAR2,
71 X_out_tax_exempt_reason_code VARCHAR2,
72 X_output_tax_exempt_number VARCHAR2,
73 X_translated_text VARCHAR2
74 );
75 PROCEDURE Delete_Row(X_Rowid VARCHAR2);
76
77 END PA_DRAFT_INVOICE_ITEMS_PKG;