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

Line 759: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,

755: --
756: --
757: PROCEDURE get_pricing_attributes(
758: p_line_id IN number,
759: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
760: x_return_status OUT NOCOPY varchar2)
761: IS
762:
763: l_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 763: l_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;

759: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
760: x_return_status OUT NOCOPY varchar2)
761: IS
762:
763: l_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
764: l_ind binary_integer := 0;
765:
766: CURSOR price_cur IS
767: SELECT pricing_context,

Line 1002: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,

998: p_split_loop IN number,
999: p_transaction_type_id IN number,
1000: p_source_header_rec IN source_header_rec,
1001: p_source_line_rec IN source_line_rec,
1002: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
1003: x_txn_line_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
1004: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1005: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1006: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

Line 1008: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,

1004: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1005: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1006: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1007: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
1008: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
1009: x_return_status OUT NOCOPY varchar2)
1010: IS
1011:
1012: l_default_sub_type_id number;

Line 1250: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,

1246: p_source_table IN varchar2,
1247: p_source_id IN number,
1248: p_source_header_rec IN source_header_rec,
1249: p_source_line_rec IN source_line_rec,
1250: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
1251: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec, --bug 5194812, changed this param to IN OUT
1252: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1253: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1254: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

Line 1256: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,

1252: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1253: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1254: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1255: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
1256: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
1257: x_return_status OUT NOCOPY varchar2)
1258: IS
1259:
1260: l_default_sub_type_id number;

Line 1502: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,

1498: p_source_table IN varchar2,
1499: p_source_id IN number,
1500: p_source_header_rec IN source_header_rec,
1501: p_source_line_rec IN source_line_rec,
1502: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
1503: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
1504: px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1505: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1506: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

Line 1508: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,

1504: px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1505: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1506: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1507: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
1508: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
1509: x_return_status OUT NOCOPY varchar2)
1510: IS
1511: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1512: l_pty_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

Line 2419: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,

2415: --
2416: --
2417: PROCEDURE get_instances_for_source(
2418: p_source_line_rec IN source_line_rec,
2419: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
2420: x_return_status OUT NOCOPY varchar2)
2421: IS
2422:
2423: l_inst_query_rec csi_datastructures_pub.instance_query_rec;

Line 2423: l_inst_query_rec csi_datastructures_pub.instance_query_rec;

2419: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
2420: x_return_status OUT NOCOPY varchar2)
2421: IS
2422:
2423: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
2424: l_party_query_rec csi_datastructures_pub.party_query_rec;
2425: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
2426:
2427: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;

Line 2424: l_party_query_rec csi_datastructures_pub.party_query_rec;

2420: x_return_status OUT NOCOPY varchar2)
2421: IS
2422:
2423: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
2424: l_party_query_rec csi_datastructures_pub.party_query_rec;
2425: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
2426:
2427: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
2428: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 2425: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;

2421: IS
2422:
2423: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
2424: l_party_query_rec csi_datastructures_pub.party_query_rec;
2425: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
2426:
2427: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
2428: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2429: l_msg_count number;

Line 2427: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;

2423: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
2424: l_party_query_rec csi_datastructures_pub.party_query_rec;
2425: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
2426:
2427: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
2428: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2429: l_msg_count number;
2430: l_msg_data varchar2(2000);
2431:

Line 2496: l_parent_instance_tbl csi_datastructures_pub.instance_tbl;

2492:
2493: l_parent_found boolean := FALSE;
2494: l_parent_line_rec source_line_rec;
2495:
2496: l_parent_instance_tbl csi_datastructures_pub.instance_tbl;
2497: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2498:
2499: BEGIN
2500:

Line 3239: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,

3235: PROCEDURE build_instance_set(
3236: p_index IN binary_integer,
3237: p_source_line_rec IN csi_interface_pkg.source_line_rec,
3238: p_item_attrib_rec IN item_attributes_rec,
3239: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
3240: p_txn_line_dtl_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
3241: p_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
3242: p_txn_party_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
3243: p_txn_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,

Line 3245: px_pricing_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,

3241: p_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
3242: p_txn_party_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
3243: p_txn_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,
3244: p_txn_eav_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
3245: px_pricing_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
3246: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,
3247: x_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl,
3248: x_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
3249: x_eav_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,

Line 3246: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,

3242: p_txn_party_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
3243: p_txn_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,
3244: p_txn_eav_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
3245: px_pricing_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
3246: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,
3247: x_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl,
3248: x_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
3249: x_eav_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
3250: x_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,

Line 3247: x_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl,

3243: p_txn_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,
3244: p_txn_eav_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
3245: px_pricing_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
3246: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,
3247: x_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl,
3248: x_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
3249: x_eav_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
3250: x_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
3251: x_return_status OUT NOCOPY varchar2)

