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_UTL_PKG dependencies on CSI_DATASTRUCTURES_PUB

Line 547: x_pricing_attb_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,

543: END Check_relation_exists;
544:
545: PROCEDURE Get_pricing_attribs(
546: p_line_id IN NUMBER,
547: x_pricing_attb_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
548: x_return_status OUT NOCOPY VARCHAR2)
549: IS
550: l_index NUMBER := 1;
551: CURSOR Pric_attrib IS

Line 1500: x_int_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;

1496: SELECT internal_party_id
1497: INTO x_int_party_id
1498: FROM csi_install_parameters;
1499: */
1500: x_int_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
1501:
1502: IF x_int_party_id IS NULL THEN
1503: fnd_message.set_name('CSI','CSI_INT_INT_PTY_ID_MISSING');
1504: fnd_msg_pub.add;

Line 2190: p_new_instance_tbl IN csi_datastructures_pub.instance_tbl,

2186:
2187: PROCEDURE build_inst_ii_tbl
2188: ( p_orig_inst_id IN NUMBER,
2189: p_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
2190: p_new_instance_tbl IN csi_datastructures_pub.instance_tbl,
2191: x_return_status OUT NOCOPY VARCHAR2
2192: ) IS
2193:
2194: l_temp_txn_ii_rltns_rec csi_t_datastructures_grp.txn_ii_rltns_rec;

Line 2405: p_owner_pty_rec IN csi_datastructures_pub.party_rec,

2401: p_instance_id IN number,
2402: p_tld_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
2403: p_t_pty_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
2404: p_t_pty_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
2405: p_owner_pty_rec IN csi_datastructures_pub.party_rec,
2406: p_owner_acct_rec IN csi_datastructures_pub.party_account_rec,
2407: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
2408: x_i_pty_tbl OUT nocopy csi_datastructures_pub.party_tbl,
2409: x_i_pty_acct_tbl OUT nocopy csi_datastructures_pub.party_account_tbl,

Line 2406: p_owner_acct_rec IN csi_datastructures_pub.party_account_rec,

2402: p_tld_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
2403: p_t_pty_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
2404: p_t_pty_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
2405: p_owner_pty_rec IN csi_datastructures_pub.party_rec,
2406: p_owner_acct_rec IN csi_datastructures_pub.party_account_rec,
2407: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
2408: x_i_pty_tbl OUT nocopy csi_datastructures_pub.party_tbl,
2409: x_i_pty_acct_tbl OUT nocopy csi_datastructures_pub.party_account_tbl,
2410: x_return_status OUT nocopy varchar2)

Line 2408: x_i_pty_tbl OUT nocopy csi_datastructures_pub.party_tbl,

2404: p_t_pty_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
2405: p_owner_pty_rec IN csi_datastructures_pub.party_rec,
2406: p_owner_acct_rec IN csi_datastructures_pub.party_account_rec,
2407: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
2408: x_i_pty_tbl OUT nocopy csi_datastructures_pub.party_tbl,
2409: x_i_pty_acct_tbl OUT nocopy csi_datastructures_pub.party_account_tbl,
2410: x_return_status OUT nocopy varchar2)
2411: IS
2412:

Line 2409: x_i_pty_acct_tbl OUT nocopy csi_datastructures_pub.party_account_tbl,

2405: p_owner_pty_rec IN csi_datastructures_pub.party_rec,
2406: p_owner_acct_rec IN csi_datastructures_pub.party_account_rec,
2407: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
2408: x_i_pty_tbl OUT nocopy csi_datastructures_pub.party_tbl,
2409: x_i_pty_acct_tbl OUT nocopy csi_datastructures_pub.party_account_tbl,
2410: x_return_status OUT nocopy varchar2)
2411: IS
2412:
2413: l_ship_to_con_entered boolean := FALSE;

Line 2423: l_init_pty_rec csi_datastructures_pub.party_rec;

2419: l_contact_party_id number;
2420: l_con_parent_tbl_index number;
2421: l_con_owner_tbl_index number;
2422:
2423: l_init_pty_rec csi_datastructures_pub.party_rec;
2424:
2425: l_pty_ind binary_integer := 0;
2426: l_pa_ind binary_integer := 0;
2427:

Line 2428: l_pty_rec csi_datastructures_pub.party_rec;

2424:
2425: l_pty_ind binary_integer := 0;
2426: l_pa_ind binary_integer := 0;
2427:
2428: l_pty_rec csi_datastructures_pub.party_rec;
2429: l_pty_tbl csi_datastructures_pub.party_tbl;
2430:
2431: l_own_con_tbl csi_datastructures_pub.party_tbl;
2432: l_con_pty_tbl csi_datastructures_pub.party_tbl;

Line 2429: l_pty_tbl csi_datastructures_pub.party_tbl;

2425: l_pty_ind binary_integer := 0;
2426: l_pa_ind binary_integer := 0;
2427:
2428: l_pty_rec csi_datastructures_pub.party_rec;
2429: l_pty_tbl csi_datastructures_pub.party_tbl;
2430:
2431: l_own_con_tbl csi_datastructures_pub.party_tbl;
2432: l_con_pty_tbl csi_datastructures_pub.party_tbl;
2433:

Line 2431: l_own_con_tbl csi_datastructures_pub.party_tbl;

2427:
2428: l_pty_rec csi_datastructures_pub.party_rec;
2429: l_pty_tbl csi_datastructures_pub.party_tbl;
2430:
2431: l_own_con_tbl csi_datastructures_pub.party_tbl;
2432: l_con_pty_tbl csi_datastructures_pub.party_tbl;
2433:
2434: l_pa_rec csi_datastructures_pub.party_account_rec;
2435: l_pa_tbl csi_datastructures_pub.party_account_tbl;

Line 2432: l_con_pty_tbl csi_datastructures_pub.party_tbl;

2428: l_pty_rec csi_datastructures_pub.party_rec;
2429: l_pty_tbl csi_datastructures_pub.party_tbl;
2430:
2431: l_own_con_tbl csi_datastructures_pub.party_tbl;
2432: l_con_pty_tbl csi_datastructures_pub.party_tbl;
2433:
2434: l_pa_rec csi_datastructures_pub.party_account_rec;
2435: l_pa_tbl csi_datastructures_pub.party_account_tbl;
2436:

Line 2434: l_pa_rec csi_datastructures_pub.party_account_rec;

2430:
2431: l_own_con_tbl csi_datastructures_pub.party_tbl;
2432: l_con_pty_tbl csi_datastructures_pub.party_tbl;
2433:
2434: l_pa_rec csi_datastructures_pub.party_account_rec;
2435: l_pa_tbl csi_datastructures_pub.party_account_tbl;
2436:
2437: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2438: l_msg_count number;

Line 2435: l_pa_tbl csi_datastructures_pub.party_account_tbl;

2431: l_own_con_tbl csi_datastructures_pub.party_tbl;
2432: l_con_pty_tbl csi_datastructures_pub.party_tbl;
2433:
2434: l_pa_rec csi_datastructures_pub.party_account_rec;
2435: l_pa_tbl csi_datastructures_pub.party_account_tbl;
2436:
2437: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2438: l_msg_count number;
2439: l_msg_data varchar2(2000);

Line 2444: x_i_party_rec OUT nocopy csi_datastructures_pub.party_rec)

2440:
2441: PROCEDURE convert_tpty_to_ipty(
2442: p_instance_id IN number,
2443: p_t_party_rec IN csi_t_datastructures_grp.txn_party_detail_rec,
2444: x_i_party_rec OUT nocopy csi_datastructures_pub.party_rec)
2445: IS
2446: l_insance_party_id number;
2447: l_ovn number;
2448: BEGIN

Line 2503: x_i_pa_rec OUT nocopy csi_datastructures_pub.party_account_rec)

2499: p_instance_party_id IN number,
2500: p_parent_tbl_index IN number,
2501: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
2502: p_t_pa_rec IN csi_t_datastructures_grp.txn_pty_acct_detail_rec,
2503: x_i_pa_rec OUT nocopy csi_datastructures_pub.party_account_rec)
2504: IS
2505: BEGIN
2506: x_i_pa_rec.parent_tbl_index := p_parent_tbl_index;
2507: x_i_pa_rec.ip_account_id := p_t_pa_rec.ip_account_id;

