APPS.ARP_DESCR_FLEX dependencies on RA_CUSTOMER_TRX_LINES

Line 11: | ra_customer_trx_lines tables. |

7: | PUBLIC PROCEDURE: get_concatenated_segments |
8: | |
9: | This procedure returns the concatenated segments and context values |
10: | of the descriptive flexfields in the ra_customer_trx and |
11: | ra_customer_trx_lines tables. |
12: | For now, this function hardcodes all column and flexfield information. |
13: | When PL/SQL supports dynamic SQL, this function could be rewritten to |
14: | be more generic. |
15: | |

Line 31: cursor ra_customer_trx_lines_C( p_flex_name in varchar2,

27:
28:
29: first boolean;
30:
31: cursor ra_customer_trx_lines_C( p_flex_name in varchar2,
32: p_customer_trx_line_id in number) IS
33: select decode(u.descriptive_flexfield_name,
34: 'RA_INTERFACE_LINES',
35: decode(u.application_column_name,

Line 51: 'RA_CUSTOMER_TRX_LINES_GOV', l.default_ussgl_transaction_code,

47: 'INTERFACE_LINE_ATTRIBUTE12', l.interface_line_attribute12,
48: 'INTERFACE_LINE_ATTRIBUTE13', l.interface_line_attribute13,
49: 'INTERFACE_LINE_ATTRIBUTE14', l.interface_line_attribute14,
50: 'INTERFACE_LINE_ATTRIBUTE15', l.interface_line_attribute15),
51: 'RA_CUSTOMER_TRX_LINES_GOV', l.default_ussgl_transaction_code,
52: 'RA_CUSTOMER_TRX_LINES', decode(u.application_column_name,
53: 'ATTRIBUTE1', l.attribute1,
54: 'ATTRIBUTE2', l.attribute2,
55: 'ATTRIBUTE3', l.attribute3,

Line 52: 'RA_CUSTOMER_TRX_LINES', decode(u.application_column_name,

48: 'INTERFACE_LINE_ATTRIBUTE13', l.interface_line_attribute13,
49: 'INTERFACE_LINE_ATTRIBUTE14', l.interface_line_attribute14,
50: 'INTERFACE_LINE_ATTRIBUTE15', l.interface_line_attribute15),
51: 'RA_CUSTOMER_TRX_LINES_GOV', l.default_ussgl_transaction_code,
52: 'RA_CUSTOMER_TRX_LINES', decode(u.application_column_name,
53: 'ATTRIBUTE1', l.attribute1,
54: 'ATTRIBUTE2', l.attribute2,
55: 'ATTRIBUTE3', l.attribute3,
56: 'ATTRIBUTE4', l.attribute4,

Line 71: 'RA_CUSTOMER_TRX_LINES_GOV', l.default_ussgl_trx_code_context,

67: 'ATTRIBUTE15', l.attribute15)
68: ) segment_value,
69: decode(u.descriptive_flexfield_name,
70: 'RA_INTERFACE_LINES', l.interface_line_context,
71: 'RA_CUSTOMER_TRX_LINES_GOV', l.default_ussgl_trx_code_context,
72: 'RA_CUSTOMER_TRX_LINES', l.attribute_category,
73: '') context,
74: f.concatenated_segment_delimiter delimiter
75: from fnd_descr_flex_column_usages u,

Line 72: 'RA_CUSTOMER_TRX_LINES', l.attribute_category,

68: ) segment_value,
69: decode(u.descriptive_flexfield_name,
70: 'RA_INTERFACE_LINES', l.interface_line_context,
71: 'RA_CUSTOMER_TRX_LINES_GOV', l.default_ussgl_trx_code_context,
72: 'RA_CUSTOMER_TRX_LINES', l.attribute_category,
73: '') context,
74: f.concatenated_segment_delimiter delimiter
75: from fnd_descr_flex_column_usages u,
76: fnd_descriptive_flexs f,

Line 77: ra_customer_trx_lines l

73: '') context,
74: f.concatenated_segment_delimiter delimiter
75: from fnd_descr_flex_column_usages u,
76: fnd_descriptive_flexs f,
77: ra_customer_trx_lines l
78: where u.descriptive_flexfield_name = p_flex_name
79: and u.application_id = 222
80: and u.enabled_flag = 'Y'
81: and u.descriptive_flexfield_name = f.descriptive_flexfield_name

Line 86: 'RA_CUSTOMER_TRX_LINES_GOV', l.default_ussgl_trx_code_context,

82: and u.application_id = f.application_id
83: and nvl(
84: decode(u.descriptive_flexfield_name,
85: 'RA_INTERFACE_LINES', l.interface_line_context,
86: 'RA_CUSTOMER_TRX_LINES_GOV', l.default_ussgl_trx_code_context,
87: 'RA_CUSTOMER_TRX_LINES', l.attribute_category,
88: ''),
89: 'Global Data Elements'
90: ) = descriptive_flex_context_code

Line 87: 'RA_CUSTOMER_TRX_LINES', l.attribute_category,

83: and nvl(
84: decode(u.descriptive_flexfield_name,
85: 'RA_INTERFACE_LINES', l.interface_line_context,
86: 'RA_CUSTOMER_TRX_LINES_GOV', l.default_ussgl_trx_code_context,
87: 'RA_CUSTOMER_TRX_LINES', l.attribute_category,
88: ''),
89: 'Global Data Elements'
90: ) = descriptive_flex_context_code
91: and customer_trx_line_id = p_customer_trx_line_id

Line 168: if (p_table_name = 'RA_CUSTOMER_TRX_LINES')

164: | Select each segment of the flexfield in order and concatenate |
165: | it onto the previous segments. |
166: +----------------------------------------------------------------*/
167:
168: if (p_table_name = 'RA_CUSTOMER_TRX_LINES')
169: then
170: FOR segments in ra_customer_trx_lines_C(p_flex_name,
171: p_customer_trx_line_id )
172: LOOP

Line 170: FOR segments in ra_customer_trx_lines_C(p_flex_name,

166: +----------------------------------------------------------------*/
167:
168: if (p_table_name = 'RA_CUSTOMER_TRX_LINES')
169: then
170: FOR segments in ra_customer_trx_lines_C(p_flex_name,
171: p_customer_trx_line_id )
172: LOOP
173: if (first <> true)
174: then p_concatenated_segments := p_concatenated_segments ||