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 2422: l_init_pty_rec csi_datastructures_pub.party_rec;

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

Line 2427: l_pty_rec csi_datastructures_pub.party_rec;

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

Line 2428: l_pty_tbl csi_datastructures_pub.party_tbl;

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

Line 2430: l_con_pty_tbl csi_datastructures_pub.party_tbl;

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

Line 2432: l_pa_rec csi_datastructures_pub.party_account_rec;

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

Line 2433: l_pa_tbl csi_datastructures_pub.party_account_tbl;

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

Line 2442: x_i_party_rec OUT nocopy csi_datastructures_pub.party_rec)

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

Line 2501: x_i_pa_rec OUT nocopy csi_datastructures_pub.party_account_rec)

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

Line 2563: x_i_pty_tbl OUT nocopy csi_datastructures_pub.party_tbl)

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

Line 2566: l_i_pty_rec csi_datastructures_pub.party_rec;

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

Line 3044: l_instance_rec csi_datastructures_pub.instance_rec;

3040: x_txn_line_dtl_id OUT NOCOPY number,
3041: x_return_status OUT NOCOPY varchar2)
3042: IS
3043:
3044: l_instance_rec csi_datastructures_pub.instance_rec;
3045: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
3046: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
3047: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
3048: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;

Line 3045: l_g_instance_rec csi_datastructures_pub.instance_header_rec;

3041: x_return_status OUT NOCOPY varchar2)
3042: IS
3043:
3044: l_instance_rec csi_datastructures_pub.instance_rec;
3045: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
3046: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
3047: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
3048: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
3049: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 3046: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;

3042: IS
3043:
3044: l_instance_rec csi_datastructures_pub.instance_rec;
3045: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
3046: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
3047: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
3048: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
3049: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
3050: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 3047: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;

3043:
3044: l_instance_rec csi_datastructures_pub.instance_rec;
3045: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
3046: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
3047: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
3048: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
3049: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
3050: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3051: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;

Line 3048: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;

3044: l_instance_rec csi_datastructures_pub.instance_rec;
3045: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
3046: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
3047: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
3048: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
3049: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
3050: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3051: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
3052: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;

Line 3049: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;

3045: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
3046: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
3047: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
3048: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
3049: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
3050: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3051: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
3052: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
3053: l_g_time_stamp date;

Line 3050: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;

3046: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
3047: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
3048: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
3049: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
3050: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3051: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
3052: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
3053: l_g_time_stamp date;
3054:

Line 3051: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;

3047: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
3048: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
3049: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
3050: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3051: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
3052: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
3053: l_g_time_stamp date;
3054:
3055: -- create_txn_line_dtls variables

Line 3052: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;

3048: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
3049: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
3050: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3051: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
3052: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
3053: l_g_time_stamp date;
3054:
3055: -- create_txn_line_dtls variables
3056: l_n_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;

Line 3787: x_cre_systems_rec OUT NOCOPY csi_datastructures_pub.system_rec)

3783: END split_txn_dtls;
3784:
3785: PROCEDURE get_system_tbl(
3786: p_txn_systems_rec IN csi_t_datastructures_grp.txn_system_rec,
3787: x_cre_systems_rec OUT NOCOPY csi_datastructures_pub.system_rec)
3788: IS
3789: BEGIN
3790:
3791: api_log('get_system_tbl');

Line 3833: x_cre_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,

3829:
3830: PROCEDURE get_org_assignment_tbl(
3831: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
3832: p_txn_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,
3833: x_cre_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
3834: x_upd_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
3835: x_return_status OUT NOCOPY VARCHAR2)
3836: IS
3837: l_upd_org NUMBER := 1;

Line 3834: x_upd_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,

3830: PROCEDURE get_org_assignment_tbl(
3831: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
3832: p_txn_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,
3833: x_cre_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
3834: x_upd_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
3835: x_return_status OUT NOCOPY VARCHAR2)
3836: IS
3837: l_upd_org NUMBER := 1;
3838: l_cre_org NUMBER := 1;

Line 3977: x_cre_ext_attrib_val_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,

