1 PACKAGE AP_WEB_WRAPPER_PKG AS
2 /* $Header: apwxwrps.pls 120.2 2005/09/07 21:56:44 rlangi ship $ */
3
4
5 /**********************************************************************
6 * Copied FND_DATE.canonical_mask revision 115.5 in the spec for R11 backport
7 * because the old R11.0 did not have this, which
8 * is used by AP_CREDIT_CARD_INVOICE_PKG.createCreditCardInvoice.
9 **********************************************************************/
10 canonical_mask varchar2(15) := 'YYYY/MM/DD';
11 canonical_DT_mask varchar2(26) := 'YYYY/MM/DD HH24:MI:SS';
12
13 --------------------------------------------------------------------------
14 PROCEDURE ICXAdminSig_helpWinScript(v_defHlp IN VARCHAR2);
15
16 PROCEDURE GenTaxFunctions;
17
18 PROCEDURE SetUpClientInfo;
19
20 FUNCTION date_to_canonical(p_string IN DATE)
21 RETURN VARCHAR2;
22
23 FUNCTION string_to_date(p_string IN VARCHAR2,
24 p_mask IN VARCHAR2)
25 RETURN DATE;
26
27 PROCEDURE insert_dist (p_invoice_id IN number,
28 p_Line_Type IN varchar2,
29 p_GL_Date IN date,
30 p_Period_Name IN varchar2,
31 p_Type_1099 IN varchar2,
32 p_Income_Tax_Region IN varchar2,
33 p_Amount IN number,
34 p_Vat_Code IN varchar2,
35 p_Code_Combination_Id IN number,
36 p_PA_Quantity IN number,
37 p_Description IN varchar2,
38 -- Bug 1105325. Passing the project info.
39 p_Project_Acct_Cont IN varchar2,
40 p_Project_Id IN number,
41 p_Task_Id IN number,
42 p_Expenditure_Type IN varchar2,
43 p_Expenditure_Org_Id IN number,
44 p_Exp_item_date IN date,
45 --Bug# 763539 . Passin the attribute category and the attributes
46 p_Attribute_Category IN varchar2,
47 p_Attribute1 IN varchar2,
48 p_Attribute2 IN varchar2,
49 p_Attribute3 IN varchar2,
50 p_Attribute4 IN varchar2,
51 p_Attribute5 IN varchar2,
52 p_Attribute6 IN varchar2,
53 p_Attribute7 IN varchar2,
54 p_Attribute8 IN varchar2,
55 p_Attribute9 IN varchar2,
56 p_Attribute10 IN varchar2,
57 p_Attribute11 IN varchar2,
58 p_Attribute12 IN varchar2,
59 p_Attribute13 IN varchar2,
60 p_Attribute14 IN varchar2,
61 p_Attribute15 IN varchar2,
62 --backport. Exists in 11i but not in 11.0
63 p_invoice_distribution_id IN number,
64 p_Tax_Code_Id IN NUMBER,
65 p_tax_recoverable_flag IN varchar2,
66 p_tax_recovery_rate IN number,
67 p_tax_code_override_flag IN varchar2,
68 p_tax_recovery_override_flag IN varchar2,
69 p_po_distribution_id IN number,
70 --end backport.
71 p_Calling_Sequence IN varchar2,
72 p_company_prepaid_invoice_id IN number DEFAULT NULL,
73 p_cc_reversal_flag IN varchar2 DEFAULT NULL);
74
75 PROCEDURE ValidatePATransaction(
76 P_project_id IN NUMBER,
77 P_task_id IN NUMBER,
78 P_ei_date IN DATE,
79 P_expenditure_type IN VARCHAR2,
80 P_non_labor_resource IN VARCHAR2,
81 P_person_id IN NUMBER,
82 P_quantity IN NUMBER DEFAULT NULL,
83 P_denom_currency_code IN VARCHAR2 DEFAULT NULL,
84 P_acct_currency_code IN VARCHAR2 DEFAULT NULL,
85 P_denom_raw_cost IN NUMBER DEFAULT NULL,
86 P_acct_raw_cost IN NUMBER DEFAULT NULL,
87 P_acct_rate_type IN VARCHAR2 DEFAULT NULL,
88 P_acct_rate_date IN DATE DEFAULT NULL,
89 P_acct_exchange_rate IN NUMBER DEFAULT NULL ,
90 P_transfer_ei IN NUMBER DEFAULT NULL,
91 P_incurred_by_org_id IN NUMBER DEFAULT NULL,
92 P_nl_resource_org_id IN NUMBER DEFAULT NULL,
93 P_transaction_source IN VARCHAR2 DEFAULT NULL ,
94 P_calling_module IN VARCHAR2 DEFAULT NULL,
95 P_vendor_id IN NUMBER DEFAULT NULL,
96 P_entered_by_user_id IN NUMBER DEFAULT NULL,
97 P_attribute_category IN VARCHAR2 DEFAULT NULL,
98 P_attribute1 IN VARCHAR2 DEFAULT NULL,
99 P_attribute2 IN VARCHAR2 DEFAULT NULL,
100 P_attribute3 IN VARCHAR2 DEFAULT NULL,
101 P_attribute4 IN VARCHAR2 DEFAULT NULL,
102 P_attribute5 IN VARCHAR2 DEFAULT NULL,
103 P_attribute6 IN VARCHAR2 DEFAULT NULL,
104 P_attribute7 IN VARCHAR2 DEFAULT NULL,
105 P_attribute8 IN VARCHAR2 DEFAULT NULL,
106 P_attribute9 IN VARCHAR2 DEFAULT NULL,
107 P_attribute10 IN VARCHAR2 DEFAULT NULL,
108 P_attribute11 IN VARCHAR2 DEFAULT NULL,
109 P_attribute12 IN VARCHAR2 DEFAULT NULL,
110 P_attribute13 IN VARCHAR2 DEFAULT NULL,
111 P_attribute14 IN VARCHAR2 DEFAULT NULL,
112 P_attribute15 IN VARCHAR2 DEFAULT NULL,
113 P_MsgApplication IN OUT NOCOPY VARCHAR2,
114 P_MsgType OUT NOCOPY VARCHAR2,
115 P_MsgToken1 OUT NOCOPY VARCHAR2,
116 P_MsgToken2 OUT NOCOPY VARCHAR2,
117 P_MsgToken3 OUT NOCOPY VARCHAR2,
118 P_MsgCount OUT NOCOPY NUMBER,
119 P_MsgName OUT NOCOPY VARCHAR2, -- P_msg_data will contain the error msg
120 P_Msg_Data OUT NOCOPY VARCHAR2,
121 P_billable_flag OUT NOCOPY VARCHAR2);
122
123 PROCEDURE HaveAMEReCreateApprovalChain(p_approver_id IN NUMBER,
124 p_item_key IN VARCHAR2,
125 p_item_type IN VARCHAR2);
126
127 PROCEDURE SetRejectStatusInAME( p_item_key IN VARCHAR2,
128 p_item_type IN VARCHAR2);
129
130 PROCEDURE SetForwardInfoInAME( p_item_key IN VARCHAR2,
131 p_item_type IN VARCHAR2);
132
133 FUNCTION isPopList(p_ValueSetFormat FND_VSET.VALUESET_DR) RETURN BOOLEAN;
134
135 END AP_WEB_WRAPPER_PKG;