Line 2565: x_i_pty_tbl OUT nocopy csi_datastructures_pub.party_tbl)

2561: PROCEDURE get_contact_parties(
2562: p_instance_id IN number,
2563: p_t_party_dtl_id IN number,
2564: p_t_pty_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
2565: x_i_pty_tbl OUT nocopy csi_datastructures_pub.party_tbl)
2566: IS
2567: x_ind binary_integer := 0;
2568: l_i_pty_rec csi_datastructures_pub.party_rec;
2569: BEGIN

Line 2568: l_i_pty_rec csi_datastructures_pub.party_rec;

2564: p_t_pty_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
2565: x_i_pty_tbl OUT nocopy csi_datastructures_pub.party_tbl)
2566: IS
2567: x_ind binary_integer := 0;
2568: l_i_pty_rec csi_datastructures_pub.party_rec;
2569: BEGIN
2570: IF p_t_pty_tbl.COUNT > 0 THEN
2571: FOR l_ind IN p_t_pty_tbl.FIRST .. p_t_pty_tbl.LAST
2572: LOOP

Line 3086: l_instance_rec csi_datastructures_pub.instance_rec;

3082: x_txn_line_dtl_id OUT NOCOPY number,
3083: x_return_status OUT NOCOPY varchar2)
3084: IS
3085:
3086: l_instance_rec csi_datastructures_pub.instance_rec;
3087: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
3088: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
3089: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
3090: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;

Line 3087: l_g_instance_rec csi_datastructures_pub.instance_header_rec;

3083: x_return_status OUT NOCOPY varchar2)
3084: IS
3085:
3086: l_instance_rec csi_datastructures_pub.instance_rec;
3087: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
3088: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
3089: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
3090: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
3091: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 3088: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;

3084: IS
3085:
3086: l_instance_rec csi_datastructures_pub.instance_rec;
3087: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
3088: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
3089: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
3090: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
3091: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
3092: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 3089: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;

3085:
3086: l_instance_rec csi_datastructures_pub.instance_rec;
3087: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
3088: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
3089: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
3090: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
3091: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
3092: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3093: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;

Line 3090: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;

3086: l_instance_rec csi_datastructures_pub.instance_rec;
3087: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
3088: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
3089: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
3090: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
3091: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
3092: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3093: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
3094: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;

Line 3091: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;

3087: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
3088: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
3089: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
3090: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
3091: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
3092: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3093: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
3094: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
3095: l_g_time_stamp date;

Line 3092: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;

3088: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
3089: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
3090: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
3091: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
3092: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3093: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
3094: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
3095: l_g_time_stamp date;
3096:

Line 3093: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;

3089: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
3090: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
3091: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
3092: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3093: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
3094: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
3095: l_g_time_stamp date;
3096:
3097: -- create_txn_line_dtls variables

Line 3094: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;

3090: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
3091: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
3092: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3093: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
3094: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
3095: l_g_time_stamp date;
3096:
3097: -- create_txn_line_dtls variables
3098: l_n_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;

Line 3829: x_cre_systems_rec OUT NOCOPY csi_datastructures_pub.system_rec)

3825: END split_txn_dtls;
3826:
3827: PROCEDURE get_system_tbl(
3828: p_txn_systems_rec IN csi_t_datastructures_grp.txn_system_rec,
3829: x_cre_systems_rec OUT NOCOPY csi_datastructures_pub.system_rec)
3830: IS
3831: BEGIN
3832:
3833: api_log('get_system_tbl');

Line 3875: x_cre_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,

3871:
3872: PROCEDURE get_org_assignment_tbl(
3873: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
3874: p_txn_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,
3875: x_cre_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
3876: x_upd_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
3877: x_return_status OUT NOCOPY VARCHAR2)
3878: IS
3879: l_upd_org NUMBER := 1;

Line 3876: x_upd_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,

3872: PROCEDURE get_org_assignment_tbl(
3873: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
3874: p_txn_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,
3875: x_cre_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
3876: x_upd_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
3877: x_return_status OUT NOCOPY VARCHAR2)
3878: IS
3879: l_upd_org NUMBER := 1;
3880: l_cre_org NUMBER := 1;

