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 731: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,

727: --
728: --
729: PROCEDURE get_pricing_attributes(
730: p_line_id IN number,
731: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
732: x_return_status OUT NOCOPY varchar2)
733: IS
734:
735: l_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 735: l_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;

731: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
732: x_return_status OUT NOCOPY varchar2)
733: IS
734:
735: l_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
736: l_ind binary_integer := 0;
737:
738: CURSOR price_cur IS
739: SELECT pricing_context,

Line 974: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,

970: p_split_loop IN number,
971: p_transaction_type_id IN number,
972: p_source_header_rec IN source_header_rec,
973: p_source_line_rec IN source_line_rec,
974: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
975: x_txn_line_rec OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
976: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
977: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
978: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

Line 980: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,

976: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
977: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
978: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
979: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
980: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
981: x_return_status OUT NOCOPY varchar2)
982: IS
983:
984: l_default_sub_type_id number;

Line 1221: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,

1217: p_source_table IN varchar2,
1218: p_source_id IN number,
1219: p_source_header_rec IN source_header_rec,
1220: p_source_line_rec IN source_line_rec,
1221: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
1222: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec, --bug 5194812, changed this param to IN OUT
1223: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1224: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1225: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

Line 1227: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,

1223: x_txn_line_detail_tbl OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1224: x_txn_party_tbl OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1225: x_txn_party_acct_tbl OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1226: x_txn_org_assgn_tbl OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
1227: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
1228: x_return_status OUT NOCOPY varchar2)
1229: IS
1230:
1231: l_default_sub_type_id number;

Line 1473: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,

1469: p_source_table IN varchar2,
1470: p_source_id IN number,
1471: p_source_header_rec IN source_header_rec,
1472: p_source_line_rec IN source_line_rec,
1473: p_csi_txn_rec IN csi_datastructures_pub.transaction_rec,
1474: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
1475: px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1476: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1477: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

Line 1479: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,

1475: px_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
1476: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
1477: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
1478: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
1479: x_pricing_attribs_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
1480: x_return_status OUT NOCOPY varchar2)
1481: IS
1482: l_tld_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
1483: l_pty_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

Line 2385: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,

2381: --
2382: --
2383: PROCEDURE get_instances_for_source(
2384: p_source_line_rec IN source_line_rec,
2385: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
2386: x_return_status OUT NOCOPY varchar2)
2387: IS
2388:
2389: l_inst_query_rec csi_datastructures_pub.instance_query_rec;

Line 2389: l_inst_query_rec csi_datastructures_pub.instance_query_rec;

2385: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
2386: x_return_status OUT NOCOPY varchar2)
2387: IS
2388:
2389: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
2390: l_party_query_rec csi_datastructures_pub.party_query_rec;
2391: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
2392:
2393: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;

Line 2390: l_party_query_rec csi_datastructures_pub.party_query_rec;

2386: x_return_status OUT NOCOPY varchar2)
2387: IS
2388:
2389: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
2390: l_party_query_rec csi_datastructures_pub.party_query_rec;
2391: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
2392:
2393: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
2394: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 2391: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;

2387: IS
2388:
2389: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
2390: l_party_query_rec csi_datastructures_pub.party_query_rec;
2391: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
2392:
2393: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
2394: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2395: l_msg_count number;

Line 2393: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;

2389: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
2390: l_party_query_rec csi_datastructures_pub.party_query_rec;
2391: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
2392:
2393: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
2394: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2395: l_msg_count number;
2396: l_msg_data varchar2(2000);
2397:

Line 2462: l_parent_instance_tbl csi_datastructures_pub.instance_tbl;

2458:
2459: l_parent_found boolean := FALSE;
2460: l_parent_line_rec source_line_rec;
2461:
2462: l_parent_instance_tbl csi_datastructures_pub.instance_tbl;
2463: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2464:
2465: BEGIN
2466:

Line 3210: px_pricing_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,

3206: p_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
3207: p_txn_party_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
3208: p_txn_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,
3209: p_txn_eav_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
3210: px_pricing_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
3211: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,
3212: x_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl,
3213: x_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
3214: x_eav_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,

Line 3211: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,

3207: p_txn_party_acct_tbl IN csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
3208: p_txn_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,
3209: p_txn_eav_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
3210: px_pricing_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
3211: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,
3212: x_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl,
3213: x_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
3214: x_eav_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
3215: x_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,

Line 3212: x_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl,

