DBA Data[Home] [Help]

APPS.ECX_XREF_API dependencies on STANDARD

Line 32: p_standard IN VARCHAR2,

28: x_msg OUT NOCOPY VARCHAR2,
29: x_xref_ext_value OUT NOCOPY VARCHAR2,
30: p_tp_header_id IN PLS_INTEGER,
31: p_xref_category_code IN VARCHAR2,
32: p_standard IN VARCHAR2,
33: p_xref_int_value IN VARCHAR2,
34: x_xref_dtl_id OUT NOCOPY PLS_INTEGER,
35: p_standard_type IN VARCHAR2 DEFAULT 'XML');
36:

Line 35: p_standard_type IN VARCHAR2 DEFAULT 'XML');

31: p_xref_category_code IN VARCHAR2,
32: p_standard IN VARCHAR2,
33: p_xref_int_value IN VARCHAR2,
34: x_xref_dtl_id OUT NOCOPY PLS_INTEGER,
35: p_standard_type IN VARCHAR2 DEFAULT 'XML');
36:
37: PROCEDURE retrieve_tp_internal_value(
38: x_return_status OUT NOCOPY PLS_INTEGER,
39: x_msg OUT NOCOPY VARCHAR2,

Line 43: p_standard IN VARCHAR2,

39: x_msg OUT NOCOPY VARCHAR2,
40: x_xref_int_value OUT NOCOPY VARCHAR2,
41: p_tp_header_id IN PLS_INTEGER,
42: p_xref_category_code IN VARCHAR2,
43: p_standard IN VARCHAR2,
44: p_xref_ext_value IN VARCHAR2,
45: x_xref_dtl_id OUT NOCOPY PLS_INTEGER,
46: p_standard_type IN VARCHAR2 DEFAULT 'XML');
47:

Line 46: p_standard_type IN VARCHAR2 DEFAULT 'XML');

42: p_xref_category_code IN VARCHAR2,
43: p_standard IN VARCHAR2,
44: p_xref_ext_value IN VARCHAR2,
45: x_xref_dtl_id OUT NOCOPY PLS_INTEGER,
46: p_standard_type IN VARCHAR2 DEFAULT 'XML');
47:
48: PROCEDURE retrieve_tp_code_values_by_id(
49: x_return_status OUT NOCOPY PLS_INTEGER,
50: x_msg OUT NOCOPY VARCHAR2,

Line 52: x_standard_code OUT NOCOPY VARCHAR2,

48: PROCEDURE retrieve_tp_code_values_by_id(
49: x_return_status OUT NOCOPY PLS_INTEGER,
50: x_msg OUT NOCOPY VARCHAR2,
51: x_xref_category_code OUT NOCOPY VARCHAR2,
52: x_standard_code OUT NOCOPY VARCHAR2,
53: x_xref_ext_value OUT NOCOPY VARCHAR2,
54: x_xref_int_value OUT NOCOPY VARCHAR2,
55: x_direction OUT NOCOPY VARCHAR2,
56: p_xref_dtl_id IN PLS_INTEGER,

Line 59: x_standard_id OUT NOCOPY PLS_INTEGER,

55: x_direction OUT NOCOPY VARCHAR2,
56: p_xref_dtl_id IN PLS_INTEGER,
57: x_cat_description OUT NOCOPY VARCHAR2,
58: x_xref_category_id OUT NOCOPY NUMBER,
59: x_standard_id OUT NOCOPY PLS_INTEGER,
60: x_tp_header_id OUT NOCOPY PLS_INTEGER,
61: x_description OUT NOCOPY VARCHAR2,
62: x_created_by OUT NOCOPY PLS_INTEGER,
63: x_creation_date OUT NOCOPY DATE,

Line 73: p_standard IN VARCHAR2,

69: x_msg OUT NOCOPY VARCHAR2,
70: x_xref_dtl_id OUT NOCOPY PLS_INTEGER,
71: x_xref_category_id OUT NOCOPY PLS_INTEGER,
72: p_xref_category_code IN VARCHAR2,
73: p_standard IN VARCHAR2,
74: p_xref_ext_value IN VARCHAR2,
75: p_xref_int_value IN VARCHAR2,
76: p_direction IN VARCHAR2,
77: x_cat_description OUT NOCOPY VARCHAR2,

Line 78: x_standard_id OUT NOCOPY PLS_INTEGER,

74: p_xref_ext_value IN VARCHAR2,
75: p_xref_int_value IN VARCHAR2,
76: p_direction IN VARCHAR2,
77: x_cat_description OUT NOCOPY VARCHAR2,
78: x_standard_id OUT NOCOPY PLS_INTEGER,
79: x_tp_header_id OUT NOCOPY PLS_INTEGER,
80: x_description OUT NOCOPY VARCHAR2,
81: x_created_by OUT NOCOPY PLS_INTEGER,
82: x_creation_date OUT NOCOPY DATE,

Line 85: p_standard_type IN VARCHAR2 DEFAULT 'XML');

81: x_created_by OUT NOCOPY PLS_INTEGER,
82: x_creation_date OUT NOCOPY DATE,
83: x_last_updated_by OUT NOCOPY PLS_INTEGER,
84: x_last_update_date OUT NOCOPY DATE,
85: p_standard_type IN VARCHAR2 DEFAULT 'XML');
86:
87: PROCEDURE create_tp_code_values(
88: x_return_status OUT NOCOPY PLS_INTEGER,
89: x_msg OUT NOCOPY VARCHAR2,

Line 93: p_standard IN VARCHAR2,

89: x_msg OUT NOCOPY VARCHAR2,
90: x_xref_dtl_id OUT NOCOPY PLS_INTEGER,
91: x_xref_category_id OUT NOCOPY PLS_INTEGER,
92: p_xref_category_code IN VARCHAR2,
93: p_standard IN VARCHAR2,
94: p_tp_header_id IN PLS_INTEGER,
95: p_xref_ext_value IN VARCHAR2,
96: p_xref_int_value IN VARCHAR2,
97: p_description IN VARCHAR2,

Line 99: p_standard_type IN VARCHAR2 DEFAULT 'XML');