Line 4019: x_cre_ext_attrib_val_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,

4015:
4016: PROCEDURE get_ext_attribs_tbl(
4017: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
4018: p_txn_ext_attrib_vals_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
4019: x_cre_ext_attrib_val_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
4020: x_upd_ext_attrib_val_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
4021: x_return_status OUT NOCOPY VARCHAR2)
4022: IS
4023:

Line 4020: x_upd_ext_attrib_val_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,

4016: PROCEDURE get_ext_attribs_tbl(
4017: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
4018: p_txn_ext_attrib_vals_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
4019: x_cre_ext_attrib_val_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
4020: x_upd_ext_attrib_val_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
4021: x_return_status OUT NOCOPY VARCHAR2)
4022: IS
4023:
4024: l_cre_ext NUMBER := 1;

Line 4125: p_trx_rec in csi_datastructures_pub.transaction_rec,

4121: PROCEDURE amend_contracts(
4122: p_relationship_type_code in varchar2,
4123: p_object_instance_id in number,
4124: p_subject_instance_id in number,
4125: p_trx_rec in csi_datastructures_pub.transaction_rec,
4126: x_return_status OUT NOCOPY varchar2)
4127: IS
4128: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4129: l_msg_count number;

Line 4138: l_upd_instance_rec csi_datastructures_pub.instance_rec;

4134: l_process_flag boolean := TRUE;
4135:
4136: /* Fix for ER 2581101 */
4137:
4138: l_upd_instance_rec csi_datastructures_pub.instance_rec;
4139: l_upd_party_tbl csi_datastructures_pub.party_tbl;
4140: l_upd_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4141: l_upd_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4142: l_upd_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 4139: l_upd_party_tbl csi_datastructures_pub.party_tbl;

4135:
4136: /* Fix for ER 2581101 */
4137:
4138: l_upd_instance_rec csi_datastructures_pub.instance_rec;
4139: l_upd_party_tbl csi_datastructures_pub.party_tbl;
4140: l_upd_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4141: l_upd_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4142: l_upd_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4143: l_upd_org_units_tbl csi_datastructures_pub.organization_units_tbl;

Line 4140: l_upd_party_acct_tbl csi_datastructures_pub.party_account_tbl;

4136: /* Fix for ER 2581101 */
4137:
4138: l_upd_instance_rec csi_datastructures_pub.instance_rec;
4139: l_upd_party_tbl csi_datastructures_pub.party_tbl;
4140: l_upd_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4141: l_upd_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4142: l_upd_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4143: l_upd_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4144: l_upd_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

Line 4141: l_upd_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

4137:
4138: l_upd_instance_rec csi_datastructures_pub.instance_rec;
4139: l_upd_party_tbl csi_datastructures_pub.party_tbl;
4140: l_upd_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4141: l_upd_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4142: l_upd_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4143: l_upd_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4144: l_upd_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4145: l_upd_inst_id_lst csi_datastructures_pub.id_tbl;

Line 4142: l_upd_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

4138: l_upd_instance_rec csi_datastructures_pub.instance_rec;
4139: l_upd_party_tbl csi_datastructures_pub.party_tbl;
4140: l_upd_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4141: l_upd_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4142: l_upd_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4143: l_upd_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4144: l_upd_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4145: l_upd_inst_id_lst csi_datastructures_pub.id_tbl;
4146: l_upd_txn_rec csi_datastructures_pub.transaction_rec;

Line 4143: l_upd_org_units_tbl csi_datastructures_pub.organization_units_tbl;

4139: l_upd_party_tbl csi_datastructures_pub.party_tbl;
4140: l_upd_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4141: l_upd_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4142: l_upd_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4143: l_upd_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4144: l_upd_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4145: l_upd_inst_id_lst csi_datastructures_pub.id_tbl;
4146: l_upd_txn_rec csi_datastructures_pub.transaction_rec;
4147: l_non_source_change_owner VARCHAR2(1);

Line 4144: l_upd_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