3973:
3974: PROCEDURE get_ext_attribs_tbl(
3975: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
3976: p_txn_ext_attrib_vals_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
3977: x_cre_ext_attrib_val_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
3978: x_upd_ext_attrib_val_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
3979: x_return_status OUT NOCOPY VARCHAR2)
3980: IS
3981:

Line 3978: x_upd_ext_attrib_val_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,

3974: PROCEDURE get_ext_attribs_tbl(
3975: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
3976: p_txn_ext_attrib_vals_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
3977: x_cre_ext_attrib_val_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
3978: x_upd_ext_attrib_val_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
3979: x_return_status OUT NOCOPY VARCHAR2)
3980: IS
3981:
3982: l_cre_ext NUMBER := 1;

Line 4083: p_trx_rec in csi_datastructures_pub.transaction_rec,

4079: PROCEDURE amend_contracts(
4080: p_relationship_type_code in varchar2,
4081: p_object_instance_id in number,
4082: p_subject_instance_id in number,
4083: p_trx_rec in csi_datastructures_pub.transaction_rec,
4084: x_return_status OUT NOCOPY varchar2)
4085: IS
4086: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4087: l_msg_count number;

Line 4096: l_upd_instance_rec csi_datastructures_pub.instance_rec;

4092: l_process_flag boolean := TRUE;
4093:
4094: /* Fix for ER 2581101 */
4095:
4096: l_upd_instance_rec csi_datastructures_pub.instance_rec;
4097: l_upd_party_tbl csi_datastructures_pub.party_tbl;
4098: l_upd_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4099: l_upd_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4100: l_upd_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 4097: l_upd_party_tbl csi_datastructures_pub.party_tbl;

4093:
4094: /* Fix for ER 2581101 */
4095:
4096: l_upd_instance_rec csi_datastructures_pub.instance_rec;
4097: l_upd_party_tbl csi_datastructures_pub.party_tbl;
4098: l_upd_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4099: l_upd_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4100: l_upd_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4101: l_upd_org_units_tbl csi_datastructures_pub.organization_units_tbl;

Line 4098: l_upd_party_acct_tbl csi_datastructures_pub.party_account_tbl;

4094: /* Fix for ER 2581101 */
4095:
4096: l_upd_instance_rec csi_datastructures_pub.instance_rec;
4097: l_upd_party_tbl csi_datastructures_pub.party_tbl;
4098: l_upd_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4099: l_upd_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4100: l_upd_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4101: l_upd_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4102: l_upd_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

Line 4099: l_upd_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

4095:
4096: l_upd_instance_rec csi_datastructures_pub.instance_rec;
4097: l_upd_party_tbl csi_datastructures_pub.party_tbl;
4098: l_upd_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4099: l_upd_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4100: l_upd_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4101: l_upd_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4102: l_upd_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4103: l_upd_inst_id_lst csi_datastructures_pub.id_tbl;

Line 4100: l_upd_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

4096: l_upd_instance_rec csi_datastructures_pub.instance_rec;
4097: l_upd_party_tbl csi_datastructures_pub.party_tbl;
4098: l_upd_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4099: l_upd_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4100: l_upd_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4101: l_upd_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4102: l_upd_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4103: l_upd_inst_id_lst csi_datastructures_pub.id_tbl;
4104: l_upd_txn_rec csi_datastructures_pub.transaction_rec;

Line 4101: l_upd_org_units_tbl csi_datastructures_pub.organization_units_tbl;

4097: l_upd_party_tbl csi_datastructures_pub.party_tbl;
4098: l_upd_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4099: l_upd_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4100: l_upd_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4101: l_upd_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4102: l_upd_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4103: l_upd_inst_id_lst csi_datastructures_pub.id_tbl;
4104: l_upd_txn_rec csi_datastructures_pub.transaction_rec;
4105: l_non_source_change_owner VARCHAR2(1);

Line 4102: l_upd_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

4098: l_upd_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4099: l_upd_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4100: l_upd_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4101: l_upd_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4102: l_upd_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4103: l_upd_inst_id_lst csi_datastructures_pub.id_tbl;
4104: l_upd_txn_rec csi_datastructures_pub.transaction_rec;
4105: l_non_source_change_owner VARCHAR2(1);
4106: l_non_src_change_owner_code VARCHAR2(1);

Line 4103: l_upd_inst_id_lst csi_datastructures_pub.id_tbl;