95: p_xref_ext_value IN VARCHAR2,
96: p_xref_int_value IN VARCHAR2,
97: p_description IN VARCHAR2,
98: p_direction IN VARCHAR2,
99: p_standard_type IN VARCHAR2 DEFAULT 'XML');
100:
101: PROCEDURE update_tp_code_values(
102: x_return_status OUT NOCOPY PLS_INTEGER,
103: x_msg OUT NOCOPY VARCHAR2,

Line 116: PROCEDURE retrieve_standard_code_values(

112: x_return_status OUT NOCOPY PLS_INTEGER,
113: x_msg OUT NOCOPY VARCHAR2,
114: p_xref_dtl_id IN PLS_INTEGER);
115:
116: PROCEDURE retrieve_standard_code_values(
117: x_return_status OUT NOCOPY PLS_INTEGER,
118: x_msg OUT NOCOPY VARCHAR2,
119: x_xref_std_id OUT NOCOPY PLS_INTEGER,
120: x_xref_category_id OUT NOCOPY PLS_INTEGER,

Line 122: p_standard IN VARCHAR2,

118: x_msg OUT NOCOPY VARCHAR2,
119: x_xref_std_id OUT NOCOPY PLS_INTEGER,
120: x_xref_category_id OUT NOCOPY PLS_INTEGER,
121: p_xref_category_code IN VARCHAR2,
122: p_standard IN VARCHAR2,
123: p_xref_std_value IN VARCHAR2,
124: p_xref_int_value IN VARCHAR2,
125: x_cat_description OUT NOCOPY VARCHAR2,
126: x_standard_id OUT NOCOPY PLS_INTEGER,

Line 126: x_standard_id OUT NOCOPY PLS_INTEGER,

122: p_standard IN VARCHAR2,
123: p_xref_std_value IN VARCHAR2,
124: p_xref_int_value IN VARCHAR2,
125: x_cat_description OUT NOCOPY VARCHAR2,
126: x_standard_id OUT NOCOPY PLS_INTEGER,
127: x_description OUT NOCOPY VARCHAR2,
128: x_data_seeded OUT NOCOPY VARCHAR2,
129: x_created_by OUT NOCOPY PLS_INTEGER,
130: x_creation_date OUT NOCOPY DATE,

Line 133: p_standard_type IN VARCHAR2 DEFAULT 'XML');

129: x_created_by OUT NOCOPY PLS_INTEGER,
130: x_creation_date OUT NOCOPY DATE,
131: x_last_updated_by OUT NOCOPY PLS_INTEGER,
132: x_last_update_date OUT NOCOPY DATE,
133: p_standard_type IN VARCHAR2 DEFAULT 'XML');
134:
135:
136: PROCEDURE create_standard_code_values(
137: x_return_status OUT NOCOPY PLS_INTEGER,

Line 136: PROCEDURE create_standard_code_values(

132: x_last_update_date OUT NOCOPY DATE,
133: p_standard_type IN VARCHAR2 DEFAULT 'XML');
134:
135:
136: PROCEDURE create_standard_code_values(
137: x_return_status OUT NOCOPY PLS_INTEGER,
138: x_msg OUT NOCOPY VARCHAR2,
139: x_xref_std_id OUT NOCOPY PLS_INTEGER,
140: x_xref_category_id OUT NOCOPY PLS_INTEGER,

Line 142: p_standard IN VARCHAR2,

138: x_msg OUT NOCOPY VARCHAR2,
139: x_xref_std_id OUT NOCOPY PLS_INTEGER,
140: x_xref_category_id OUT NOCOPY PLS_INTEGER,
141: p_xref_category_code IN VARCHAR2,
142: p_standard IN VARCHAR2,
143: p_xref_std_value IN VARCHAR2,
144: p_xref_int_value IN VARCHAR2,
145: p_description IN VARCHAR2,
146: p_data_seeded IN VARCHAR2 DEFAULT 'N',

Line 148: p_standard_type IN VARCHAR2 DEFAULT 'XML'

144: p_xref_int_value IN VARCHAR2,
145: p_description IN VARCHAR2,
146: p_data_seeded IN VARCHAR2 DEFAULT 'N',
147: p_owner IN VARCHAR2 DEFAULT 'CUSTOM',
148: p_standard_type IN VARCHAR2 DEFAULT 'XML'
149: );
150:
151: PROCEDURE update_standard_code_values(
152: x_return_status OUT NOCOPY PLS_INTEGER,

Line 151: PROCEDURE update_standard_code_values(

147: p_owner IN VARCHAR2 DEFAULT 'CUSTOM',
148: p_standard_type IN VARCHAR2 DEFAULT 'XML'
149: );
150:
151: PROCEDURE update_standard_code_values(
152: x_return_status OUT NOCOPY PLS_INTEGER,
153: x_msg OUT NOCOPY VARCHAR2,
154: p_xref_standard_id IN PLS_INTEGER,
155: p_xref_std_value IN VARCHAR2,

Line 154: p_xref_standard_id IN PLS_INTEGER,

150:
151: PROCEDURE update_standard_code_values(
152: x_return_status OUT NOCOPY PLS_INTEGER,
153: x_msg OUT NOCOPY VARCHAR2,
154: p_xref_standard_id IN PLS_INTEGER,
155: p_xref_std_value IN VARCHAR2,
156: p_xref_int_value IN VARCHAR2,
157: p_description IN VARCHAR2,
158: p_owner IN VARCHAR2 DEFAULT 'CUSTOM'

Line 161: PROCEDURE delete_standard_code_values(

157: p_description IN VARCHAR2,
158: p_owner IN VARCHAR2 DEFAULT 'CUSTOM'
159: );
160:
161: PROCEDURE delete_standard_code_values(
162: x_return_status OUT NOCOPY PLS_INTEGER,
163: x_msg OUT NOCOPY VARCHAR2,
164: p_xref_standard_id IN PLS_INTEGER
165: );

Line 164: p_xref_standard_id IN PLS_INTEGER

160:
161: PROCEDURE delete_standard_code_values(
162: x_return_status OUT NOCOPY PLS_INTEGER,
163: x_msg OUT NOCOPY VARCHAR2,
164: p_xref_standard_id IN PLS_INTEGER
165: );
166:
167: end ECX_XREF_API;