4140: l_upd_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4141: l_upd_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4142: l_upd_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4143: l_upd_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4144: l_upd_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4145: l_upd_inst_id_lst csi_datastructures_pub.id_tbl;
4146: l_upd_txn_rec csi_datastructures_pub.transaction_rec;
4147: l_non_source_change_owner VARCHAR2(1);
4148: l_non_src_change_owner_code VARCHAR2(1);

Line 4145: l_upd_inst_id_lst csi_datastructures_pub.id_tbl;

4141: l_upd_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4142: l_upd_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4143: l_upd_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4144: l_upd_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4145: l_upd_inst_id_lst csi_datastructures_pub.id_tbl;
4146: l_upd_txn_rec csi_datastructures_pub.transaction_rec;
4147: l_non_source_change_owner VARCHAR2(1);
4148: l_non_src_change_owner_code VARCHAR2(1);
4149: l_location_code VARCHAR2(30);

Line 4146: l_upd_txn_rec csi_datastructures_pub.transaction_rec;

4142: l_upd_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4143: l_upd_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4144: l_upd_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4145: l_upd_inst_id_lst csi_datastructures_pub.id_tbl;
4146: l_upd_txn_rec csi_datastructures_pub.transaction_rec;
4147: l_non_source_change_owner VARCHAR2(1);
4148: l_non_src_change_owner_code VARCHAR2(1);
4149: l_location_code VARCHAR2(30);
4150: l_object_version_number NUMBER;

Line 4332: l_upd_party_tbl(1).party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;

4328: When NO_Data_Found Then
4329: NULL;
4330: END;
4331: */
4332: l_upd_party_tbl(1).party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
4333:
4334: debug('Updating the Instance in Non Source Detail to Internal Party..');
4335: debug('Party Tbl count : '||l_upd_party_tbl.count);
4336:

Line 4380: p_trx_rec IN csi_datastructures_pub.transaction_rec,

4376: /* Added p_trx_rec for ER 2581101 */
4377: PROCEDURE get_ii_relation_tbl(
4378: p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
4379: p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
4380: p_trx_rec IN csi_datastructures_pub.transaction_rec,
4381: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
4382: x_cre_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
4383: x_upd_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
4384: x_return_status OUT NOCOPY VARCHAR2)

Line 4382: x_cre_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,

4378: p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
4379: p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
4380: p_trx_rec IN csi_datastructures_pub.transaction_rec,
4381: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
4382: x_cre_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
4383: x_upd_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
4384: x_return_status OUT NOCOPY VARCHAR2)
4385: IS
4386: l_cre_ii NUMBER := 1;

Line 4383: x_upd_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,

4379: p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
4380: p_trx_rec IN csi_datastructures_pub.transaction_rec,
4381: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
4382: x_cre_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
4383: x_upd_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
4384: x_return_status OUT NOCOPY VARCHAR2)
4385: IS
4386: l_cre_ii NUMBER := 1;
4387: l_upd_ii NUMBER := 1;

Line 4397: l_trx_rec csi_datastructures_pub.transaction_rec;

4393: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4394:
4395: /* Added p_trx_rec for ER 2581101 */
4396: l_nsrc_sub_type_id NUMBER;
4397: l_trx_rec csi_datastructures_pub.transaction_rec;
4398:
4399: --l_srl_code number := null;
4400: l_source_txn_header_id NUMBER ;
4401: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec ;

Line 4420: l_exp_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;

4416: l_txn_dtl_line_found BOOLEAN ;
4417: l_relation_exists BOOLEAN ;
4418: l_tmp_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl ;
4419: x_tmp_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
4420: l_exp_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;
4421: l_exp_instance_id_tbl csi_datastructures_pub.id_tbl;
4422: g_api_name varchar2(80);
4423: l_old_instance_id NUMBER;
4424: l_new_instance_id NUMBER;

Line 4421: l_exp_instance_id_tbl csi_datastructures_pub.id_tbl;

4417: l_relation_exists BOOLEAN ;
4418: l_tmp_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl ;
4419: x_tmp_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
4420: l_exp_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;
4421: l_exp_instance_id_tbl csi_datastructures_pub.id_tbl;
4422: g_api_name varchar2(80);
4423: l_old_instance_id NUMBER;
4424: l_new_instance_id NUMBER;
4425: l_relationship_id NUMBER;