4099: l_upd_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4100: l_upd_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4101: l_upd_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4102: l_upd_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4103: l_upd_inst_id_lst csi_datastructures_pub.id_tbl;
4104: l_upd_txn_rec csi_datastructures_pub.transaction_rec;
4105: l_non_source_change_owner VARCHAR2(1);
4106: l_non_src_change_owner_code VARCHAR2(1);
4107: l_location_code VARCHAR2(30);

Line 4104: l_upd_txn_rec csi_datastructures_pub.transaction_rec;

4100: l_upd_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4101: l_upd_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4102: l_upd_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4103: l_upd_inst_id_lst csi_datastructures_pub.id_tbl;
4104: l_upd_txn_rec csi_datastructures_pub.transaction_rec;
4105: l_non_source_change_owner VARCHAR2(1);
4106: l_non_src_change_owner_code VARCHAR2(1);
4107: l_location_code VARCHAR2(30);
4108: l_object_version_number NUMBER;

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

4286: When NO_Data_Found Then
4287: NULL;
4288: END;
4289: */
4290: l_upd_party_tbl(1).party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
4291:
4292: debug('Updating the Instance in Non Source Detail to Internal Party..');
4293: debug('Party Tbl count : '||l_upd_party_tbl.count);
4294:

Line 4338: p_trx_rec IN csi_datastructures_pub.transaction_rec,

4334: /* Added p_trx_rec for ER 2581101 */
4335: PROCEDURE get_ii_relation_tbl(
4336: p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
4337: p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
4338: p_trx_rec IN csi_datastructures_pub.transaction_rec,
4339: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
4340: x_cre_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
4341: x_upd_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
4342: x_return_status OUT NOCOPY VARCHAR2)

Line 4340: x_cre_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,

4336: p_txn_line_detail_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
4337: p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
4338: p_trx_rec IN csi_datastructures_pub.transaction_rec,
4339: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
4340: x_cre_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
4341: x_upd_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
4342: x_return_status OUT NOCOPY VARCHAR2)
4343: IS
4344: l_cre_ii NUMBER := 1;

Line 4341: x_upd_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,

4337: p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
4338: p_trx_rec IN csi_datastructures_pub.transaction_rec,
4339: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
4340: x_cre_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
4341: x_upd_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
4342: x_return_status OUT NOCOPY VARCHAR2)
4343: IS
4344: l_cre_ii NUMBER := 1;
4345: l_upd_ii NUMBER := 1;

Line 4355: l_trx_rec csi_datastructures_pub.transaction_rec;

4351: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4352:
4353: /* Added p_trx_rec for ER 2581101 */
4354: l_nsrc_sub_type_id NUMBER;
4355: l_trx_rec csi_datastructures_pub.transaction_rec;
4356:
4357: --l_srl_code number := null;
4358: l_source_txn_header_id NUMBER ;
4359: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec ;

Line 4378: l_exp_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;

4374: l_txn_dtl_line_found BOOLEAN ;
4375: l_relation_exists BOOLEAN ;
4376: l_tmp_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl ;
4377: x_tmp_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
4378: l_exp_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;
4379: l_exp_instance_id_tbl csi_datastructures_pub.id_tbl;
4380: g_api_name varchar2(80);
4381: l_old_instance_id NUMBER;
4382: l_new_instance_id NUMBER;

Line 4379: l_exp_instance_id_tbl csi_datastructures_pub.id_tbl;

4375: l_relation_exists BOOLEAN ;
4376: l_tmp_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl ;
4377: x_tmp_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl ;
4378: l_exp_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;
4379: l_exp_instance_id_tbl csi_datastructures_pub.id_tbl;
4380: g_api_name varchar2(80);
4381: l_old_instance_id NUMBER;
4382: l_new_instance_id NUMBER;
4383: l_relationship_id NUMBER;

Line 5118: x_upd_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl,