3208: p_txn_org_assgn_tbl IN csi_t_datastructures_grp.txn_org_assgn_tbl,
3209: p_txn_eav_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
3210: px_pricing_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
3211: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,
3212: x_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl,
3213: x_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
3214: x_eav_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
3215: x_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
3216: x_return_status OUT NOCOPY varchar2)

Line 3213: x_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,

3209: p_txn_eav_tbl IN csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
3210: px_pricing_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
3211: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,
3212: x_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl,
3213: x_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
3214: x_eav_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
3215: x_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
3216: x_return_status OUT NOCOPY varchar2)
3217: IS

Line 3214: x_eav_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,

3210: px_pricing_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
3211: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,
3212: x_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl,
3213: x_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
3214: x_eav_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
3215: x_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
3216: x_return_status OUT NOCOPY varchar2)
3217: IS
3218: l_i_rec csi_datastructures_pub.instance_rec;

Line 3215: x_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,

3211: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,
3212: x_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl,
3213: x_party_acct_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
3214: x_eav_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
3215: x_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
3216: x_return_status OUT NOCOPY varchar2)
3217: IS
3218: l_i_rec csi_datastructures_pub.instance_rec;
3219: l_p_tbl csi_datastructures_pub.party_tbl;

Line 3218: l_i_rec csi_datastructures_pub.instance_rec;

3214: x_eav_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
3215: x_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
3216: x_return_status OUT NOCOPY varchar2)
3217: IS
3218: l_i_rec csi_datastructures_pub.instance_rec;
3219: l_p_tbl csi_datastructures_pub.party_tbl;
3220: l_pa_tbl csi_datastructures_pub.party_account_tbl;
3221: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3222: l_ou_tbl csi_datastructures_pub.organization_units_tbl;

Line 3219: l_p_tbl csi_datastructures_pub.party_tbl;

3215: x_org_units_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
3216: x_return_status OUT NOCOPY varchar2)
3217: IS
3218: l_i_rec csi_datastructures_pub.instance_rec;
3219: l_p_tbl csi_datastructures_pub.party_tbl;
3220: l_pa_tbl csi_datastructures_pub.party_account_tbl;
3221: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3222: l_ou_tbl csi_datastructures_pub.organization_units_tbl;
3223:

Line 3220: l_pa_tbl csi_datastructures_pub.party_account_tbl;

3216: x_return_status OUT NOCOPY varchar2)
3217: IS
3218: l_i_rec csi_datastructures_pub.instance_rec;
3219: l_p_tbl csi_datastructures_pub.party_tbl;
3220: l_pa_tbl csi_datastructures_pub.party_account_tbl;
3221: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3222: l_ou_tbl csi_datastructures_pub.organization_units_tbl;
3223:
3224: l_instance_key csi_utility_grp.config_instance_key;

Line 3221: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;

3217: IS
3218: l_i_rec csi_datastructures_pub.instance_rec;
3219: l_p_tbl csi_datastructures_pub.party_tbl;
3220: l_pa_tbl csi_datastructures_pub.party_account_tbl;
3221: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3222: l_ou_tbl csi_datastructures_pub.organization_units_tbl;
3223:
3224: l_instance_key csi_utility_grp.config_instance_key;
3225:

Line 3222: l_ou_tbl csi_datastructures_pub.organization_units_tbl;

3218: l_i_rec csi_datastructures_pub.instance_rec;
3219: l_p_tbl csi_datastructures_pub.party_tbl;
3220: l_pa_tbl csi_datastructures_pub.party_account_tbl;
3221: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3222: l_ou_tbl csi_datastructures_pub.organization_units_tbl;
3223:
3224: l_instance_key csi_utility_grp.config_instance_key;
3225:
3226: p_ind binary_integer := 0;

Line 3602: p_instance_rec IN csi_datastructures_pub.instance_rec,