Line 5162: x_upd_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl,

5158:
5159:
5160: PROCEDURE rebuild_tbls(
5161: p_new_instance_id IN NUMBER,
5162: x_upd_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl,
5163: x_upd_party_acct_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,
5164: x_upd_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
5165: x_upd_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
5166: x_cre_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,

Line 5163: x_upd_party_acct_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,

5159:
5160: PROCEDURE rebuild_tbls(
5161: p_new_instance_id IN NUMBER,
5162: x_upd_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl,
5163: x_upd_party_acct_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,
5164: x_upd_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
5165: x_upd_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
5166: x_cre_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
5167: x_cre_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,

Line 5164: x_upd_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,

5160: PROCEDURE rebuild_tbls(
5161: p_new_instance_id IN NUMBER,
5162: x_upd_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl,
5163: x_upd_party_acct_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,
5164: x_upd_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
5165: x_upd_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
5166: x_cre_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
5167: x_cre_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
5168: x_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

Line 5165: x_upd_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,

5161: p_new_instance_id IN NUMBER,
5162: x_upd_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl,
5163: x_upd_party_acct_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,
5164: x_upd_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
5165: x_upd_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
5166: x_cre_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
5167: x_cre_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
5168: x_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
5169: x_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,

Line 5166: x_cre_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,

5162: x_upd_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl,
5163: x_upd_party_acct_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,
5164: x_upd_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
5165: x_upd_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
5166: x_cre_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
5167: x_cre_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
5168: x_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
5169: x_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
5170: x_return_status OUT NOCOPY VARCHAR2)

Line 5167: x_cre_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,

5163: x_upd_party_acct_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,
5164: x_upd_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
5165: x_upd_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
5166: x_cre_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
5167: x_cre_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
5168: x_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
5169: x_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
5170: x_return_status OUT NOCOPY VARCHAR2)
5171: IS

Line 5189: l_upd_ou_tbl csi_datastructures_pub.organization_units_tbl;

5185: l_update_ou_found boolean; -- added for 8309196
5186: l_ou_found boolean;
5187: l_cou_ind binary_integer := 0;
5188: l_uou_ind binary_integer := 0;
5189: l_upd_ou_tbl csi_datastructures_pub.organization_units_tbl;
5190: l_cre_ou_tbl csi_datastructures_pub.organization_units_tbl;
5191:
5192: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
5193:

Line 5190: l_cre_ou_tbl csi_datastructures_pub.organization_units_tbl;

5186: l_ou_found boolean;
5187: l_cou_ind binary_integer := 0;
5188: l_uou_ind binary_integer := 0;
5189: l_upd_ou_tbl csi_datastructures_pub.organization_units_tbl;
5190: l_cre_ou_tbl csi_datastructures_pub.organization_units_tbl;
5191:
5192: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
5193:
5194: BEGIN

Line 5631: x_upd_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl ,

5627: p_txn_party_detail_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
5628: p_txn_pty_acct_dtl_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
5629: x_trx_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec,
5630: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
5631: x_upd_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl ,
5632: x_upd_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
5633: x_cre_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl ,
5634: x_cre_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
5635: x_return_status OUT NOCOPY VARCHAR2)

Line 5632: x_upd_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,

5628: p_txn_pty_acct_dtl_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
5629: x_trx_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec,
5630: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
5631: x_upd_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl ,
5632: x_upd_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
5633: x_cre_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl ,
5634: x_cre_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
5635: x_return_status OUT NOCOPY VARCHAR2)
5636: IS

Line 5633: x_cre_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl ,

5629: x_trx_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec,
5630: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
5631: x_upd_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl ,
5632: x_upd_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
5633: x_cre_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl ,
5634: x_cre_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
5635: x_return_status OUT NOCOPY VARCHAR2)
5636: IS
5637:

Line 5634: x_cre_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,

5630: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
5631: x_upd_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl ,
5632: x_upd_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
5633: x_cre_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl ,
5634: x_cre_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
5635: x_return_status OUT NOCOPY VARCHAR2)
5636: IS
5637:
5638: l_debug_level NUMBER;