5114:
5115:
5116: PROCEDURE rebuild_tbls(
5117: p_new_instance_id IN NUMBER,
5118: x_upd_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl,
5119: x_upd_party_acct_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,
5120: x_upd_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
5121: x_upd_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
5122: x_cre_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,

Line 5119: x_upd_party_acct_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,

5115:
5116: PROCEDURE rebuild_tbls(
5117: p_new_instance_id IN NUMBER,
5118: x_upd_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl,
5119: x_upd_party_acct_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,
5120: x_upd_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
5121: x_upd_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
5122: x_cre_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
5123: x_cre_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,

Line 5120: x_upd_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,

5116: PROCEDURE rebuild_tbls(
5117: p_new_instance_id IN NUMBER,
5118: x_upd_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl,
5119: x_upd_party_acct_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,
5120: x_upd_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
5121: x_upd_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
5122: x_cre_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
5123: x_cre_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
5124: x_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

Line 5121: x_upd_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,

5117: p_new_instance_id IN NUMBER,
5118: x_upd_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl,
5119: x_upd_party_acct_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,
5120: x_upd_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
5121: x_upd_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
5122: x_cre_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
5123: x_cre_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
5124: x_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
5125: x_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,

Line 5122: x_cre_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,

5118: x_upd_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl,
5119: x_upd_party_acct_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,
5120: x_upd_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
5121: x_upd_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
5122: x_cre_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
5123: x_cre_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
5124: x_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
5125: x_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
5126: x_return_status OUT NOCOPY VARCHAR2)

Line 5123: x_cre_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,

5119: x_upd_party_acct_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,
5120: x_upd_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
5121: x_upd_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
5122: x_cre_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
5123: x_cre_ext_attrib_val_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
5124: x_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
5125: x_txn_line_detail_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_rec,
5126: x_return_status OUT NOCOPY VARCHAR2)
5127: IS

Line 5143: l_upd_ou_tbl csi_datastructures_pub.organization_units_tbl;

5139:
5140: l_ou_found boolean;
5141: l_cou_ind binary_integer := 0;
5142: l_uou_ind binary_integer := 0;
5143: l_upd_ou_tbl csi_datastructures_pub.organization_units_tbl;
5144: l_cre_ou_tbl csi_datastructures_pub.organization_units_tbl;
5145:
5146: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
5147:

Line 5144: l_cre_ou_tbl csi_datastructures_pub.organization_units_tbl;

5140: l_ou_found boolean;
5141: l_cou_ind binary_integer := 0;
5142: l_uou_ind binary_integer := 0;
5143: l_upd_ou_tbl csi_datastructures_pub.organization_units_tbl;
5144: l_cre_ou_tbl csi_datastructures_pub.organization_units_tbl;
5145:
5146: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
5147:
5148: BEGIN

Line 5552: x_upd_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl ,

5548: p_txn_party_detail_tbl IN csi_t_datastructures_grp.txn_party_detail_tbl,
5549: p_txn_pty_acct_dtl_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
5550: x_trx_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec,
5551: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
5552: x_upd_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl ,
5553: x_upd_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
5554: x_cre_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl ,
5555: x_cre_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
5556: x_return_status OUT NOCOPY VARCHAR2)

Line 5553: x_upd_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,

5549: p_txn_pty_acct_dtl_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
5550: x_trx_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec,
5551: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
5552: x_upd_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl ,
5553: x_upd_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
5554: x_cre_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl ,
5555: x_cre_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
5556: x_return_status OUT NOCOPY VARCHAR2)
5557: IS

Line 5554: x_cre_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl ,

5550: x_trx_sub_type_rec IN csi_order_ship_pub.txn_sub_type_rec,
5551: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
5552: x_upd_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl ,
5553: x_upd_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
5554: x_cre_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl ,
5555: x_cre_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
5556: x_return_status OUT NOCOPY VARCHAR2)
5557: IS
5558:

Line 5555: x_cre_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,

5551: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
5552: x_upd_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl ,
5553: x_upd_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
5554: x_cre_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl ,
5555: x_cre_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
5556: x_return_status OUT NOCOPY VARCHAR2)
5557: IS
5558:
5559: l_debug_level NUMBER;

Line 5749: p_instance_header_tbl IN csi_datastructures_pub.instance_header_tbl,

5745: /* table AND we operate on the instance table. */
5746: /* -------------------------------------------------------------------- */
5747:
5748: PROCEDURE make_non_header_tbl(
5749: p_instance_header_tbl IN csi_datastructures_pub.instance_header_tbl,
5750: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
5751: x_return_status OUT NOCOPY varchar2)
5752: IS
5753: l_inst_tbl csi_datastructures_pub.instance_tbl;