Line 3248: x_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,

3244: p_txn_eav_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
3245: px_pricing_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
3246: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,
3247: x_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl,
3248: x_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
3249: x_eav_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
3250: x_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
3251: x_return_status OUT NOCOPY varchar2)
3252: IS

Line 3249: x_eav_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,

3245: px_pricing_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
3246: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,
3247: x_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl,
3248: x_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
3249: x_eav_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
3250: x_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
3251: x_return_status OUT NOCOPY varchar2)
3252: IS
3253: l_i_rec csi_datastructures_pub.instance_rec;

Line 3250: x_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,

3246: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,
3247: x_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl,
3248: x_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
3249: x_eav_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
3250: x_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
3251: x_return_status OUT NOCOPY varchar2)
3252: IS
3253: l_i_rec csi_datastructures_pub.instance_rec;
3254: l_p_tbl csi_datastructures_pub.party_tbl;

Line 3253: l_i_rec csi_datastructures_pub.instance_rec;

3249: x_eav_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
3250: x_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
3251: x_return_status OUT NOCOPY varchar2)
3252: IS
3253: l_i_rec csi_datastructures_pub.instance_rec;
3254: l_p_tbl csi_datastructures_pub.party_tbl;
3255: l_pa_tbl csi_datastructures_pub.party_account_tbl;
3256: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3257: l_ou_tbl csi_datastructures_pub.organization_units_tbl;

Line 3254: l_p_tbl csi_datastructures_pub.party_tbl;

3250: x_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
3251: x_return_status OUT NOCOPY varchar2)
3252: IS
3253: l_i_rec csi_datastructures_pub.instance_rec;
3254: l_p_tbl csi_datastructures_pub.party_tbl;
3255: l_pa_tbl csi_datastructures_pub.party_account_tbl;
3256: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3257: l_ou_tbl csi_datastructures_pub.organization_units_tbl;
3258:

Line 3255: l_pa_tbl csi_datastructures_pub.party_account_tbl;

3251: x_return_status OUT NOCOPY varchar2)
3252: IS
3253: l_i_rec csi_datastructures_pub.instance_rec;
3254: l_p_tbl csi_datastructures_pub.party_tbl;
3255: l_pa_tbl csi_datastructures_pub.party_account_tbl;
3256: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3257: l_ou_tbl csi_datastructures_pub.organization_units_tbl;
3258:
3259: l_instance_key csi_utility_grp.config_instance_key;

Line 3256: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;

3252: IS
3253: l_i_rec csi_datastructures_pub.instance_rec;
3254: l_p_tbl csi_datastructures_pub.party_tbl;
3255: l_pa_tbl csi_datastructures_pub.party_account_tbl;
3256: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3257: l_ou_tbl csi_datastructures_pub.organization_units_tbl;
3258:
3259: l_instance_key csi_utility_grp.config_instance_key;
3260:

Line 3257: l_ou_tbl csi_datastructures_pub.organization_units_tbl;

3253: l_i_rec csi_datastructures_pub.instance_rec;
3254: l_p_tbl csi_datastructures_pub.party_tbl;
3255: l_pa_tbl csi_datastructures_pub.party_account_tbl;
3256: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3257: l_ou_tbl csi_datastructures_pub.organization_units_tbl;
3258:
3259: l_instance_key csi_utility_grp.config_instance_key;
3260:
3261: p_ind binary_integer := 0;

Line 3694: p_instance_rec IN csi_datastructures_pub.instance_rec,