3598:
3599: PROCEDURE sub_type_specific_vldns(
3600: p_source_flag IN varchar2,
3601: p_sub_type_rec IN csi_txn_sub_types%rowtype,
3602: p_instance_rec IN csi_datastructures_pub.instance_rec,
3603: p_party_tbl IN csi_datastructures_pub.party_tbl,
3604: p_party_acct_tbl IN csi_datastructures_pub.party_account_tbl,
3605: p_org_units_tbl IN csi_datastructures_pub.organization_units_tbl,
3606: p_eav_tbl IN csi_datastructures_pub.extend_attrib_values_tbl,

Line 3603: p_party_tbl IN csi_datastructures_pub.party_tbl,

3599: PROCEDURE sub_type_specific_vldns(
3600: p_source_flag IN varchar2,
3601: p_sub_type_rec IN csi_txn_sub_types%rowtype,
3602: p_instance_rec IN csi_datastructures_pub.instance_rec,
3603: p_party_tbl IN csi_datastructures_pub.party_tbl,
3604: p_party_acct_tbl IN csi_datastructures_pub.party_account_tbl,
3605: p_org_units_tbl IN csi_datastructures_pub.organization_units_tbl,
3606: p_eav_tbl IN csi_datastructures_pub.extend_attrib_values_tbl,
3607: p_pricing_tbl IN csi_datastructures_pub.pricing_attribs_tbl,

Line 3604: p_party_acct_tbl IN csi_datastructures_pub.party_account_tbl,

3600: p_source_flag IN varchar2,
3601: p_sub_type_rec IN csi_txn_sub_types%rowtype,
3602: p_instance_rec IN csi_datastructures_pub.instance_rec,
3603: p_party_tbl IN csi_datastructures_pub.party_tbl,
3604: p_party_acct_tbl IN csi_datastructures_pub.party_account_tbl,
3605: p_org_units_tbl IN csi_datastructures_pub.organization_units_tbl,
3606: p_eav_tbl IN csi_datastructures_pub.extend_attrib_values_tbl,
3607: p_pricing_tbl IN csi_datastructures_pub.pricing_attribs_tbl,
3608: x_return_status OUT NOCOPY varchar2)

Line 3605: p_org_units_tbl IN csi_datastructures_pub.organization_units_tbl,

3601: p_sub_type_rec IN csi_txn_sub_types%rowtype,
3602: p_instance_rec IN csi_datastructures_pub.instance_rec,
3603: p_party_tbl IN csi_datastructures_pub.party_tbl,
3604: p_party_acct_tbl IN csi_datastructures_pub.party_account_tbl,
3605: p_org_units_tbl IN csi_datastructures_pub.organization_units_tbl,
3606: p_eav_tbl IN csi_datastructures_pub.extend_attrib_values_tbl,
3607: p_pricing_tbl IN csi_datastructures_pub.pricing_attribs_tbl,
3608: x_return_status OUT NOCOPY varchar2)
3609: IS

Line 3606: p_eav_tbl IN csi_datastructures_pub.extend_attrib_values_tbl,

3602: p_instance_rec IN csi_datastructures_pub.instance_rec,
3603: p_party_tbl IN csi_datastructures_pub.party_tbl,
3604: p_party_acct_tbl IN csi_datastructures_pub.party_account_tbl,
3605: p_org_units_tbl IN csi_datastructures_pub.organization_units_tbl,
3606: p_eav_tbl IN csi_datastructures_pub.extend_attrib_values_tbl,
3607: p_pricing_tbl IN csi_datastructures_pub.pricing_attribs_tbl,
3608: x_return_status OUT NOCOPY varchar2)
3609: IS
3610: l_csi_param_rec csi_install_parameters%rowtype;

Line 3607: p_pricing_tbl IN csi_datastructures_pub.pricing_attribs_tbl,

3603: p_party_tbl IN csi_datastructures_pub.party_tbl,
3604: p_party_acct_tbl IN csi_datastructures_pub.party_account_tbl,
3605: p_org_units_tbl IN csi_datastructures_pub.organization_units_tbl,
3606: p_eav_tbl IN csi_datastructures_pub.extend_attrib_values_tbl,
3607: p_pricing_tbl IN csi_datastructures_pub.pricing_attribs_tbl,
3608: x_return_status OUT NOCOPY varchar2)
3609: IS
3610: l_csi_param_rec csi_install_parameters%rowtype;
3611: BEGIN

Line 3638: px_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec,