Line 5750: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,

5746: /* -------------------------------------------------------------------- */
5747:
5748: PROCEDURE make_non_header_tbl(
5749: p_instance_header_tbl IN csi_datastructures_pub.instance_header_tbl,
5750: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
5751: x_return_status OUT NOCOPY varchar2)
5752: IS
5753: l_inst_tbl csi_datastructures_pub.instance_tbl;
5754: l_inst_hdr_tbl csi_datastructures_pub.instance_header_tbl;

Line 5753: l_inst_tbl csi_datastructures_pub.instance_tbl;

5749: p_instance_header_tbl IN csi_datastructures_pub.instance_header_tbl,
5750: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
5751: x_return_status OUT NOCOPY varchar2)
5752: IS
5753: l_inst_tbl csi_datastructures_pub.instance_tbl;
5754: l_inst_hdr_tbl csi_datastructures_pub.instance_header_tbl;
5755: BEGIN
5756:
5757: x_return_status := fnd_api.g_ret_sts_success;

Line 5754: l_inst_hdr_tbl csi_datastructures_pub.instance_header_tbl;

5750: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
5751: x_return_status OUT NOCOPY varchar2)
5752: IS
5753: l_inst_tbl csi_datastructures_pub.instance_tbl;
5754: l_inst_hdr_tbl csi_datastructures_pub.instance_header_tbl;
5755: BEGIN
5756:
5757: x_return_status := fnd_api.g_ret_sts_success;
5758:

Line 6010: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec ;

6006: WHERE txn_line_detail_id = c_txn_line_detail_id ;
6007:
6008: l_subject_instance_id NUMBER ;
6009: l_object_instance_id NUMBER ;
6010: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec ;
6011: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl ;
6012: x_msg_count NUMBER ;
6013: x_msg_data VARCHAR2 (2000);
6014:

Line 6011: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl ;

6007:
6008: l_subject_instance_id NUMBER ;
6009: l_object_instance_id NUMBER ;
6010: l_relationship_query_rec csi_datastructures_pub.relationship_query_rec ;
6011: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl ;
6012: x_msg_count NUMBER ;
6013: x_msg_data VARCHAR2 (2000);
6014:
6015:

Line 6434: px_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl,

6430: /* transaction details quantities to the instances */
6431: /* -------------------------------------------------------------------- */
6432:
6433: PROCEDURE split_instances(
6434: px_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl,
6435: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
6436: x_return_status OUT NOCOPY varchar2)
6437: IS
6438:

Line 6435: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

6431: /* -------------------------------------------------------------------- */
6432:
6433: PROCEDURE split_instances(
6434: px_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl,
6435: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
6436: x_return_status OUT NOCOPY varchar2)
6437: IS
6438:
6439: l_n_instance_tbl csi_datastructures_pub.instance_tbl;

Line 6439: l_n_instance_tbl csi_datastructures_pub.instance_tbl;

6435: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
6436: x_return_status OUT NOCOPY varchar2)
6437: IS
6438:
6439: l_n_instance_tbl csi_datastructures_pub.instance_tbl;
6440: l_instance_tbl csi_datastructures_pub.instance_tbl;
6441: l_o_instance_tbl csi_datastructures_pub.instance_tbl;
6442: l_o_ind binary_integer;
6443:

Line 6440: l_instance_tbl csi_datastructures_pub.instance_tbl;

6436: x_return_status OUT NOCOPY varchar2)
6437: IS
6438:
6439: l_n_instance_tbl csi_datastructures_pub.instance_tbl;
6440: l_instance_tbl csi_datastructures_pub.instance_tbl;
6441: l_o_instance_tbl csi_datastructures_pub.instance_tbl;
6442: l_o_ind binary_integer;
6443:
6444: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 6441: l_o_instance_tbl csi_datastructures_pub.instance_tbl;

6437: IS
6438:
6439: l_n_instance_tbl csi_datastructures_pub.instance_tbl;
6440: l_instance_tbl csi_datastructures_pub.instance_tbl;
6441: l_o_instance_tbl csi_datastructures_pub.instance_tbl;
6442: l_o_ind binary_integer;
6443:
6444: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
6445: l_msg_data varchar2(512);