3690:
3691: PROCEDURE sub_type_specific_vldns(
3692: p_source_flag IN varchar2,
3693: p_sub_type_rec IN csi_txn_sub_types%rowtype,
3694: p_instance_rec IN csi_datastructures_pub.instance_rec,
3695: p_party_tbl IN csi_datastructures_pub.party_tbl,
3696: p_party_acct_tbl IN csi_datastructures_pub.party_account_tbl,
3697: p_org_units_tbl IN csi_datastructures_pub.organization_units_tbl,
3698: p_eav_tbl IN csi_datastructures_pub.extend_attrib_values_tbl,

Line 3695: p_party_tbl IN csi_datastructures_pub.party_tbl,

3691: PROCEDURE sub_type_specific_vldns(
3692: p_source_flag IN varchar2,
3693: p_sub_type_rec IN csi_txn_sub_types%rowtype,
3694: p_instance_rec IN csi_datastructures_pub.instance_rec,
3695: p_party_tbl IN csi_datastructures_pub.party_tbl,
3696: p_party_acct_tbl IN csi_datastructures_pub.party_account_tbl,
3697: p_org_units_tbl IN csi_datastructures_pub.organization_units_tbl,
3698: p_eav_tbl IN csi_datastructures_pub.extend_attrib_values_tbl,
3699: p_pricing_tbl IN csi_datastructures_pub.pricing_attribs_tbl,

Line 3696: p_party_acct_tbl IN csi_datastructures_pub.party_account_tbl,

3692: p_source_flag IN varchar2,
3693: p_sub_type_rec IN csi_txn_sub_types%rowtype,
3694: p_instance_rec IN csi_datastructures_pub.instance_rec,
3695: p_party_tbl IN csi_datastructures_pub.party_tbl,
3696: p_party_acct_tbl IN csi_datastructures_pub.party_account_tbl,
3697: p_org_units_tbl IN csi_datastructures_pub.organization_units_tbl,
3698: p_eav_tbl IN csi_datastructures_pub.extend_attrib_values_tbl,
3699: p_pricing_tbl IN csi_datastructures_pub.pricing_attribs_tbl,
3700: x_return_status OUT NOCOPY varchar2)

Line 3697: p_org_units_tbl IN csi_datastructures_pub.organization_units_tbl,

3693: p_sub_type_rec IN csi_txn_sub_types%rowtype,
3694: p_instance_rec IN csi_datastructures_pub.instance_rec,
3695: p_party_tbl IN csi_datastructures_pub.party_tbl,
3696: p_party_acct_tbl IN csi_datastructures_pub.party_account_tbl,
3697: p_org_units_tbl IN csi_datastructures_pub.organization_units_tbl,
3698: p_eav_tbl IN csi_datastructures_pub.extend_attrib_values_tbl,
3699: p_pricing_tbl IN csi_datastructures_pub.pricing_attribs_tbl,
3700: x_return_status OUT NOCOPY varchar2)
3701: IS

Line 3698: p_eav_tbl IN csi_datastructures_pub.extend_attrib_values_tbl,

3694: p_instance_rec IN csi_datastructures_pub.instance_rec,
3695: p_party_tbl IN csi_datastructures_pub.party_tbl,
3696: p_party_acct_tbl IN csi_datastructures_pub.party_account_tbl,
3697: p_org_units_tbl IN csi_datastructures_pub.organization_units_tbl,
3698: p_eav_tbl IN csi_datastructures_pub.extend_attrib_values_tbl,
3699: p_pricing_tbl IN csi_datastructures_pub.pricing_attribs_tbl,
3700: x_return_status OUT NOCOPY varchar2)
3701: IS
3702: l_csi_param_rec csi_install_parameters%rowtype;

Line 3699: p_pricing_tbl IN csi_datastructures_pub.pricing_attribs_tbl,

3695: p_party_tbl IN csi_datastructures_pub.party_tbl,
3696: p_party_acct_tbl IN csi_datastructures_pub.party_account_tbl,
3697: p_org_units_tbl IN csi_datastructures_pub.organization_units_tbl,
3698: p_eav_tbl IN csi_datastructures_pub.extend_attrib_values_tbl,
3699: p_pricing_tbl IN csi_datastructures_pub.pricing_attribs_tbl,
3700: x_return_status OUT NOCOPY varchar2)
3701: IS
3702: l_csi_param_rec csi_install_parameters%rowtype;
3703: BEGIN

Line 3730: px_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec,