3634: --
3635: --
3636: --
3637: PROCEDURE validate_and_derive_ids(
3638: px_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec,
3639: px_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl,
3640: px_party_acct_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,
3641: px_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
3642: px_eav_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,

Line 3639: px_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl,

3635: --
3636: --
3637: PROCEDURE validate_and_derive_ids(
3638: px_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec,
3639: px_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl,
3640: px_party_acct_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,
3641: px_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
3642: px_eav_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
3643: px_pricing_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,

Line 3640: px_party_acct_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,

3636: --
3637: PROCEDURE validate_and_derive_ids(
3638: px_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec,
3639: px_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl,
3640: px_party_acct_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,
3641: px_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
3642: px_eav_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
3643: px_pricing_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
3644: x_return_status OUT NOCOPY varchar2)

Line 3641: px_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,

3637: PROCEDURE validate_and_derive_ids(
3638: px_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec,
3639: px_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl,
3640: px_party_acct_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,
3641: px_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
3642: px_eav_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
3643: px_pricing_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
3644: x_return_status OUT NOCOPY varchar2)
3645: IS

Line 3642: px_eav_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,

3638: px_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec,
3639: px_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl,
3640: px_party_acct_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,
3641: px_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
3642: px_eav_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
3643: px_pricing_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
3644: x_return_status OUT NOCOPY varchar2)
3645: IS
3646: l_active_end_date date;

Line 3643: px_pricing_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,

3639: px_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl,
3640: px_party_acct_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl,
3641: px_org_units_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
3642: px_eav_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
3643: px_pricing_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
3644: x_return_status OUT NOCOPY varchar2)
3645: IS
3646: l_active_end_date date;
3647: BEGIN

Line 3866: x_c_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,

3862:
3863: PROCEDURE build_relationship_tbl(
3864: p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
3865: p_txn_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
3866: x_c_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
3867: x_u_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
3868: x_return_status OUT NOCOPY varchar2)
3869: IS
3870:

Line 3867: x_u_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,

3863: PROCEDURE build_relationship_tbl(
3864: p_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
3865: p_txn_line_dtl_tbl IN csi_t_datastructures_grp.txn_line_detail_tbl,
3866: x_c_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
3867: x_u_ii_rltns_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl,
3868: x_return_status OUT NOCOPY varchar2)
3869: IS
3870:
3871: l_r_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;

Line 4101: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

4097: --
4098: PROCEDURE interface_ib(
4099: p_source_header_rec IN csi_interface_pkg.source_header_rec,
4100: p_source_line_rec IN csi_interface_pkg.source_line_rec,
4101: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
4102: px_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
4103: px_txn_line_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
4104: px_txn_party_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
4105: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

Line 4109: px_pricing_attribs_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,

4105: px_txn_party_acct_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
4106: px_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
4107: px_txn_eav_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
4108: px_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
4109: px_pricing_attribs_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
4110: x_return_status OUT NOCOPY varchar2,
4111: x_return_message OUT NOCOPY varchar2)
4112: IS
4113:

Line 4114: l_instance_rec csi_datastructures_pub.instance_rec;

4110: x_return_status OUT NOCOPY varchar2,
4111: x_return_message OUT NOCOPY varchar2)
4112: IS
4113:
4114: l_instance_rec csi_datastructures_pub.instance_rec;
4115: l_party_tbl csi_datastructures_pub.party_tbl;
4116: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4117: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4118: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 4115: l_party_tbl csi_datastructures_pub.party_tbl;

4111: x_return_message OUT NOCOPY varchar2)
4112: IS
4113:
4114: l_instance_rec csi_datastructures_pub.instance_rec;
4115: l_party_tbl csi_datastructures_pub.party_tbl;
4116: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4117: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4118: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
4119: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;

Line 4116: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;

4112: IS
4113:
4114: l_instance_rec csi_datastructures_pub.instance_rec;
4115: l_party_tbl csi_datastructures_pub.party_tbl;
4116: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4117: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4118: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
4119: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4120:

Line 4117: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;

4113:
4114: l_instance_rec csi_datastructures_pub.instance_rec;
4115: l_party_tbl csi_datastructures_pub.party_tbl;
4116: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4117: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4118: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
4119: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4120:
4121: l_sub_type_rec csi_txn_sub_types%rowtype;

Line 4118: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

4114: l_instance_rec csi_datastructures_pub.instance_rec;
4115: l_party_tbl csi_datastructures_pub.party_tbl;
4116: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4117: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4118: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
4119: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4120:
4121: l_sub_type_rec csi_txn_sub_types%rowtype;
4122: l_item_attrib_rec item_attributes_rec;

Line 4119: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;

4115: l_party_tbl csi_datastructures_pub.party_tbl;
4116: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4117: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4118: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
4119: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4120:
4121: l_sub_type_rec csi_txn_sub_types%rowtype;
4122: l_item_attrib_rec item_attributes_rec;
4123:

Line 4124: l_csi_txn_rec csi_datastructures_pub.transaction_rec;

4120:
4121: l_sub_type_rec csi_txn_sub_types%rowtype;
4122: l_item_attrib_rec item_attributes_rec;
4123:
4124: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
4125:
4126: l_c_instance_rec csi_datastructures_pub.instance_rec;
4127: l_c_party_tbl csi_datastructures_pub.party_tbl;
4128: l_c_party_acct_tbl csi_datastructures_pub.party_account_tbl;

Line 4126: l_c_instance_rec csi_datastructures_pub.instance_rec;

4122: l_item_attrib_rec item_attributes_rec;
4123:
4124: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
4125:
4126: l_c_instance_rec csi_datastructures_pub.instance_rec;
4127: l_c_party_tbl csi_datastructures_pub.party_tbl;
4128: l_c_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4129: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4130: l_c_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 4127: l_c_party_tbl csi_datastructures_pub.party_tbl;

4123:
4124: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
4125:
4126: l_c_instance_rec csi_datastructures_pub.instance_rec;
4127: l_c_party_tbl csi_datastructures_pub.party_tbl;
4128: l_c_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4129: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4130: l_c_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4131: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 4128: l_c_party_acct_tbl csi_datastructures_pub.party_account_tbl;

4124: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
4125:
4126: l_c_instance_rec csi_datastructures_pub.instance_rec;
4127: l_c_party_tbl csi_datastructures_pub.party_tbl;
4128: l_c_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4129: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4130: l_c_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4131: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
4132: l_c_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

Line 4129: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;

4125:
4126: l_c_instance_rec csi_datastructures_pub.instance_rec;
4127: l_c_party_tbl csi_datastructures_pub.party_tbl;
4128: l_c_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4129: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4130: l_c_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4131: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
4132: l_c_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4133:

Line 4130: l_c_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;

4126: l_c_instance_rec csi_datastructures_pub.instance_rec;
4127: l_c_party_tbl csi_datastructures_pub.party_tbl;
4128: l_c_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4129: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4130: l_c_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4131: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
4132: l_c_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4133:
4134: l_u_end_date date := null;

Line 4131: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

4127: l_c_party_tbl csi_datastructures_pub.party_tbl;
4128: l_c_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4129: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4130: l_c_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4131: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
4132: l_c_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4133:
4134: l_u_end_date date := null;
4135:

Line 4132: l_c_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

4128: l_c_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4129: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4130: l_c_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4131: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
4132: l_c_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4133:
4134: l_u_end_date date := null;
4135:
4136: l_u_instance_rec csi_datastructures_pub.instance_rec;

Line 4136: l_u_instance_rec csi_datastructures_pub.instance_rec;

4132: l_c_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4133:
4134: l_u_end_date date := null;
4135:
4136: l_u_instance_rec csi_datastructures_pub.instance_rec;
4137: l_u_party_tbl csi_datastructures_pub.party_tbl;
4138: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4139: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4140: l_u_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 4137: l_u_party_tbl csi_datastructures_pub.party_tbl;

4133:
4134: l_u_end_date date := null;
4135:
4136: l_u_instance_rec csi_datastructures_pub.instance_rec;
4137: l_u_party_tbl csi_datastructures_pub.party_tbl;
4138: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4139: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4140: l_u_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4141: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 4138: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;

4134: l_u_end_date date := null;
4135:
4136: l_u_instance_rec csi_datastructures_pub.instance_rec;
4137: l_u_party_tbl csi_datastructures_pub.party_tbl;
4138: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4139: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4140: l_u_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4141: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
4142: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

Line 4139: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;

4135:
4136: l_u_instance_rec csi_datastructures_pub.instance_rec;
4137: l_u_party_tbl csi_datastructures_pub.party_tbl;
4138: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4139: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4140: l_u_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4141: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
4142: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4143: l_u_inst_id_tbl csi_datastructures_pub.id_tbl;

Line 4140: l_u_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;

4136: l_u_instance_rec csi_datastructures_pub.instance_rec;
4137: l_u_party_tbl csi_datastructures_pub.party_tbl;
4138: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4139: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4140: l_u_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4141: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
4142: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4143: l_u_inst_id_tbl csi_datastructures_pub.id_tbl;
4144:

Line 4141: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

