eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_T_UTILITIES_PVT dependencies on CSI_T_DATASTRUCTURES_GRP

Line 13: p_txn_line_detial_tbl in csi_t_datastructures_grp.txn_line_detail_tbl,

9: csi_t_gen_utility_pvt.add(p_message);
10: END debug;
11:
12: PROCEDURE build_instance_id_list(
13: p_txn_line_detial_tbl in csi_t_datastructures_grp.txn_line_detail_tbl,
14: x_instance_id_list OUT NOCOPY varchar2,
15: x_return_status OUT NOCOPY varchar2)
16: IS
17: l_instance_id_list varchar2(1000);

Line 48: p_txn_line_detial_tbl in csi_t_datastructures_grp.txn_line_detail_tbl,

44:
45: END build_instance_id_list;
46:
47: PROCEDURE build_txn_line_id_list(
48: p_txn_line_detial_tbl in csi_t_datastructures_grp.txn_line_detail_tbl,
49: x_txn_line_id_list OUT NOCOPY varchar2,
50: x_return_status OUT NOCOPY varchar2)
51: IS
52:

Line 76: p_txn_party_detial_tbl in csi_t_datastructures_grp.txn_party_detail_tbl,

72:
73: END build_txn_line_id_list;
74:
75: PROCEDURE build_party_dtl_id_list(
76: p_txn_party_detial_tbl in csi_t_datastructures_grp.txn_party_detail_tbl,
77: x_party_dtl_id_list OUT NOCOPY varchar2,
78: x_return_status OUT NOCOPY varchar2)
79: IS
80: l_party_dtl_id_list varchar2(512);

Line 99: p_txn_line_detial_tbl in csi_t_datastructures_grp.txn_line_detail_tbl,

95:
96: END build_party_dtl_id_list;
97:
98: PROCEDURE build_line_dtl_id_list(
99: p_txn_line_detial_tbl in csi_t_datastructures_grp.txn_line_detail_tbl,
100: x_line_dtl_id_list OUT NOCOPY varchar2,
101: x_return_status OUT NOCOPY varchar2)
102: IS
103: l_line_dtl_id_list varchar2(512);

Line 123: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

119: END build_line_dtl_id_list;
120:
121: /* This routine merges the transaction details tables */
122: PROCEDURE merge_tables(
123: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
124: px_pty_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
125: px_pty_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
126: px_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
127: px_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

Line 124: px_pty_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,

120:
121: /* This routine merges the transaction details tables */
122: PROCEDURE merge_tables(
123: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
124: px_pty_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
125: px_pty_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
126: px_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
127: px_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
128: px_ext_attrib_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

Line 125: px_pty_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

121: /* This routine merges the transaction details tables */
122: PROCEDURE merge_tables(
123: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
124: px_pty_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
125: px_pty_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
126: px_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
127: px_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
128: px_ext_attrib_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
129: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,

Line 126: px_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

122: PROCEDURE merge_tables(
123: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
124: px_pty_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
125: px_pty_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
126: px_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
127: px_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
128: px_ext_attrib_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
129: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
130: --

Line 127: px_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

123: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
124: px_pty_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
125: px_pty_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
126: px_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
127: px_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
128: px_ext_attrib_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
129: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
130: --
131: p_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,

Line 128: px_ext_attrib_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

124: px_pty_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
125: px_pty_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
126: px_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
127: px_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
128: px_ext_attrib_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
129: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
130: --
131: p_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
132: p_pty_dtl_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,

Line 129: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,

125: px_pty_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
126: px_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
127: px_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
128: px_ext_attrib_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
129: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
130: --
131: p_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
132: p_pty_dtl_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
133: p_pty_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

Line 131: p_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,

127: px_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
128: px_ext_attrib_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
129: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
130: --
131: p_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
132: p_pty_dtl_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
133: p_pty_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
134: p_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
135: p_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,

Line 132: p_pty_dtl_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,

128: px_ext_attrib_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
129: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
130: --
131: p_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
132: p_pty_dtl_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
133: p_pty_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
134: p_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
135: p_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,
136: p_ext_attrib_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

Line 133: p_pty_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

129: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
130: --
131: p_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
132: p_pty_dtl_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
133: p_pty_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
134: p_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
135: p_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,
136: p_ext_attrib_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
137: p_txn_systems_tbl IN csi_t_datastructures_grp.txn_systems_tbl)

Line 134: p_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,

130: --
131: p_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
132: p_pty_dtl_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
133: p_pty_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
134: p_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
135: p_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,
136: p_ext_attrib_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
137: p_txn_systems_tbl IN csi_t_datastructures_grp.txn_systems_tbl)
138: IS

Line 135: p_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,

131: p_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
132: p_pty_dtl_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
133: p_pty_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
134: p_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
135: p_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,
136: p_ext_attrib_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
137: p_txn_systems_tbl IN csi_t_datastructures_grp.txn_systems_tbl)
138: IS
139:

Line 136: p_ext_attrib_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

132: p_pty_dtl_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
133: p_pty_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
134: p_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
135: p_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,
136: p_ext_attrib_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
137: p_txn_systems_tbl IN csi_t_datastructures_grp.txn_systems_tbl)
138: IS
139:
140: l_line_ind binary_integer;