3726: --
3727: --
3728: --
3729: PROCEDURE validate_and_derive_ids(
3730: px_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec,
3731: px_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl,
3732: px_party_acct_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,
3733: px_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
3734: px_eav_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,

Line 3731: px_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl,

3727: --
3728: --
3729: PROCEDURE validate_and_derive_ids(
3730: px_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec,
3731: px_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl,
3732: px_party_acct_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,
3733: px_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
3734: px_eav_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
3735: px_pricing_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,

Line 3732: px_party_acct_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,

3728: --
3729: PROCEDURE validate_and_derive_ids(
3730: px_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec,
3731: px_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl,
3732: px_party_acct_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,
3733: px_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
3734: px_eav_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
3735: px_pricing_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
3736: x_return_status OUT NOCOPY varchar2)

Line 3733: px_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,

3729: PROCEDURE validate_and_derive_ids(
3730: px_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec,
3731: px_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl,
3732: px_party_acct_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,
3733: px_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
3734: px_eav_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
3735: px_pricing_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
3736: x_return_status OUT NOCOPY varchar2)
3737: IS

Line 3734: px_eav_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,

3730: px_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec,
3731: px_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl,
3732: px_party_acct_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,
3733: px_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
3734: px_eav_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
3735: px_pricing_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
3736: x_return_status OUT NOCOPY varchar2)
3737: IS
3738: l_active_end_date date;

Line 3735: px_pricing_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,

3731: px_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl,
3732: px_party_acct_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,
3733: px_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
3734: px_eav_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
3735: px_pricing_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
3736: x_return_status OUT NOCOPY varchar2)
3737: IS
3738: l_active_end_date date;
3739: BEGIN

Line 3958: x_c_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,

3954:
3955: PROCEDURE build_relationship_tbl(
3956: p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
3957: p_txn_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
3958: x_c_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
3959: x_u_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
3960: x_return_status OUT NOCOPY varchar2)
3961: IS
3962:

Line 3959: x_u_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,

3955: PROCEDURE build_relationship_tbl(
3956: p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
3957: p_txn_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
3958: x_c_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
3959: x_u_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
3960: x_return_status OUT NOCOPY varchar2)
3961: IS
3962:
3963: l_r_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

Line 4193: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

4189: --
4190: PROCEDURE interface_ib(
4191: p_source_header_rec IN csi_interface_pkg.source_header_rec,
4192: p_source_line_rec IN csi_interface_pkg.source_line_rec,
4193: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
4194: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
4195: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
4196: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
4197: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

Line 4201: px_pricing_attribs_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,

4197: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
4198: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
4199: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
4200: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
4201: px_pricing_attribs_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
4202: x_return_status OUT NOCOPY varchar2,
4203: x_return_message OUT NOCOPY varchar2)
4204: IS
4205:

Line 4206: l_instance_rec csi_datastructures_pub.instance_rec;

4202: x_return_status OUT NOCOPY varchar2,
4203: x_return_message OUT NOCOPY varchar2)
4204: IS
4205:
4206: l_instance_rec csi_datastructures_pub.instance_rec;
4207: l_party_tbl csi_datastructures_pub.party_tbl;
4208: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4209: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4210: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 4207: l_party_tbl csi_datastructures_pub.party_tbl;

4203: x_return_message OUT NOCOPY varchar2)
4204: IS
4205:
4206: l_instance_rec csi_datastructures_pub.instance_rec;
4207: l_party_tbl csi_datastructures_pub.party_tbl;
4208: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4209: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4210: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
4211: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;

Line 4208: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;

4204: IS
4205:
4206: l_instance_rec csi_datastructures_pub.instance_rec;
4207: l_party_tbl csi_datastructures_pub.party_tbl;
4208: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4209: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4210: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
4211: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4212:

Line 4209: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;

4205:
4206: l_instance_rec csi_datastructures_pub.instance_rec;
4207: l_party_tbl csi_datastructures_pub.party_tbl;
4208: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4209: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4210: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
4211: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4212:
4213: l_sub_type_rec csi_txn_sub_types%rowtype;

Line 4210: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

4206: l_instance_rec csi_datastructures_pub.instance_rec;
4207: l_party_tbl csi_datastructures_pub.party_tbl;
4208: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4209: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4210: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
4211: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4212:
4213: l_sub_type_rec csi_txn_sub_types%rowtype;
4214: l_item_attrib_rec item_attributes_rec;

Line 4211: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;

4207: l_party_tbl csi_datastructures_pub.party_tbl;
4208: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4209: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4210: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
4211: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4212:
4213: l_sub_type_rec csi_txn_sub_types%rowtype;
4214: l_item_attrib_rec item_attributes_rec;
4215:

Line 4216: l_csi_txn_rec csi_datastructures_pub.transaction_rec;