4137: l_u_party_tbl csi_datastructures_pub.party_tbl;
4138: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4139: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4140: l_u_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4141: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
4142: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4143: l_u_inst_id_tbl csi_datastructures_pub.id_tbl;
4144:
4145: l_c_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;

Line 4142: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

4138: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4139: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4140: l_u_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4141: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
4142: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4143: l_u_inst_id_tbl csi_datastructures_pub.id_tbl;
4144:
4145: l_c_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
4146: l_u_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;

Line 4143: l_u_inst_id_tbl csi_datastructures_pub.id_tbl;

4139: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4140: l_u_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4141: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
4142: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4143: l_u_inst_id_tbl csi_datastructures_pub.id_tbl;
4144:
4145: l_c_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
4146: l_u_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
4147:

Line 4145: l_c_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;

4141: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
4142: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4143: l_u_inst_id_tbl csi_datastructures_pub.id_tbl;
4144:
4145: l_c_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
4146: l_u_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
4147:
4148: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
4149: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;

Line 4146: l_u_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;

4142: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4143: l_u_inst_id_tbl csi_datastructures_pub.id_tbl;
4144:
4145: l_c_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
4146: l_u_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
4147:
4148: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
4149: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
4150:

Line 4152: l_bom_std_item_rec csi_datastructures_pub.instance_rec;

4148: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
4149: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
4150:
4151: -- explode bom variables
4152: l_bom_std_item_rec csi_datastructures_pub.instance_rec;
4153: l_comp_instance_tbl csi_datastructures_pub.instance_tbl;
4154: l_comp_relation_tbl csi_datastructures_pub.ii_relationship_tbl;
4155: l_bom_explode_flag BOOLEAN := FALSE;
4156:

Line 4153: l_comp_instance_tbl csi_datastructures_pub.instance_tbl;

4149: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
4150:
4151: -- explode bom variables
4152: l_bom_std_item_rec csi_datastructures_pub.instance_rec;
4153: l_comp_instance_tbl csi_datastructures_pub.instance_tbl;
4154: l_comp_relation_tbl csi_datastructures_pub.ii_relationship_tbl;
4155: l_bom_explode_flag BOOLEAN := FALSE;
4156:
4157: l_create_flag boolean := FALSE;

Line 4154: l_comp_relation_tbl csi_datastructures_pub.ii_relationship_tbl;

4150:
4151: -- explode bom variables
4152: l_bom_std_item_rec csi_datastructures_pub.instance_rec;
4153: l_comp_instance_tbl csi_datastructures_pub.instance_tbl;
4154: l_comp_relation_tbl csi_datastructures_pub.ii_relationship_tbl;
4155: l_bom_explode_flag BOOLEAN := FALSE;
4156:
4157: l_create_flag boolean := FALSE;
4158: l_call_contracts varchar2(1) := fnd_api.g_true;

Line 4167: l_inst_query_rec csi_datastructures_pub.instance_query_rec;

4163: l_parent_line_rec oe_order_pub.line_rec_type;
4164: om_vld_org_id NUMBER;
4165: l_csi_order_line_rec csi_order_ship_pub.order_line_rec;
4166: l_child_line_tbl oe_order_pub.line_tbl_type;
4167: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
4168: l_party_query_rec csi_datastructures_pub.party_query_rec;
4169: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
4170:
4171: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;

Line 4168: l_party_query_rec csi_datastructures_pub.party_query_rec;

4164: om_vld_org_id NUMBER;
4165: l_csi_order_line_rec csi_order_ship_pub.order_line_rec;
4166: l_child_line_tbl oe_order_pub.line_tbl_type;
4167: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
4168: l_party_query_rec csi_datastructures_pub.party_query_rec;
4169: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
4170:
4171: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
4172: l_rel_ctr NUMBER;

Line 4169: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;

4165: l_csi_order_line_rec csi_order_ship_pub.order_line_rec;
4166: l_child_line_tbl oe_order_pub.line_tbl_type;
4167: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
4168: l_party_query_rec csi_datastructures_pub.party_query_rec;
4169: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
4170:
4171: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
4172: l_rel_ctr NUMBER;
4173:

Line 4171: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;

4167: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
4168: l_party_query_rec csi_datastructures_pub.party_query_rec;
4169: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
4170:
4171: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
4172: l_rel_ctr NUMBER;
4173:
4174: l_active_end_date date := fnd_api.g_miss_date;
4175: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 4940: p_std_item_rec IN csi_datastructures_pub.instance_rec,