Line 137: p_txn_systems_tbl IN csi_t_datastructures_grp.txn_systems_tbl)

133: p_pty_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
134: p_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
135: p_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,
136: p_ext_attrib_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
137: p_txn_systems_tbl IN csi_t_datastructures_grp.txn_systems_tbl)
138: IS
139:
140: l_line_ind binary_integer;
141: l_pty_ind binary_integer;

Line 243: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

239: pl/sql tables to be passed to the create API. Used in the Copy Txn Details
240: API
241: */
242: PROCEDURE convert_ids_to_index(
243: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
244: px_pty_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
245: px_pty_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
246: px_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
247: px_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

Line 244: px_pty_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,

240: API
241: */
242: PROCEDURE convert_ids_to_index(
243: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
244: px_pty_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
245: px_pty_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
246: px_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
247: px_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
248: px_ext_attrib_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

Line 245: px_pty_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

241: */
242: PROCEDURE convert_ids_to_index(
243: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
244: px_pty_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
245: px_pty_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
246: px_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
247: px_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
248: px_ext_attrib_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
249: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl)

Line 246: px_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

242: PROCEDURE convert_ids_to_index(
243: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
244: px_pty_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
245: px_pty_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
246: px_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
247: px_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
248: px_ext_attrib_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
249: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl)
250: IS

Line 247: px_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

243: px_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
244: px_pty_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
245: px_pty_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
246: px_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
247: px_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
248: px_ext_attrib_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
249: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl)
250: IS
251:

Line 248: px_ext_attrib_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

244: px_pty_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
245: px_pty_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
246: px_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
247: px_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
248: px_ext_attrib_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
249: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl)
250: IS
251:
252: l_debug_level NUMBER;

Line 249: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl)

245: px_pty_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
246: px_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
247: px_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
248: px_ext_attrib_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
249: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl)
250: IS
251:
252: l_debug_level NUMBER;
253: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 254: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

250: IS
251:
252: l_debug_level NUMBER;
253: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
254: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
255: ll_pa_ind binary_integer;
256:
257: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
258:

Line 257: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

253: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
254: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
255: ll_pa_ind binary_integer;
256:
257: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
258:
259: l_subject_index binary_integer;
260: l_object_index binary_integer;
261: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

Line 261: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

257: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
258:
259: l_subject_index binary_integer;
260: l_object_index binary_integer;
261: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
262:
263: BEGIN
264:
265: --debug messages

Line 481: p_txn_line_detial_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,

477: braces which can be used in a IN operator in a where clause
478: */
479:
480: PROCEDURE build_txn_system_id_list(
481: p_txn_line_detial_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
482: x_txn_system_id_list OUT NOCOPY varchar2,
483: x_return_status OUT NOCOPY varchar2)
484: IS
485: l_txn_system_id_list varchar2(1000);

Line 517: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,

513:
514: END build_txn_system_id_list;
515:
516: PROCEDURE source_for_standalone(
517: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
518: x_txn_source_rec OUT NOCOPY csi_t_ui_pvt.txn_source_rec,
519: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
520: x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
521: x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

Line 519: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

515:
516: PROCEDURE source_for_standalone(
517: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
518: x_txn_source_rec OUT NOCOPY csi_t_ui_pvt.txn_source_rec,
519: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
520: x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
521: x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
522: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
523: x_return_status OUT NOCOPY varchar2)

Line 520: x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,

516: PROCEDURE source_for_standalone(
517: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
518: x_txn_source_rec OUT NOCOPY csi_t_ui_pvt.txn_source_rec,
519: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
520: x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
521: x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
522: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
523: x_return_status OUT NOCOPY varchar2)
524: IS

Line 521: x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

517: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
518: x_txn_source_rec OUT NOCOPY csi_t_ui_pvt.txn_source_rec,
519: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
520: x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
521: x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
522: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
523: x_return_status OUT NOCOPY varchar2)
524: IS
525:

Line 522: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

518: x_txn_source_rec OUT NOCOPY csi_t_ui_pvt.txn_source_rec,
519: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
520: x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
521: x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
522: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
523: x_return_status OUT NOCOPY varchar2)
524: IS
525:
526: l_txn_source_rec csi_t_ui_pvt.txn_source_rec;

Line 527: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

523: x_return_status OUT NOCOPY varchar2)
524: IS
525:
526: l_txn_source_rec csi_t_ui_pvt.txn_source_rec;
527: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
528: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
529: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
530: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
531:

Line 528: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

524: IS
525:
526: l_txn_source_rec csi_t_ui_pvt.txn_source_rec;
527: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
528: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
529: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
530: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
531:
532: l_mo_org_id oe_order_lines_all.org_id%TYPE;

Line 529: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

525:
526: l_txn_source_rec csi_t_ui_pvt.txn_source_rec;
527: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
528: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
529: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
530: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
531:
532: l_mo_org_id oe_order_lines_all.org_id%TYPE;
533: l_serial_control_code mtl_system_items_b.serial_number_control_code%TYPE;

Line 530: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

526: l_txn_source_rec csi_t_ui_pvt.txn_source_rec;
527: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
528: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
529: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
530: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
531:
532: l_mo_org_id oe_order_lines_all.org_id%TYPE;
533: l_serial_control_code mtl_system_items_b.serial_number_control_code%TYPE;
534: l_lot_control_code mtl_system_items_b.lot_control_code%TYPE;

Line 837: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

833:
834: PROCEDURE source_for_params(
835: p_txn_source_param_rec IN csi_t_ui_pvt.txn_source_param_rec,
836: x_txn_source_rec OUT NOCOPY csi_t_ui_pvt.txn_source_rec,
837: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
838: x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
839: x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
840: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
841: x_return_status OUT NOCOPY varchar2)

Line 838: x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,

834: PROCEDURE source_for_params(
835: p_txn_source_param_rec IN csi_t_ui_pvt.txn_source_param_rec,
836: x_txn_source_rec OUT NOCOPY csi_t_ui_pvt.txn_source_rec,
837: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
838: x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
839: x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
840: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
841: x_return_status OUT NOCOPY varchar2)
842: IS

Line 839: x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

835: p_txn_source_param_rec IN csi_t_ui_pvt.txn_source_param_rec,
836: x_txn_source_rec OUT NOCOPY csi_t_ui_pvt.txn_source_rec,
837: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
838: x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
839: x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
840: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
841: x_return_status OUT NOCOPY varchar2)
842: IS
843:

Line 840: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

836: x_txn_source_rec OUT NOCOPY csi_t_ui_pvt.txn_source_rec,
837: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
838: x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
839: x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
840: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
841: x_return_status OUT NOCOPY varchar2)
842: IS
843:
844: l_txn_source_rec csi_t_ui_pvt.txn_source_rec;

Line 845: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

841: x_return_status OUT NOCOPY varchar2)
842: IS
843:
844: l_txn_source_rec csi_t_ui_pvt.txn_source_rec;
845: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
846:
847: l_mo_org_id oe_order_lines_all.org_id%TYPE;
848: l_serial_control_code mtl_system_items_b.serial_number_control_code%TYPE;
849: l_lot_control_code mtl_system_items_b.lot_control_code%TYPE;

Line 992: x_txn_line_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,

988:
989: PROCEDURE get_source_dtls(
990: p_txn_source_param_rec IN csi_t_ui_pvt.txn_source_param_rec,
991: x_txn_source_rec OUT NOCOPY csi_t_ui_pvt.txn_source_rec,
992: x_txn_line_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
993: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
994: x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
995: x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
996: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

Line 993: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

989: PROCEDURE get_source_dtls(
990: p_txn_source_param_rec IN csi_t_ui_pvt.txn_source_param_rec,
991: x_txn_source_rec OUT NOCOPY csi_t_ui_pvt.txn_source_rec,
992: x_txn_line_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
993: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
994: x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
995: x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
996: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
997: x_return_status OUT NOCOPY varchar2)

Line 994: x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,

990: p_txn_source_param_rec IN csi_t_ui_pvt.txn_source_param_rec,
991: x_txn_source_rec OUT NOCOPY csi_t_ui_pvt.txn_source_rec,
992: x_txn_line_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
993: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
994: x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
995: x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
996: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
997: x_return_status OUT NOCOPY varchar2)
998: IS

Line 995: x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

991: x_txn_source_rec OUT NOCOPY csi_t_ui_pvt.txn_source_rec,
992: x_txn_line_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
993: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
994: x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
995: x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
996: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
997: x_return_status OUT NOCOPY varchar2)
998: IS
999:

Line 996: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

992: x_txn_line_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
993: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
994: x_txn_party_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
995: x_txn_pty_acct_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
996: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
997: x_return_status OUT NOCOPY varchar2)
998: IS
999:
1000: l_txn_source_rec csi_t_ui_pvt.txn_source_rec;

Line 1001: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;

997: x_return_status OUT NOCOPY varchar2)
998: IS
999:
1000: l_txn_source_rec csi_t_ui_pvt.txn_source_rec;
1001: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
1002: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1003: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1004: l_txn_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1005: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