4212:
4213: l_sub_type_rec csi_txn_sub_types%rowtype;
4214: l_item_attrib_rec item_attributes_rec;
4215:
4216: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
4217:
4218: l_c_instance_rec csi_datastructures_pub.instance_rec;
4219: l_c_party_tbl csi_datastructures_pub.party_tbl;
4220: l_c_party_acct_tbl csi_datastructures_pub.party_account_tbl;

Line 4218: l_c_instance_rec csi_datastructures_pub.instance_rec;

4214: l_item_attrib_rec item_attributes_rec;
4215:
4216: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
4217:
4218: l_c_instance_rec csi_datastructures_pub.instance_rec;
4219: l_c_party_tbl csi_datastructures_pub.party_tbl;
4220: l_c_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4221: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4222: l_c_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 4219: l_c_party_tbl csi_datastructures_pub.party_tbl;

4215:
4216: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
4217:
4218: l_c_instance_rec csi_datastructures_pub.instance_rec;
4219: l_c_party_tbl csi_datastructures_pub.party_tbl;
4220: l_c_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4221: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4222: l_c_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4223: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 4220: l_c_party_acct_tbl csi_datastructures_pub.party_account_tbl;

4216: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
4217:
4218: l_c_instance_rec csi_datastructures_pub.instance_rec;
4219: l_c_party_tbl csi_datastructures_pub.party_tbl;
4220: l_c_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4221: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4222: l_c_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4223: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
4224: l_c_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

Line 4221: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;

4217:
4218: l_c_instance_rec csi_datastructures_pub.instance_rec;
4219: l_c_party_tbl csi_datastructures_pub.party_tbl;
4220: l_c_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4221: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4222: l_c_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4223: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
4224: l_c_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4225:

Line 4222: l_c_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;

4218: l_c_instance_rec csi_datastructures_pub.instance_rec;
4219: l_c_party_tbl csi_datastructures_pub.party_tbl;
4220: l_c_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4221: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4222: l_c_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4223: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
4224: l_c_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4225:
4226: l_u_end_date date := null;

Line 4223: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

4219: l_c_party_tbl csi_datastructures_pub.party_tbl;
4220: l_c_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4221: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4222: l_c_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4223: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
4224: l_c_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4225:
4226: l_u_end_date date := null;
4227:

Line 4224: l_c_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

4220: l_c_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4221: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4222: l_c_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4223: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
4224: l_c_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4225:
4226: l_u_end_date date := null;
4227:
4228: l_u_instance_rec csi_datastructures_pub.instance_rec;

Line 4228: l_u_instance_rec csi_datastructures_pub.instance_rec;

4224: l_c_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4225:
4226: l_u_end_date date := null;
4227:
4228: l_u_instance_rec csi_datastructures_pub.instance_rec;
4229: l_u_party_tbl csi_datastructures_pub.party_tbl;
4230: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4231: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4232: l_u_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 4229: l_u_party_tbl csi_datastructures_pub.party_tbl;

4225:
4226: l_u_end_date date := null;
4227:
4228: l_u_instance_rec csi_datastructures_pub.instance_rec;
4229: l_u_party_tbl csi_datastructures_pub.party_tbl;
4230: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4231: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4232: l_u_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4233: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 4230: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;

4226: l_u_end_date date := null;
4227:
4228: l_u_instance_rec csi_datastructures_pub.instance_rec;
4229: l_u_party_tbl csi_datastructures_pub.party_tbl;
4230: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4231: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4232: l_u_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4233: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
4234: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

Line 4231: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;

4227:
4228: l_u_instance_rec csi_datastructures_pub.instance_rec;
4229: l_u_party_tbl csi_datastructures_pub.party_tbl;
4230: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4231: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4232: l_u_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4233: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
4234: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4235: l_u_inst_id_tbl csi_datastructures_pub.id_tbl;

Line 4232: l_u_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;

4228: l_u_instance_rec csi_datastructures_pub.instance_rec;
4229: l_u_party_tbl csi_datastructures_pub.party_tbl;
4230: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4231: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4232: l_u_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4233: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
4234: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4235: l_u_inst_id_tbl csi_datastructures_pub.id_tbl;
4236:

Line 4233: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

4229: l_u_party_tbl csi_datastructures_pub.party_tbl;
4230: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4231: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4232: l_u_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4233: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
4234: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4235: l_u_inst_id_tbl csi_datastructures_pub.id_tbl;
4236:
4237: l_c_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;