4936: /* This function specifies whether the instance qualifies for BOM Explosion or not */
4937:
4938: FUNCTION check_standard_bom_pc(
4939: p_instance_id IN NUMBER,
4940: p_std_item_rec IN csi_datastructures_pub.instance_rec,
4941: p_bom_item_type IN NUMBER)
4942: RETURN boolean
4943: IS
4944:

Line 5125: l_inst_query_rec csi_datastructures_pub.instance_query_rec;

5121: IS
5122:
5123: l_mtl_tbl mtl_txn_tbl;
5124:
5125: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
5126: l_party_query_rec csi_datastructures_pub.party_query_rec;
5127: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
5128: l_inst_hdr_tbl csi_datastructures_pub.instance_header_tbl;
5129:

Line 5126: l_party_query_rec csi_datastructures_pub.party_query_rec;

5122:
5123: l_mtl_tbl mtl_txn_tbl;
5124:
5125: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
5126: l_party_query_rec csi_datastructures_pub.party_query_rec;
5127: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
5128: l_inst_hdr_tbl csi_datastructures_pub.instance_header_tbl;
5129:
5130: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 5127: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;

5123: l_mtl_tbl mtl_txn_tbl;
5124:
5125: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
5126: l_party_query_rec csi_datastructures_pub.party_query_rec;
5127: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
5128: l_inst_hdr_tbl csi_datastructures_pub.instance_header_tbl;
5129:
5130: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
5131: l_msg_count number;

Line 5128: l_inst_hdr_tbl csi_datastructures_pub.instance_header_tbl;

5124:
5125: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
5126: l_party_query_rec csi_datastructures_pub.party_query_rec;
5127: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
5128: l_inst_hdr_tbl csi_datastructures_pub.instance_header_tbl;
5129:
5130: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
5131: l_msg_count number;
5132: l_msg_data varchar2(2000);

Line 5342: px_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

5338:
5339: PROCEDURE create_inv_negative_instance(
5340: px_mtl_txn_rec IN OUT NOCOPY mtl_txn_rec,
5341: p_quantity IN number,
5342: px_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
5343: x_return_status OUT NOCOPY varchar2)
5344: IS
5345: l_instance_rec csi_datastructures_pub.instance_rec;
5346: l_parties_tbl csi_datastructures_pub.party_tbl;

Line 5345: l_instance_rec csi_datastructures_pub.instance_rec;

5341: p_quantity IN number,
5342: px_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
5343: x_return_status OUT NOCOPY varchar2)
5344: IS
5345: l_instance_rec csi_datastructures_pub.instance_rec;
5346: l_parties_tbl csi_datastructures_pub.party_tbl;
5347: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
5348: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5349: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 5346: l_parties_tbl csi_datastructures_pub.party_tbl;

5342: px_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
5343: x_return_status OUT NOCOPY varchar2)
5344: IS
5345: l_instance_rec csi_datastructures_pub.instance_rec;
5346: l_parties_tbl csi_datastructures_pub.party_tbl;
5347: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
5348: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5349: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5350: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 5347: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

5343: x_return_status OUT NOCOPY varchar2)
5344: IS
5345: l_instance_rec csi_datastructures_pub.instance_rec;
5346: l_parties_tbl csi_datastructures_pub.party_tbl;
5347: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
5348: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5349: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5350: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
5351: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;

Line 5348: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;

5344: IS
5345: l_instance_rec csi_datastructures_pub.instance_rec;
5346: l_parties_tbl csi_datastructures_pub.party_tbl;
5347: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
5348: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5349: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5350: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
5351: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
5352:

Line 5349: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

5345: l_instance_rec csi_datastructures_pub.instance_rec;
5346: l_parties_tbl csi_datastructures_pub.party_tbl;
5347: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
5348: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5349: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5350: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
5351: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
5352:
5353: l_internal_party_id number;

Line 5350: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

5346: l_parties_tbl csi_datastructures_pub.party_tbl;
5347: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
5348: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5349: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5350: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
5351: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
5352:
5353: l_internal_party_id number;
5354:

Line 5351: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;

5347: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
5348: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5349: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5350: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
5351: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
5352:
5353: l_internal_party_id number;
5354:
5355: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

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

5361: x_return_status := fnd_api.g_ret_sts_success;
5362:
5363: api_log('create_inv_negative_instance');
5364:
5365: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
5366:
5367: l_instance_rec.inventory_item_id := px_mtl_txn_rec.inventory_item_id;
5368: l_instance_rec.inventory_revision := px_mtl_txn_rec.revision;
5369: l_instance_rec.inv_subinventory_name := px_mtl_txn_rec.subinventory_code;

