1 package icx_req_custom AUTHID CURRENT_USER as
2 /* $Header: ICXRQCUS.pls 115.1 99/07/17 03:23:12 porting ship $ */
3
4 procedure add_user_error(v_cart_id number,
5 error_message varchar2);
6
7 procedure cart_custom_build_req_account( v_cart_line_id IN NUMBER,
8 V_ACCOUNT_NUM OUT VARCHAR2,
9 V_ACCOUNT_ID OUT NUMBER,
10 RETURN_CODE OUT VARCHAR2);
11
12
13 procedure cart_custom_build_req_account2( v_cart_line_id IN NUMBER,
14 VARIANCE_ACCOUNT_ID OUT NUMBER,
15 BUDGET_ACCOUNT_ID OUT NUMBER,
16 ACCRUAL_ACCOUNT_ID OUT NUMBER,
17 RETURN_CODE OUT VARCHAR2);
18
19
20 procedure po_custom_build_req_account(EMPLOYEE_ID IN NUMBER,
21 employee_default_account_id IN NUMBER,
22 employee_org_id IN NUMBER,
23 employee_bus_group_id NUMBER,
24 po_org_id IN NUMBER,
25 NEED_BY_DATE IN DATE,
26 DESTINATION_TYPE IN VARCHAR2,
27 DESTINATION_ORG_ID IN NUMBER,
28 SITE_ID IN NUMBER,
29 set_of_books_id IN NUMBER,
30 ITEM_ID IN NUMBER,
31 ITEM_REVISION IN VARCHAR2,
32 ITEM_DESCRIPTION IN VARCHAR2,
33 item_default_account_id IN NUMBER,
34 UNIT_OF_MEASURE IN VARCHAR2,
35 QUANTITY IN NUMBER,
36 PRICE IN NUMBER,
37 SUPPLIER_ITEM_NUM IN VARCHAR2,
38 CATEGORY_ID IN NUMBER,
39 LINE_TYPE IN NUMBER,
40 SUPPLIER IN VARCHAR2,
41 SUPPLIER_SITE IN VARCHAR2,
42 SOURCE_DOC_NUM IN VARCHAR2,
43 SOURCE_LINE_NUM IN NUMBER,
44 CHARGE_ACCT_LINE_SEGMENTS IN VARCHAR2,
45 ACCOUNT_NUM OUT VARCHAR2,
46 CHARGE_ACCOUNT_ID OUT NUMBER,
47 RETURN_CODE OUT VARCHAR2);
48
49
50 procedure po_custom_build_req_account2(EMPLOYEE_ID IN NUMBER,
51 employee_default_account_id IN NUMBER,
52 employee_org_id IN NUMBER,
53 employee_bus_group_id NUMBER,
54 po_org_id IN NUMBER,
55 NEED_BY_DATE IN DATE,
56 DESTINATION_TYPE IN VARCHAR2,
57 DESTINATION_ORG_ID IN NUMBER,
58 SITE_ID IN NUMBER,
59 set_of_books_id IN NUMBER,
60 ITEM_ID IN NUMBER,
61 ITEM_REVISION IN VARCHAR2,
62 ITEM_DESCRIPTION IN VARCHAR2,
63 item_default_account_id IN NUMBER,
64 UNIT_OF_MEASURE IN VARCHAR2,
65 QUANTITY IN NUMBER,
66 PRICE IN NUMBER,
67 SUPPLIER_ITEM_NUM IN VARCHAR2,
68 CATEGORY_ID IN NUMBER,
69 LINE_TYPE IN NUMBER,
70 SUPPLIER IN VARCHAR2,
71 SUPPLIER_SITE IN VARCHAR2,
72 SOURCE_DOC_NUM IN VARCHAR2,
73 SOURCE_LINE_NUM IN NUMBER,
74 CHARGE_ACCT_LINE_SEGMENTS IN VARCHAR2,
75 CHARGE_ACCOUNT_ID IN NUMBER,
76 ACCOUNT_NUM OUT VARCHAR2,
77 VARIANCE_ACCOUNT_ID OUT NUMBER,
78 BUDGET_ACCOUNT_ID OUT NUMBER,
79 ACCRUAL_ACCOUNT_ID OUT NUMBER,
80 RETURN_CODE OUT VARCHAR2);
81
82 procedure reqs_validate_head(p_emergency IN VARCHAR2,
83 v_cart_id IN NUMBER);
84
85
86 procedure reqs_validate_line(p_emergency IN VARCHAR2,
87 v_cart_id number);
88
89
90 procedure reqs_default_lines(p_emergency IN VARCHAR2,
91 cartId IN number);
92
93 procedure reqs_default_head(p_emergency in VARCHAR2,
94 v_cart_id in NUMBER);
95
96
97 end icx_req_custom;