Line 4234: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

4230: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4231: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4232: l_u_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4233: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
4234: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4235: l_u_inst_id_tbl csi_datastructures_pub.id_tbl;
4236:
4237: l_c_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
4238: l_u_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;

Line 4235: l_u_inst_id_tbl csi_datastructures_pub.id_tbl;

4231: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4232: l_u_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4233: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
4234: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4235: l_u_inst_id_tbl csi_datastructures_pub.id_tbl;
4236:
4237: l_c_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
4238: l_u_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
4239:

Line 4237: l_c_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;

4233: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
4234: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4235: l_u_inst_id_tbl csi_datastructures_pub.id_tbl;
4236:
4237: l_c_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
4238: l_u_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
4239:
4240: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
4241: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;

Line 4238: l_u_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;

4234: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4235: l_u_inst_id_tbl csi_datastructures_pub.id_tbl;
4236:
4237: l_c_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
4238: l_u_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
4239:
4240: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
4241: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
4242:

Line 4244: l_bom_std_item_rec csi_datastructures_pub.instance_rec;

4240: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
4241: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
4242:
4243: -- explode bom variables
4244: l_bom_std_item_rec csi_datastructures_pub.instance_rec;
4245: l_comp_instance_tbl csi_datastructures_pub.instance_tbl;
4246: l_comp_relation_tbl csi_datastructures_pub.ii_relationship_tbl;
4247: l_bom_explode_flag BOOLEAN := FALSE;
4248:

Line 4245: l_comp_instance_tbl csi_datastructures_pub.instance_tbl;

4241: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
4242:
4243: -- explode bom variables
4244: l_bom_std_item_rec csi_datastructures_pub.instance_rec;
4245: l_comp_instance_tbl csi_datastructures_pub.instance_tbl;
4246: l_comp_relation_tbl csi_datastructures_pub.ii_relationship_tbl;
4247: l_bom_explode_flag BOOLEAN := FALSE;
4248:
4249: l_create_flag boolean := FALSE;

Line 4246: l_comp_relation_tbl csi_datastructures_pub.ii_relationship_tbl;

4242:
4243: -- explode bom variables
4244: l_bom_std_item_rec csi_datastructures_pub.instance_rec;
4245: l_comp_instance_tbl csi_datastructures_pub.instance_tbl;
4246: l_comp_relation_tbl csi_datastructures_pub.ii_relationship_tbl;
4247: l_bom_explode_flag BOOLEAN := FALSE;
4248:
4249: l_create_flag boolean := FALSE;
4250: l_call_contracts varchar2(1) := fnd_api.g_true;

Line 4259: l_inst_query_rec csi_datastructures_pub.instance_query_rec;

4255: l_parent_line_rec oe_order_pub.line_rec_type;
4256: om_vld_org_id NUMBER;
4257: l_csi_order_line_rec csi_order_ship_pub.order_line_rec;
4258: l_child_line_tbl oe_order_pub.line_tbl_type;
4259: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
4260: l_party_query_rec csi_datastructures_pub.party_query_rec;
4261: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
4262:
4263: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;

Line 4260: l_party_query_rec csi_datastructures_pub.party_query_rec;

4256: om_vld_org_id NUMBER;
4257: l_csi_order_line_rec csi_order_ship_pub.order_line_rec;
4258: l_child_line_tbl oe_order_pub.line_tbl_type;
4259: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
4260: l_party_query_rec csi_datastructures_pub.party_query_rec;
4261: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
4262:
4263: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
4264: l_rel_ctr NUMBER;

Line 4261: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;

4257: l_csi_order_line_rec csi_order_ship_pub.order_line_rec;
4258: l_child_line_tbl oe_order_pub.line_tbl_type;
4259: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
4260: l_party_query_rec csi_datastructures_pub.party_query_rec;
4261: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
4262:
4263: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
4264: l_rel_ctr NUMBER;
4265:

Line 4263: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;

4259: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
4260: l_party_query_rec csi_datastructures_pub.party_query_rec;
4261: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
4262:
4263: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
4264: l_rel_ctr NUMBER;
4265:
4266: l_active_end_date date := fnd_api.g_miss_date;
4267: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 5047: p_std_item_rec IN csi_datastructures_pub.instance_rec,