Line 1002: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

998: IS
999:
1000: l_txn_source_rec csi_t_ui_pvt.txn_source_rec;
1001: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
1002: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1003: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1004: l_txn_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1005: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1006:

Line 1003: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

999:
1000: l_txn_source_rec csi_t_ui_pvt.txn_source_rec;
1001: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
1002: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1003: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1004: l_txn_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1005: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1006:
1007: l_debug_level number;

Line 1004: l_txn_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

1000: l_txn_source_rec csi_t_ui_pvt.txn_source_rec;
1001: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
1002: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1003: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1004: l_txn_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1005: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1006:
1007: l_debug_level number;
1008: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 1005: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

1001: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
1002: l_txn_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1003: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1004: l_txn_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1005: l_txn_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1006:
1007: l_debug_level number;
1008: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1009:

Line 1461: l_chk_txn_line_rec csi_t_datastructures_grp.txn_line_rec;

1457:
1458: l_om_vld_org_id number;
1459: l_src_txn_type_id number;
1460: l_src_txn_hdr_id number;
1461: l_chk_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
1462:
1463: l_td_found boolean := FALSE;
1464:
1465: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;

Line 1465: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;

1461: l_chk_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
1462:
1463: l_td_found boolean := FALSE;
1464:
1465: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
1466: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
1467: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
1468:
1469: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

Line 1466: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;

1462:
1463: l_td_found boolean := FALSE;
1464:
1465: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
1466: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
1467: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
1468:
1469: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1470: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

Line 1467: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;

1463: l_td_found boolean := FALSE;
1464:
1465: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
1466: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
1467: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
1468:
1469: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1470: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1471: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

Line 1469: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

1465: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
1466: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
1467: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
1468:
1469: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1470: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1471: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1472: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1473: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

Line 1470: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

1466: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
1467: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
1468:
1469: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1470: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1471: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1472: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1473: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1474: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 1471: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

1467: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
1468:
1469: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1470: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1471: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1472: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1473: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1474: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1475: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;

Line 1472: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

1468:
1469: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1470: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1471: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1472: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1473: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1474: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1475: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1476: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;

Line 1473: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

1469: l_g_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1470: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1471: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1472: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1473: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1474: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1475: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1476: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1477: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;

Line 1474: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

1470: l_g_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1471: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1472: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1473: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1474: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1475: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1476: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1477: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1478:

Line 1475: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;

1471: l_g_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1472: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1473: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1474: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1475: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1476: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1477: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1478:
1479: l_c_td_ind binary_integer;

Line 1476: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;

1472: l_g_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1473: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1474: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1475: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1476: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1477: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1478:
1479: l_c_td_ind binary_integer;
1480: l_c_pt_ind binary_integer;

Line 1477: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;

1473: l_g_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1474: l_g_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1475: l_g_csi_ea_tbl csi_t_datastructures_grp.csi_ext_attribs_tbl;
1476: l_g_csi_eav_tbl csi_t_datastructures_grp.csi_ext_attrib_vals_tbl;
1477: l_g_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1478:
1479: l_c_td_ind binary_integer;
1480: l_c_pt_ind binary_integer;
1481: l_c_pa_ind binary_integer;

Line 1486: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

1482: l_c_oa_ind binary_integer;
1483: l_c_ea_ind binary_integer;
1484: l_c_con_ind binary_integer; -- Added for Bug 3648418 (Ref Bug 3605645)
1485:
1486: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1487: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1488: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1489: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1490: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

Line 1487: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

1483: l_c_ea_ind binary_integer;
1484: l_c_con_ind binary_integer; -- Added for Bug 3648418 (Ref Bug 3605645)
1485:
1486: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1487: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1488: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1489: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1490: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1491: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

Line 1488: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

1484: l_c_con_ind binary_integer; -- Added for Bug 3648418 (Ref Bug 3605645)
1485:
1486: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1487: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1488: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1489: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1490: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1491: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1492: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;

Line 1489: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

1485:
1486: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1487: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1488: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1489: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1490: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1491: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1492: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1493:

Line 1490: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

1486: l_line_dtl_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1487: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1488: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1489: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1490: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1491: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1492: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1493:
1494: -- For Bug 3555078

Line 1491: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;

1487: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
1488: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1489: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1490: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1491: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1492: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1493:
1494: -- For Bug 3555078
1495: l_parent_line_rec oe_order_pub.line_rec_type := oe_order_pub.g_miss_line_rec;

Line 1492: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;

1488: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
1489: l_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
1490: l_org_assgn_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
1491: l_ext_attrib_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
1492: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
1493:
1494: -- For Bug 3555078
1495: l_parent_line_rec oe_order_pub.line_rec_type := oe_order_pub.g_miss_line_rec;
1496: l_no_trackable_parent varchar2(1) := 'N';