Line 6522: px_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl,

6518:
6519: PROCEDURE distribute_instances(
6520: p_quantity_ratio IN number,
6521: p_model_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
6522: px_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl,
6523: px_txn_ps_tbl IN OUT NOCOPY csi_utl_pkg.txn_ps_tbl,
6524: x_return_status OUT NOCOPY varchar2)
6525: IS
6526:

Line 6529: l_instance_tbl csi_datastructures_pub.instance_tbl;

6525: IS
6526:
6527: l_txn_type_id number := csi_order_ship_pub.g_txn_type_id;
6528:
6529: l_instance_tbl csi_datastructures_pub.instance_tbl;
6530:
6531: l_line_dtl_rec csi_t_datastructures_grp.txn_line_detail_rec;
6532: l_pty_dtl_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
6533: l_pty_acct_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

Line 6875: px_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl,

6871:
6872:
6873: PROCEDURE filter_processed_instances(
6874: p_order_line_id IN number,
6875: px_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl,
6876: x_return_status OUT NOCOPY varchar2)
6877: IS
6878: l_instance_tbl csi_datastructures_pub.instance_tbl;
6879: l_i_ind binary_integer := 0;

Line 6878: l_instance_tbl csi_datastructures_pub.instance_tbl;

6874: p_order_line_id IN number,
6875: px_instance_tbl IN OUT NOCOPY csi_datastructures_pub.instance_tbl,
6876: x_return_status OUT NOCOPY varchar2)
6877: IS
6878: l_instance_tbl csi_datastructures_pub.instance_tbl;
6879: l_i_ind binary_integer := 0;
6880: l_processed boolean := FALSE;
6881:
6882: CURSOR tld_cur (p_ord_line_id IN number, p_instance_id IN number) IS

Line 6941: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

6937:
6938: PROCEDURE build_child_relation(
6939: p_order_line_rec IN csi_order_ship_pub.order_line_rec,
6940: p_model_txn_line_rec IN csi_t_datastructures_grp.txn_line_rec,
6941: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
6942: x_return_status OUT NOCOPY varchar2)
6943: IS
6944:
6945: l_inst_query_rec csi_datastructures_pub.instance_query_rec;

Line 6945: l_inst_query_rec csi_datastructures_pub.instance_query_rec;

6941: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
6942: x_return_status OUT NOCOPY varchar2)
6943: IS
6944:
6945: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
6946: l_party_query_rec csi_datastructures_pub.party_query_rec;
6947: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
6948:
6949: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;

Line 6946: l_party_query_rec csi_datastructures_pub.party_query_rec;

6942: x_return_status OUT NOCOPY varchar2)
6943: IS
6944:
6945: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
6946: l_party_query_rec csi_datastructures_pub.party_query_rec;
6947: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
6948:
6949: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
6950: l_instance_tbl csi_datastructures_pub.instance_tbl;

Line 6947: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;

6943: IS
6944:
6945: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
6946: l_party_query_rec csi_datastructures_pub.party_query_rec;
6947: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
6948:
6949: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
6950: l_instance_tbl csi_datastructures_pub.instance_tbl;
6951:

Line 6949: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;

6945: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
6946: l_party_query_rec csi_datastructures_pub.party_query_rec;
6947: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
6948:
6949: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
6950: l_instance_tbl csi_datastructures_pub.instance_tbl;
6951:
6952: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
6953: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;

Line 6950: l_instance_tbl csi_datastructures_pub.instance_tbl;

6946: l_party_query_rec csi_datastructures_pub.party_query_rec;
6947: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
6948:
6949: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
6950: l_instance_tbl csi_datastructures_pub.instance_tbl;
6951:
6952: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
6953: l_txn_line_detail_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
6954:

Line 6988: l_temp_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;

6984: l_order_line_qty number;
6985: l_temp_line_rec oe_order_pub.Line_Rec_Type;
6986: l_next_item_id number := 0;
6987: l_temp_idx number := 0;
6988: l_temp_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
6989: l_temp_index number := 0;
6990:
6991:
6992: BEGIN