Line 5828: p_instance_header_tbl IN csi_datastructures_pub.instance_header_tbl,

5824: /* table AND we operate on the instance table. */
5825: /* -------------------------------------------------------------------- */
5826:
5827: PROCEDURE make_non_header_tbl(
5828: p_instance_header_tbl IN csi_datastructures_pub.instance_header_tbl,
5829: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
5830: x_return_status OUT NOCOPY varchar2)
5831: IS
5832: l_inst_tbl csi_datastructures_pub.instance_tbl;

Line 5829: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,

5825: /* -------------------------------------------------------------------- */
5826:
5827: PROCEDURE make_non_header_tbl(
5828: p_instance_header_tbl IN csi_datastructures_pub.instance_header_tbl,
5829: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
5830: x_return_status OUT NOCOPY varchar2)
5831: IS
5832: l_inst_tbl csi_datastructures_pub.instance_tbl;
5833: l_inst_hdr_tbl csi_datastructures_pub.instance_header_tbl;

Line 5832: l_inst_tbl csi_datastructures_pub.instance_tbl;

5828: p_instance_header_tbl IN csi_datastructures_pub.instance_header_tbl,
5829: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
5830: x_return_status OUT NOCOPY varchar2)
5831: IS
5832: l_inst_tbl csi_datastructures_pub.instance_tbl;
5833: l_inst_hdr_tbl csi_datastructures_pub.instance_header_tbl;
5834: BEGIN
5835:
5836: x_return_status := fnd_api.g_ret_sts_success;

Line 5833: l_inst_hdr_tbl csi_datastructures_pub.instance_header_tbl;

5829: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
5830: x_return_status OUT NOCOPY varchar2)
5831: IS
5832: l_inst_tbl csi_datastructures_pub.instance_tbl;
5833: l_inst_hdr_tbl csi_datastructures_pub.instance_header_tbl;
5834: BEGIN
5835:
5836: x_return_status := fnd_api.g_ret_sts_success;
5837:

Line 6089: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec ;

6085: WHERE txn_line_detail_id = c_txn_line_detail_id ;
6086:
6087: l_subject_instance_id NUMBER ;
6088: l_object_instance_id NUMBER ;
6089: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec ;
6090: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl ;
6091: x_msg_count NUMBER ;
6092: x_msg_data VARCHAR2 (2000);
6093:

Line 6090: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl ;

6086:
6087: l_subject_instance_id NUMBER ;
6088: l_object_instance_id NUMBER ;
6089: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec ;
6090: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl ;
6091: x_msg_count NUMBER ;
6092: x_msg_data VARCHAR2 (2000);
6093:
6094:

Line 6513: px_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl,

6509: /* transaction details quantities to the instances */
6510: /* -------------------------------------------------------------------- */
6511:
6512: PROCEDURE split_instances(
6513: px_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl,
6514: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
6515: x_return_status OUT NOCOPY varchar2)
6516: IS
6517:

Line 6514: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

6510: /* -------------------------------------------------------------------- */
6511:
6512: PROCEDURE split_instances(
6513: px_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl,
6514: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
6515: x_return_status OUT NOCOPY varchar2)
6516: IS
6517:
6518: l_n_instance_tbl csi_datastructures_pub.instance_tbl;

Line 6518: l_n_instance_tbl csi_datastructures_pub.instance_tbl;

6514: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
6515: x_return_status OUT NOCOPY varchar2)
6516: IS
6517:
6518: l_n_instance_tbl csi_datastructures_pub.instance_tbl;
6519: l_instance_tbl csi_datastructures_pub.instance_tbl;
6520: l_o_instance_tbl csi_datastructures_pub.instance_tbl;
6521: l_o_ind binary_integer;
6522:

Line 6519: l_instance_tbl csi_datastructures_pub.instance_tbl;

6515: x_return_status OUT NOCOPY varchar2)
6516: IS
6517:
6518: l_n_instance_tbl csi_datastructures_pub.instance_tbl;
6519: l_instance_tbl csi_datastructures_pub.instance_tbl;
6520: l_o_instance_tbl csi_datastructures_pub.instance_tbl;
6521: l_o_ind binary_integer;
6522:
6523: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 6520: l_o_instance_tbl csi_datastructures_pub.instance_tbl;