Line 5436: px_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

5432:
5433: PROCEDURE decrement_inventory_instnace(
5434: p_instance_id IN number,
5435: p_quantity IN number,
5436: px_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
5437: x_return_status OUT NOCOPY varchar2)
5438: IS
5439:
5440: l_instance_rec csi_datastructures_pub.instance_rec;

Line 5440: l_instance_rec csi_datastructures_pub.instance_rec;

5436: px_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
5437: x_return_status OUT NOCOPY varchar2)
5438: IS
5439:
5440: l_instance_rec csi_datastructures_pub.instance_rec;
5441: l_party_tbl csi_datastructures_pub.party_tbl;
5442: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5443: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5444: l_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 5441: l_party_tbl csi_datastructures_pub.party_tbl;

5437: x_return_status OUT NOCOPY varchar2)
5438: IS
5439:
5440: l_instance_rec csi_datastructures_pub.instance_rec;
5441: l_party_tbl csi_datastructures_pub.party_tbl;
5442: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5443: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5444: l_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5445: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 5442: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;

5438: IS
5439:
5440: l_instance_rec csi_datastructures_pub.instance_rec;
5441: l_party_tbl csi_datastructures_pub.party_tbl;
5442: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5443: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5444: l_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5445: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5446: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;

Line 5443: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

5439:
5440: l_instance_rec csi_datastructures_pub.instance_rec;
5441: l_party_tbl csi_datastructures_pub.party_tbl;
5442: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5443: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5444: l_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5445: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5446: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5447: l_inst_id_lst csi_datastructures_pub.id_tbl;

Line 5444: l_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

5440: l_instance_rec csi_datastructures_pub.instance_rec;
5441: l_party_tbl csi_datastructures_pub.party_tbl;
5442: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5443: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5444: l_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5445: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5446: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5447: l_inst_id_lst csi_datastructures_pub.id_tbl;
5448:

Line 5445: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

5441: l_party_tbl csi_datastructures_pub.party_tbl;
5442: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5443: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5444: l_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5445: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5446: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5447: l_inst_id_lst csi_datastructures_pub.id_tbl;
5448:
5449: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 5446: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;

5442: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5443: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5444: l_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5445: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5446: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5447: l_inst_id_lst csi_datastructures_pub.id_tbl;
5448:
5449: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
5450: l_msg_count number;

Line 5447: l_inst_id_lst csi_datastructures_pub.id_tbl;

5443: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5444: l_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5445: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5446: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5447: l_inst_id_lst csi_datastructures_pub.id_tbl;
5448:
5449: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
5450: l_msg_count number;
5451: l_msg_data varchar2(2000);

Line 5530: px_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

5526:
5527: PROCEDURE decrement_inventory_instances(
5528: p_item_attrib_rec IN item_attributes_rec,
5529: p_mtl_txn_tbl IN OUT NOCOPY mtl_txn_tbl,
5530: px_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
5531: x_return_status OUT NOCOPY varchar2)
5532: IS
5533: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
5534: BEGIN

Line 6174: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,

6170: --
6171: PROCEDURE process_cz_txn_details(
6172: p_config_session_keys IN csi_utility_grp.config_session_keys,
6173: p_instance_id IN number,
6174: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
6175: x_return_status OUT NOCOPY varchar2)
6176: IS
6177:
6178: l_source_hdr_rec source_header_rec;

Line 6182: l_csi_txn_rec csi_datastructures_pub.transaction_rec;

6178: l_source_hdr_rec source_header_rec;
6179: l_source_line_rec source_line_rec;
6180: l_src_instance_key csi_utility_grp.config_instance_key;
6181:
6182: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
6183:
6184: l_tl_rec csi_t_datastructures_grp.txn_line_rec;
6185: l_td_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
6186: l_pd_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

Line 6191: l_pr_tbl csi_datastructures_pub.pricing_attribs_tbl;

6187: l_pa_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
6188: l_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;
6189: l_ea_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
6190: l_ir_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
6191: l_pr_tbl csi_datastructures_pub.pricing_attribs_tbl;
6192: l_sy_tbl csi_t_datastructures_grp.txn_systems_tbl;
6193:
6194: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
6195: l_return_message varchar2(2000);