PACKAGE: APPS.AR_AME_CM_ATTRIBUTES_API

Source

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;