6516: IS
6517:
6518: l_n_instance_tbl csi_datastructures_pub.instance_tbl;
6519: l_instance_tbl csi_datastructures_pub.instance_tbl;
6520: l_o_instance_tbl csi_datastructures_pub.instance_tbl;
6521: l_o_ind binary_integer;
6522:
6523: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
6524: l_msg_data varchar2(512);

Line 6602: px_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl,

6598: PROCEDURE distribute_instances(
6599: p_quantity_ratio IN number,
6600: p_model_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
6601: p_split_flag IN varchar2,--bug 14534435
6602: px_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl,
6603: px_txn_ps_tbl IN OUT NOCOPY csi_utl_pkg.txn_ps_tbl,
6604: x_return_status OUT NOCOPY varchar2)
6605: IS
6606:

Line 6609: l_instance_tbl csi_datastructures_pub.instance_tbl;

6605: IS
6606:
6607: l_txn_type_id number := csi_order_ship_pub.g_txn_type_id;
6608:
6609: l_instance_tbl csi_datastructures_pub.instance_tbl;
6610:
6611: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
6612: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6613: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

Line 6963: px_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl,

6959:
6960:
6961: PROCEDURE filter_processed_instances(
6962: p_order_line_id IN number,
6963: px_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl,
6964: x_return_status OUT NOCOPY varchar2)
6965: IS
6966: l_instance_tbl csi_datastructures_pub.instance_tbl;
6967: l_i_ind binary_integer := 0;

Line 6966: l_instance_tbl csi_datastructures_pub.instance_tbl;

6962: p_order_line_id IN number,
6963: px_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl,
6964: x_return_status OUT NOCOPY varchar2)
6965: IS
6966: l_instance_tbl csi_datastructures_pub.instance_tbl;
6967: l_i_ind binary_integer := 0;
6968: l_processed boolean := FALSE;
6969:
6970: CURSOR tld_cur (p_ord_line_id IN number, p_instance_id IN number) IS

Line 7029: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

7025:
7026: PROCEDURE build_child_relation(
7027: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
7028: p_model_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
7029: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
7030: x_return_status OUT NOCOPY varchar2)
7031: IS
7032:
7033: l_inst_query_rec csi_datastructures_pub.instance_query_rec;

Line 7033: l_inst_query_rec csi_datastructures_pub.instance_query_rec;

7029: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
7030: x_return_status OUT NOCOPY varchar2)
7031: IS
7032:
7033: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
7034: l_party_query_rec csi_datastructures_pub.party_query_rec;
7035: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
7036:
7037: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;

Line 7034: l_party_query_rec csi_datastructures_pub.party_query_rec;

7030: x_return_status OUT NOCOPY varchar2)
7031: IS
7032:
7033: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
7034: l_party_query_rec csi_datastructures_pub.party_query_rec;
7035: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
7036:
7037: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
7038: l_instance_tbl csi_datastructures_pub.instance_tbl;

Line 7035: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;

7031: IS
7032:
7033: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
7034: l_party_query_rec csi_datastructures_pub.party_query_rec;
7035: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
7036:
7037: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
7038: l_instance_tbl csi_datastructures_pub.instance_tbl;
7039:

Line 7037: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;

7033: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
7034: l_party_query_rec csi_datastructures_pub.party_query_rec;
7035: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
7036:
7037: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
7038: l_instance_tbl csi_datastructures_pub.instance_tbl;
7039:
7040: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
7041: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;

Line 7038: l_instance_tbl csi_datastructures_pub.instance_tbl;

7034: l_party_query_rec csi_datastructures_pub.party_query_rec;
7035: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
7036:
7037: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
7038: l_instance_tbl csi_datastructures_pub.instance_tbl;
7039:
7040: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
7041: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
7042:

Line 7076: l_temp_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;

7072: l_order_line_qty number;
7073: l_temp_line_rec oe_order_pub.Line_Rec_Type;
7074: l_next_item_id number := 0;
7075: l_temp_idx number := 0;
7076: l_temp_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
7077: l_temp_index number := 0;
7078:
7079:
7080: BEGIN