1 PACKAGE ar_ame_cm_attributes_api AUTHID CURRENT_USER AS
2 /* $Header: ARAMEATS.pls 115.3 2003/06/05 22:02:39 orashid noship $ */
3
4
5 c_application_id CONSTANT fnd_application.application_id%TYPE := 222;
6 c_item_type CONSTANT wf_item_attributes.item_type%TYPE := 'ARAMECM';
7
8 -----------------------------------------------------------------------------
9
10
11 FUNCTION get_customer_id (p_transaction_id IN NUMBER)
12 RETURN NUMBER;
13
14 FUNCTION get_customer_trx_id (p_transaction_id IN NUMBER)
15 RETURN NUMBER;
16
17 FUNCTION get_bill_to_use_id (p_transaction_id IN NUMBER)
18 RETURN NUMBER;
19
20 FUNCTION get_collector_id (p_transaction_id IN NUMBER)
21 RETURN VARCHAR2;
22
23 FUNCTION get_non_default_person_id (p_transaction_id IN NUMBER)
24 RETURN NUMBER;
25
26 FUNCTION get_requestor_person_id (p_transaction_id IN NUMBER)
27 RETURN NUMBER;
28
29 FUNCTION get_approval_path (p_transaction_id IN NUMBER)
30 RETURN VARCHAR2;
31
32 FUNCTION get_reason_code (p_transaction_id IN NUMBER)
33 RETURN VARCHAR2;
34
35 FUNCTION get_transaction_amount (p_transaction_id IN NUMBER)
36 RETURN NUMBER;
37
38 -- Get Approver ID
39 FUNCTION get_approver_id (p_transaction_id IN NUMBER)
40 RETURN NUMBER;
41
42 -- Get Approver User Name
43 FUNCTION get_approver_user_name (p_transaction_id IN NUMBER)
44 RETURN VARCHAR2;
45
46 -- Get Batch Source Name
47 FUNCTION get_batch_source_name (p_transaction_id IN NUMBER)
48 RETURN VARCHAR2;
49
50 -- Get Bill to Customer Name
51 FUNCTION get_bill_to_customer_name (p_transaction_id IN NUMBER)
52 RETURN VARCHAR2;
53
54 -- Get Bill to Customer Number
55 FUNCTION get_bill_to_customer_number (p_transaction_id IN NUMBER)
56 RETURN VARCHAR2;
57
58 -- Get Collector Employee Id
59 FUNCTION get_collector_employee_id (p_transaction_id IN NUMBER)
60 RETURN NUMBER;
61
62 -- Get Collector Name
63 FUNCTION get_collector_name (p_transaction_id IN NUMBER)
64 RETURN VARCHAR2;
65
66 -- Get Collector User Name
67 FUNCTION get_collector_user_name (p_transaction_id IN NUMBER)
68 RETURN VARCHAR2;
69
70 -- Get Currency Code
71 FUNCTION get_currency_code (p_transaction_id IN NUMBER)
72 RETURN VARCHAR2;
73
74 -- Get Customer Name
75 FUNCTION get_customer_name (p_transaction_id IN NUMBER)
76 RETURN VARCHAR2;
77
78 -- Get Original Transaction Number
79 FUNCTION get_orig_trx_number (p_transaction_id IN NUMBER)
80 RETURN VARCHAR2;
81
82 -- Get Requestor Id
83 FUNCTION get_requestor_id (p_transaction_id IN NUMBER)
84 RETURN NUMBER;
85
86 -- Get Requestor User Name
87 FUNCTION get_requestor_user_name (p_transaction_id IN NUMBER)
88 RETURN VARCHAR2;
89
90 -- Get Ship to Customer Name
91 FUNCTION get_ship_to_customer_name (p_transaction_id IN NUMBER)
92 RETURN VARCHAR2;
93
94 -- Get Ship to Customer Number
95 FUNCTION get_ship_to_customer_number (p_transaction_id IN NUMBER)
96 RETURN VARCHAR2;
97
98 -- Tax Ex Certification Number
99 FUNCTION get_tax_ex_cert_num (p_transaction_id IN NUMBER)
100 RETURN VARCHAR2;
101
102 -- primary salesperson user name
103 FUNCTION get_salesrep_user_name (p_transaction_id IN NUMBER)
104 RETURN VARCHAR2;
105
106 -- transaction type name
107 FUNCTION get_transaction_type_name (p_transaction_id IN NUMBER)
108 RETURN VARCHAR2;
109
110 -- transaction context
111 FUNCTION get_transaction_context (p_transaction_id IN NUMBER)
112 RETURN VARCHAR2;
113
114 END ar_ame_cm_attributes_api;