9: function : This function returns the values for the intercompany transaction
10: attributes that are used within AME. These values are used when
11: evaluating AME rules and conditions
12: Parameters:
13: IN : p_transaction_id - fun_trx_headers.trx_id
14: p_dist_id - fun_trx_dist_lines.dist_id
15: p_attribute_name - Name of the attribute whose value is required.
16: OUT : Value of the attribute.
17: Notes : None.
33: SELECT DISTINCT hz.party_name
34: INTO l_return_value
35: FROM hz_parties hz,
36: fun_trx_batches btch,
37: fun_trx_headers head
38: WHERE hz.party_id = btch.initiator_id
39: AND btch.batch_id = head.batch_id
40: AND head.trx_id = p_transaction_id;
41:
44: SELECT DISTINCT xla.name
45: INTO l_return_value
46: FROM xle_firstparty_information_v xla,
47: fun_trx_batches btch,
48: fun_trx_headers head
49: WHERE xla.legal_entity_id = btch.from_le_id
50: AND btch.batch_id = head.batch_id
51: AND head.trx_id = p_transaction_id;
52:
55: SELECT DISTINCT gl.name
56: INTO l_return_value
57: FROM gl_ledgers gl,
58: fun_trx_batches btch,
59: fun_trx_headers head
60: WHERE gl.ledger_id = btch.from_ledger_id
61: AND btch.batch_id = head.batch_id
62: AND head.trx_id = p_transaction_id;
63:
66: SELECT DISTINCT tt.trx_type_name
67: INTO l_return_value
68: FROM fun_trx_types_tl tt,
69: fun_trx_batches btch,
70: fun_trx_headers head
71: WHERE tt.trx_type_id = btch.trx_type_id
72: AND btch.batch_id = head.batch_id
73: AND head.trx_id = p_transaction_id;
74:
76: THEN
77: SELECT DISTINCT hz.party_name
78: INTO l_return_value
79: FROM hz_parties hz,
80: fun_trx_headers head
81: WHERE hz.party_id = head.initiator_id
82: AND head.trx_id = p_transaction_id;
83:
84: ELSIF p_attribute_name = 'HEADER_RECIPIENT_NAME'
85: THEN
86: SELECT DISTINCT hz.party_name
87: INTO l_return_value
88: FROM hz_parties hz,
89: fun_trx_headers head
90: WHERE hz.party_id = head.recipient_id
91: AND head.trx_id = p_transaction_id;
92:
93: ELSIF p_attribute_name = 'HEADER_TO_LE_NAME'
94: THEN
95: SELECT DISTINCT xla.name
96: INTO l_return_value
97: FROM xle_firstparty_information_v xla,
98: fun_trx_headers head
99: WHERE xla.legal_entity_id = head.to_le_id
100: AND head.trx_id = p_transaction_id;
101:
102: ELSIF p_attribute_name = 'HEADER_TO_LEDGER_NAME'
103: THEN
104: SELECT DISTINCT gl.name
105: INTO l_return_value
106: FROM gl_ledgers gl,
107: fun_trx_headers head
108: WHERE gl.ledger_id = head.to_ledger_id
109: AND head.trx_id = p_transaction_id;
110:
111: ELSIF p_attribute_name = 'DIST_PARTY_NAME'
162: IN : p_seg_name - Name of the Segment
163: Eg. GL_ACCOUNT, GL_BALANCING, FA_COST_CTR
164: p_ccid - Code Combination Id
165: p_dist_id - fun_trx_dist_lines.dist_id
166: p_transaction_id - fun_trx_headers.trx_id
167: OUT : Value of the attribute.
168: Notes : None.
169: Testing : This function can be tested using the 'Test' tab provided within AME
170: setup pages
186: BEGIN
187: SELECT chart_of_accounts_id
188: INTO l_chart_of_accounts_id
189: FROM gl_ledgers gl,
190: fun_trx_headers head
191: WHERE gl.ledger_id = head.to_ledger_id
192: AND head.trx_id = p_transaction_id;
193:
194: l_result := fnd_flex_ext.get_segments(