5043: /* This function specifies whether the instance qualifies for BOM Explosion or not */
5044:
5045: FUNCTION check_standard_bom_pc(
5046: p_instance_id IN NUMBER,
5047: p_std_item_rec IN csi_datastructures_pub.instance_rec,
5048: p_bom_item_type IN NUMBER)
5049: RETURN boolean
5050: IS
5051:

Line 5232: l_inst_query_rec csi_datastructures_pub.instance_query_rec;

5228: IS
5229:
5230: l_mtl_tbl mtl_txn_tbl;
5231:
5232: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
5233: l_party_query_rec csi_datastructures_pub.party_query_rec;
5234: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
5235: l_inst_hdr_tbl csi_datastructures_pub.instance_header_tbl;
5236:

Line 5233: l_party_query_rec csi_datastructures_pub.party_query_rec;

5229:
5230: l_mtl_tbl mtl_txn_tbl;
5231:
5232: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
5233: l_party_query_rec csi_datastructures_pub.party_query_rec;
5234: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
5235: l_inst_hdr_tbl csi_datastructures_pub.instance_header_tbl;
5236:
5237: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 5234: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;

5230: l_mtl_tbl mtl_txn_tbl;
5231:
5232: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
5233: l_party_query_rec csi_datastructures_pub.party_query_rec;
5234: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
5235: l_inst_hdr_tbl csi_datastructures_pub.instance_header_tbl;
5236:
5237: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
5238: l_msg_count number;

Line 5235: l_inst_hdr_tbl csi_datastructures_pub.instance_header_tbl;

5231:
5232: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
5233: l_party_query_rec csi_datastructures_pub.party_query_rec;
5234: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
5235: l_inst_hdr_tbl csi_datastructures_pub.instance_header_tbl;
5236:
5237: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
5238: l_msg_count number;
5239: l_msg_data varchar2(2000);

Line 5449: px_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

5445:
5446: PROCEDURE create_inv_negative_instance(
5447: px_mtl_txn_rec IN OUT NOCOPY mtl_txn_rec,
5448: p_quantity IN number,
5449: px_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
5450: x_return_status OUT NOCOPY varchar2)
5451: IS
5452: l_instance_rec csi_datastructures_pub.instance_rec;
5453: l_parties_tbl csi_datastructures_pub.party_tbl;

Line 5452: l_instance_rec csi_datastructures_pub.instance_rec;

5448: p_quantity IN number,
5449: px_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
5450: x_return_status OUT NOCOPY varchar2)
5451: IS
5452: l_instance_rec csi_datastructures_pub.instance_rec;
5453: l_parties_tbl csi_datastructures_pub.party_tbl;
5454: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
5455: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5456: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 5453: l_parties_tbl csi_datastructures_pub.party_tbl;

5449: px_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
5450: x_return_status OUT NOCOPY varchar2)
5451: IS
5452: l_instance_rec csi_datastructures_pub.instance_rec;
5453: l_parties_tbl csi_datastructures_pub.party_tbl;
5454: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
5455: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5456: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5457: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 5454: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

5450: x_return_status OUT NOCOPY varchar2)
5451: IS
5452: l_instance_rec csi_datastructures_pub.instance_rec;
5453: l_parties_tbl csi_datastructures_pub.party_tbl;
5454: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
5455: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5456: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5457: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
5458: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;

Line 5455: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;

5451: IS
5452: l_instance_rec csi_datastructures_pub.instance_rec;
5453: l_parties_tbl csi_datastructures_pub.party_tbl;
5454: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
5455: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5456: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5457: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
5458: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
5459:

Line 5456: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

5452: l_instance_rec csi_datastructures_pub.instance_rec;
5453: l_parties_tbl csi_datastructures_pub.party_tbl;
5454: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
5455: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5456: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5457: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
5458: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
5459:
5460: l_internal_party_id number;

Line 5457: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

5453: l_parties_tbl csi_datastructures_pub.party_tbl;
5454: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
5455: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5456: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5457: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
5458: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
5459:
5460: l_internal_party_id number;
5461:

Line 5458: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;

5454: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
5455: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5456: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5457: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
5458: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
5459:
5460: l_internal_party_id number;
5461:
5462: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 5472: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;

5468: x_return_status := fnd_api.g_ret_sts_success;
5469:
5470: api_log('create_inv_negative_instance');
5471:
5472: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
5473:
5474: l_instance_rec.inventory_item_id := px_mtl_txn_rec.inventory_item_id;
5475: l_instance_rec.inventory_revision := px_mtl_txn_rec.revision;
5476: l_instance_rec.inv_subinventory_name := px_mtl_txn_rec.subinventory_code;

Line 5543: px_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

5539:
5540: PROCEDURE decrement_inventory_instnace(
5541: p_instance_id IN number,
5542: p_quantity IN number,
5543: px_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
5544: x_return_status OUT NOCOPY varchar2)
5545: IS
5546:
5547: l_instance_rec csi_datastructures_pub.instance_rec;

Line 5547: l_instance_rec csi_datastructures_pub.instance_rec;

5543: px_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
5544: x_return_status OUT NOCOPY varchar2)
5545: IS
5546:
5547: l_instance_rec csi_datastructures_pub.instance_rec;
5548: l_party_tbl csi_datastructures_pub.party_tbl;
5549: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5550: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5551: l_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 5548: l_party_tbl csi_datastructures_pub.party_tbl;

5544: x_return_status OUT NOCOPY varchar2)
5545: IS
5546:
5547: l_instance_rec csi_datastructures_pub.instance_rec;
5548: l_party_tbl csi_datastructures_pub.party_tbl;
5549: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5550: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5551: l_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5552: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 5549: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;

5545: IS
5546:
5547: l_instance_rec csi_datastructures_pub.instance_rec;
5548: l_party_tbl csi_datastructures_pub.party_tbl;
5549: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5550: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5551: l_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5552: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5553: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;

Line 5550: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

5546:
5547: l_instance_rec csi_datastructures_pub.instance_rec;
5548: l_party_tbl csi_datastructures_pub.party_tbl;
5549: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5550: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5551: l_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5552: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5553: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5554: l_inst_id_lst csi_datastructures_pub.id_tbl;

Line 5551: l_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

5547: l_instance_rec csi_datastructures_pub.instance_rec;
5548: l_party_tbl csi_datastructures_pub.party_tbl;
5549: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5550: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5551: l_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5552: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5553: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5554: l_inst_id_lst csi_datastructures_pub.id_tbl;
5555:

Line 5552: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

5548: l_party_tbl csi_datastructures_pub.party_tbl;
5549: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5550: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5551: l_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5552: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5553: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5554: l_inst_id_lst csi_datastructures_pub.id_tbl;
5555:
5556: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 5553: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;

5549: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5550: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5551: l_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5552: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5553: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5554: l_inst_id_lst csi_datastructures_pub.id_tbl;
5555:
5556: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
5557: l_msg_count number;

Line 5554: l_inst_id_lst csi_datastructures_pub.id_tbl;

5550: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5551: l_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5552: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5553: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5554: l_inst_id_lst csi_datastructures_pub.id_tbl;
5555:
5556: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
5557: l_msg_count number;
5558: l_msg_data varchar2(2000);

Line 5637: px_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

5633:
5634: PROCEDURE decrement_inventory_instances(
5635: p_item_attrib_rec IN item_attributes_rec,
5636: p_mtl_txn_tbl IN OUT NOCOPY mtl_txn_tbl,
5637: px_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
5638: x_return_status OUT NOCOPY varchar2)
5639: IS
5640: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
5641: BEGIN

Line 6281: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,

6277: --
6278: PROCEDURE process_cz_txn_details(
6279: p_config_session_keys IN csi_utility_grp.config_session_keys,
6280: p_instance_id IN number,
6281: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
6282: x_return_status OUT NOCOPY varchar2)
6283: IS
6284:
6285: l_source_hdr_rec source_header_rec;

Line 6289: l_csi_txn_rec csi_datastructures_pub.transaction_rec;

6285: l_source_hdr_rec source_header_rec;
6286: l_source_line_rec source_line_rec;
6287: l_src_instance_key csi_utility_grp.config_instance_key;
6288:
6289: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
6290:
6291: l_tl_rec csi_t_datastructures_grp.txn_line_rec;
6292: l_td_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6293: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

Line 6298: l_pr_tbl csi_datastructures_pub.pricing_attribs_tbl;

6294: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6295: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6296: l_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6297: l_ir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6298: l_pr_tbl csi_datastructures_pub.pricing_attribs_tbl;
6299: l_sy_tbl csi_t_datastructures_grp.txn_systems_tbl;
6300:
6301: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
6302: l_return_message varchar2(2000);