APPS.CSI_ORDER_SHIP_PUB dependencies on CSI_DATASTRUCTURES_PUB

Line 50: l_error_rec csi_datastructures_pub.transaction_error_rec;

46: l_bypass varchar2(1);
47:
48: l_error_code number;
49: l_message_id number;
50: l_error_rec csi_datastructures_pub.transaction_error_rec;
51:
52: BEGIN
53:
54: api_log('process_ato_options');

Line 495: px_trx_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec)

491: PROCEDURE order_shipment(
492: p_mtl_transaction_id IN number,
493: p_message_id IN number,
494: x_return_status OUT NOCOPY varchar2,
495: px_trx_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec)
496: IS
497:
498: l_trx_detail_exist boolean := FALSE;
499: l_copy_trx_detail_exist boolean := FALSE;

Line 512: x_pricing_attb_tbl csi_datastructures_pub.pricing_attribs_tbl;

508: x_msg_data varchar2(2000);
509:
510: x_order_shipment_tbl order_shipment_tbl;
511: x_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec ;
512: x_pricing_attb_tbl csi_datastructures_pub.pricing_attribs_tbl;
513:
514: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
515: l_txn_line_dtl_query_rec csi_t_datastructures_grp.txn_line_detail_query_rec;
516: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;

Line 535: l_trx_rec csi_datastructures_pub.transaction_rec;

531: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
532:
533: l_src_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
534: l_new_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
535: l_trx_rec csi_datastructures_pub.transaction_rec;
536:
537: l_copy_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
538:
539: x_trx_sub_type_rec txn_sub_type_rec;

Line 550: l_error_rec csi_datastructures_pub.transaction_error_rec;

546: l_msg_data varchar2(2000);
547: l_temp_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
548: l_t_ii_indx NUMBER := 0;
549:
550: l_error_rec csi_datastructures_pub.transaction_error_rec;
551: l_parent_line_qty NUMBER := fnd_api.g_miss_num;
552: l_literal1 VARCHAR2(30) ;
553: l_literal2 VARCHAR2(30) ;
554: l_source_header_rec csi_interface_pkg.source_header_rec;

Line 1344: p_trx_rec IN csi_datastructures_pub.transaction_rec,

1340:
1341: PROCEDURE process_non_source(
1342: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
1343: p_call_contracts IN varchar2 := fnd_api.g_true,
1344: p_trx_rec IN csi_datastructures_pub.transaction_rec,
1345: x_return_status OUT NOCOPY varchar2)
1346: IS
1347:
1348: l_trx_rec csi_datastructures_pub.transaction_rec;

Line 1348: l_trx_rec csi_datastructures_pub.transaction_rec;

1344: p_trx_rec IN csi_datastructures_pub.transaction_rec,
1345: x_return_status OUT NOCOPY varchar2)
1346: IS
1347:
1348: l_trx_rec csi_datastructures_pub.transaction_rec;
1349:
1350: l_ns_instance_rec csi_datastructures_pub.instance_rec;
1351: l_ns_party_tbl csi_datastructures_pub.party_tbl;
1352: l_ns_party_acct_tbl csi_datastructures_pub.party_account_tbl;

Line 1350: l_ns_instance_rec csi_datastructures_pub.instance_rec;

1346: IS
1347:
1348: l_trx_rec csi_datastructures_pub.transaction_rec;
1349:
1350: l_ns_instance_rec csi_datastructures_pub.instance_rec;
1351: l_ns_party_tbl csi_datastructures_pub.party_tbl;
1352: l_ns_party_acct_tbl csi_datastructures_pub.party_account_tbl;
1353: l_ns_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
1354: l_ns_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 1351: l_ns_party_tbl csi_datastructures_pub.party_tbl;

1347:
1348: l_trx_rec csi_datastructures_pub.transaction_rec;
1349:
1350: l_ns_instance_rec csi_datastructures_pub.instance_rec;
1351: l_ns_party_tbl csi_datastructures_pub.party_tbl;
1352: l_ns_party_acct_tbl csi_datastructures_pub.party_account_tbl;
1353: l_ns_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
1354: l_ns_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1355: l_ns_org_units_tbl csi_datastructures_pub.organization_units_tbl;

Line 1352: l_ns_party_acct_tbl csi_datastructures_pub.party_account_tbl;

1348: l_trx_rec csi_datastructures_pub.transaction_rec;
1349:
1350: l_ns_instance_rec csi_datastructures_pub.instance_rec;
1351: l_ns_party_tbl csi_datastructures_pub.party_tbl;
1352: l_ns_party_acct_tbl csi_datastructures_pub.party_account_tbl;
1353: l_ns_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
1354: l_ns_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1355: l_ns_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1356: l_ns_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

Line 1353: l_ns_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

1349:
1350: l_ns_instance_rec csi_datastructures_pub.instance_rec;
1351: l_ns_party_tbl csi_datastructures_pub.party_tbl;
1352: l_ns_party_acct_tbl csi_datastructures_pub.party_account_tbl;
1353: l_ns_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
1354: l_ns_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1355: l_ns_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1356: l_ns_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1357: l_ns_inst_id_lst csi_datastructures_pub.id_tbl;

Line 1354: l_ns_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

1350: l_ns_instance_rec csi_datastructures_pub.instance_rec;
1351: l_ns_party_tbl csi_datastructures_pub.party_tbl;
1352: l_ns_party_acct_tbl csi_datastructures_pub.party_account_tbl;
1353: l_ns_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
1354: l_ns_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1355: l_ns_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1356: l_ns_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1357: l_ns_inst_id_lst csi_datastructures_pub.id_tbl;
1358:

Line 1355: l_ns_org_units_tbl csi_datastructures_pub.organization_units_tbl;

1351: l_ns_party_tbl csi_datastructures_pub.party_tbl;
1352: l_ns_party_acct_tbl csi_datastructures_pub.party_account_tbl;
1353: l_ns_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
1354: l_ns_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1355: l_ns_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1356: l_ns_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1357: l_ns_inst_id_lst csi_datastructures_pub.id_tbl;
1358:
1359: l_ii_relation_code varchar2(30);

Line 1356: l_ns_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

1352: l_ns_party_acct_tbl csi_datastructures_pub.party_account_tbl;
1353: l_ns_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
1354: l_ns_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1355: l_ns_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1356: l_ns_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1357: l_ns_inst_id_lst csi_datastructures_pub.id_tbl;
1358:
1359: l_ii_relation_code varchar2(30);
1360: l_location_code varchar2(30);

Line 1357: l_ns_inst_id_lst csi_datastructures_pub.id_tbl;

1353: l_ns_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
1354: l_ns_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1355: l_ns_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1356: l_ns_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1357: l_ns_inst_id_lst csi_datastructures_pub.id_tbl;
1358:
1359: l_ii_relation_code varchar2(30);
1360: l_location_code varchar2(30);
1361: l_serial_number varchar2(80);

Line 1363: l_exp_instance_id_lst csi_datastructures_pub.id_tbl;

1359: l_ii_relation_code varchar2(30);
1360: l_location_code varchar2(30);
1361: l_serial_number varchar2(80);
1362: l_active_end_date date;
1363: l_exp_instance_id_lst csi_datastructures_pub.id_tbl;
1364: l_exp_instance_rec csi_datastructures_pub.instance_rec;
1365:
1366: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1367: l_msg_count number;

Line 1364: l_exp_instance_rec csi_datastructures_pub.instance_rec;

1360: l_location_code varchar2(30);
1361: l_serial_number varchar2(80);
1362: l_active_end_date date;
1363: l_exp_instance_id_lst csi_datastructures_pub.id_tbl;
1364: l_exp_instance_rec csi_datastructures_pub.instance_rec;
1365:
1366: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1367: l_msg_count number;
1368: l_msg_data varchar2(2000);

Line 1635: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

1631: PROCEDURE get_order_shipment_rec(
1632: p_mtl_transaction_id IN NUMBER,
1633: p_order_line_rec IN order_line_rec,
1634: p_txn_sub_type_rec IN txn_sub_type_rec,
1635: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
1636: x_order_shipment_tbl OUT NOCOPY order_shipment_tbl,
1637: px_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,
1638: x_return_status OUT NOCOPY varchar2)
1639: IS

Line 1637: px_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,

1633: p_order_line_rec IN order_line_rec,
1634: p_txn_sub_type_rec IN txn_sub_type_rec,
1635: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
1636: x_order_shipment_tbl OUT NOCOPY order_shipment_tbl,
1637: px_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,
1638: x_return_status OUT NOCOPY varchar2)
1639: IS
1640:
1641: l_party_tbl csi_datastructures_pub.party_tbl;

Line 1641: l_party_tbl csi_datastructures_pub.party_tbl;

1637: px_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,
1638: x_return_status OUT NOCOPY varchar2)
1639: IS
1640:
1641: l_party_tbl csi_datastructures_pub.party_tbl;
1642: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
1643: l_party_query_rec csi_datastructures_pub.party_query_rec;
1644: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1645: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;

Line 1642: l_party_account_tbl csi_datastructures_pub.party_account_tbl;

1638: x_return_status OUT NOCOPY varchar2)
1639: IS
1640:
1641: l_party_tbl csi_datastructures_pub.party_tbl;
1642: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
1643: l_party_query_rec csi_datastructures_pub.party_query_rec;
1644: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1645: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;
1646: l_ext_attrib_val_tabl csi_datastructures_pub.extend_attrib_values_tbl;

Line 1643: l_party_query_rec csi_datastructures_pub.party_query_rec;

1639: IS
1640:
1641: l_party_tbl csi_datastructures_pub.party_tbl;
1642: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
1643: l_party_query_rec csi_datastructures_pub.party_query_rec;
1644: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1645: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;
1646: l_ext_attrib_val_tabl csi_datastructures_pub.extend_attrib_values_tbl;
1647: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 1644: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;

1640:
1641: l_party_tbl csi_datastructures_pub.party_tbl;
1642: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
1643: l_party_query_rec csi_datastructures_pub.party_query_rec;
1644: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1645: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;
1646: l_ext_attrib_val_tabl csi_datastructures_pub.extend_attrib_values_tbl;
1647: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
1648: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;

Line 1645: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;

1641: l_party_tbl csi_datastructures_pub.party_tbl;
1642: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
1643: l_party_query_rec csi_datastructures_pub.party_query_rec;
1644: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1645: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;
1646: l_ext_attrib_val_tabl csi_datastructures_pub.extend_attrib_values_tbl;
1647: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
1648: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1649: l_inst_query_rec csi_datastructures_pub.instance_query_rec;

Line 1646: l_ext_attrib_val_tabl csi_datastructures_pub.extend_attrib_values_tbl;

1642: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
1643: l_party_query_rec csi_datastructures_pub.party_query_rec;
1644: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1645: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;
1646: l_ext_attrib_val_tabl csi_datastructures_pub.extend_attrib_values_tbl;
1647: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
1648: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1649: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
1650:

Line 1647: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

1643: l_party_query_rec csi_datastructures_pub.party_query_rec;
1644: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1645: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;
1646: l_ext_attrib_val_tabl csi_datastructures_pub.extend_attrib_values_tbl;
1647: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
1648: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1649: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
1650:
1651: -- Added a column reservable_type from mtl_systems_items for negative quantity check.

Line 1648: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;

1644: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1645: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;
1646: l_ext_attrib_val_tabl csi_datastructures_pub.extend_attrib_values_tbl;
1647: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
1648: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1649: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
1650:
1651: -- Added a column reservable_type from mtl_systems_items for negative quantity check.
1652: l_cre_instance_rec csi_datastructures_pub.instance_rec;

Line 1649: l_inst_query_rec csi_datastructures_pub.instance_query_rec;

1645: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;
1646: l_ext_attrib_val_tabl csi_datastructures_pub.extend_attrib_values_tbl;
1647: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
1648: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1649: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
1650:
1651: -- Added a column reservable_type from mtl_systems_items for negative quantity check.
1652: l_cre_instance_rec csi_datastructures_pub.instance_rec;
1653: l_cre_party_tbl csi_datastructures_pub.party_tbl;

Line 1652: l_cre_instance_rec csi_datastructures_pub.instance_rec;

1648: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1649: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
1650:
1651: -- Added a column reservable_type from mtl_systems_items for negative quantity check.
1652: l_cre_instance_rec csi_datastructures_pub.instance_rec;
1653: l_cre_party_tbl csi_datastructures_pub.party_tbl;
1654: l_cre_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1655: l_cre_party_acct_tbl csi_datastructures_pub.party_account_tbl;
1656: l_cre_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 1653: l_cre_party_tbl csi_datastructures_pub.party_tbl;

1649: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
1650:
1651: -- Added a column reservable_type from mtl_systems_items for negative quantity check.
1652: l_cre_instance_rec csi_datastructures_pub.instance_rec;
1653: l_cre_party_tbl csi_datastructures_pub.party_tbl;
1654: l_cre_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1655: l_cre_party_acct_tbl csi_datastructures_pub.party_account_tbl;
1656: l_cre_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
1657: l_cre_org_units_tbl csi_datastructures_pub.organization_units_tbl;

Line 1654: l_cre_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

1650:
1651: -- Added a column reservable_type from mtl_systems_items for negative quantity check.
1652: l_cre_instance_rec csi_datastructures_pub.instance_rec;
1653: l_cre_party_tbl csi_datastructures_pub.party_tbl;
1654: l_cre_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1655: l_cre_party_acct_tbl csi_datastructures_pub.party_account_tbl;
1656: l_cre_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
1657: l_cre_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1658: l_cre_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

Line 1655: l_cre_party_acct_tbl csi_datastructures_pub.party_account_tbl;

1651: -- Added a column reservable_type from mtl_systems_items for negative quantity check.
1652: l_cre_instance_rec csi_datastructures_pub.instance_rec;
1653: l_cre_party_tbl csi_datastructures_pub.party_tbl;
1654: l_cre_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1655: l_cre_party_acct_tbl csi_datastructures_pub.party_account_tbl;
1656: l_cre_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
1657: l_cre_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1658: l_cre_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1659: l_trx_rec csi_datastructures_pub.transaction_rec;

Line 1656: l_cre_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

1652: l_cre_instance_rec csi_datastructures_pub.instance_rec;
1653: l_cre_party_tbl csi_datastructures_pub.party_tbl;
1654: l_cre_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1655: l_cre_party_acct_tbl csi_datastructures_pub.party_account_tbl;
1656: l_cre_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
1657: l_cre_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1658: l_cre_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1659: l_trx_rec csi_datastructures_pub.transaction_rec;
1660:

Line 1657: l_cre_org_units_tbl csi_datastructures_pub.organization_units_tbl;

1653: l_cre_party_tbl csi_datastructures_pub.party_tbl;
1654: l_cre_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1655: l_cre_party_acct_tbl csi_datastructures_pub.party_account_tbl;
1656: l_cre_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
1657: l_cre_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1658: l_cre_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1659: l_trx_rec csi_datastructures_pub.transaction_rec;
1660:
1661: -- Added for updating instance to ZERO

Line 1658: l_cre_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

1654: l_cre_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1655: l_cre_party_acct_tbl csi_datastructures_pub.party_account_tbl;
1656: l_cre_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
1657: l_cre_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1658: l_cre_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1659: l_trx_rec csi_datastructures_pub.transaction_rec;
1660:
1661: -- Added for updating instance to ZERO
1662: l_zero_instance_rec csi_datastructures_pub.instance_rec;

Line 1659: l_trx_rec csi_datastructures_pub.transaction_rec;

1655: l_cre_party_acct_tbl csi_datastructures_pub.party_account_tbl;
1656: l_cre_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
1657: l_cre_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1658: l_cre_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1659: l_trx_rec csi_datastructures_pub.transaction_rec;
1660:
1661: -- Added for updating instance to ZERO
1662: l_zero_instance_rec csi_datastructures_pub.instance_rec;
1663: l_zero_parties_tbl csi_datastructures_pub.party_tbl;

Line 1662: l_zero_instance_rec csi_datastructures_pub.instance_rec;

1658: l_cre_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1659: l_trx_rec csi_datastructures_pub.transaction_rec;
1660:
1661: -- Added for updating instance to ZERO
1662: l_zero_instance_rec csi_datastructures_pub.instance_rec;
1663: l_zero_parties_tbl csi_datastructures_pub.party_tbl;
1664: l_zero_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1665: l_zero_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1666: l_zero_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 1663: l_zero_parties_tbl csi_datastructures_pub.party_tbl;

1659: l_trx_rec csi_datastructures_pub.transaction_rec;
1660:
1661: -- Added for updating instance to ZERO
1662: l_zero_instance_rec csi_datastructures_pub.instance_rec;
1663: l_zero_parties_tbl csi_datastructures_pub.party_tbl;
1664: l_zero_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1665: l_zero_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1666: l_zero_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1667: l_zero_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 1664: l_zero_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

1660:
1661: -- Added for updating instance to ZERO
1662: l_zero_instance_rec csi_datastructures_pub.instance_rec;
1663: l_zero_parties_tbl csi_datastructures_pub.party_tbl;
1664: l_zero_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1665: l_zero_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1666: l_zero_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1667: l_zero_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1668: l_zero_assets_tbl csi_datastructures_pub.instance_asset_tbl;

Line 1665: l_zero_org_units_tbl csi_datastructures_pub.organization_units_tbl;

1661: -- Added for updating instance to ZERO
1662: l_zero_instance_rec csi_datastructures_pub.instance_rec;
1663: l_zero_parties_tbl csi_datastructures_pub.party_tbl;
1664: l_zero_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1665: l_zero_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1666: l_zero_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1667: l_zero_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1668: l_zero_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1669: l_inst_id_lst csi_datastructures_pub.id_tbl;

Line 1666: l_zero_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

1662: l_zero_instance_rec csi_datastructures_pub.instance_rec;
1663: l_zero_parties_tbl csi_datastructures_pub.party_tbl;
1664: l_zero_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1665: l_zero_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1666: l_zero_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1667: l_zero_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1668: l_zero_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1669: l_inst_id_lst csi_datastructures_pub.id_tbl;
1670:

Line 1667: l_zero_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

1663: l_zero_parties_tbl csi_datastructures_pub.party_tbl;
1664: l_zero_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1665: l_zero_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1666: l_zero_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1667: l_zero_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1668: l_zero_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1669: l_inst_id_lst csi_datastructures_pub.id_tbl;
1670:
1671: x_msg_count NUMBER;

Line 1668: l_zero_assets_tbl csi_datastructures_pub.instance_asset_tbl;

1664: l_zero_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1665: l_zero_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1666: l_zero_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1667: l_zero_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1668: l_zero_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1669: l_inst_id_lst csi_datastructures_pub.id_tbl;
1670:
1671: x_msg_count NUMBER;
1672: x_msg_data varchar2(2000);

Line 1669: l_inst_id_lst csi_datastructures_pub.id_tbl;

1665: l_zero_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1666: l_zero_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1667: l_zero_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1668: l_zero_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1669: l_inst_id_lst csi_datastructures_pub.id_tbl;
1670:
1671: x_msg_count NUMBER;
1672: x_msg_data varchar2(2000);
1673: l_party_id NUMBER;

Line 2114: l_cre_party_tbl(1).party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;

2110: l_cre_instance_rec.mfg_serial_number_flag := 'Y';
2111: END IF;
2112:
2113: -- Building Party Rec for creating Instance with missing Quantity
2114: l_cre_party_tbl(1).party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
2115:
2116: l_cre_party_tbl(1).party_source_table := 'HZ_PARTIES';
2117: l_cre_party_tbl(1).relationship_type_code := 'OWNER';
2118: l_cre_party_tbl(1).contact_flag := 'N';

Line 2308: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

2304: p_order_line_rec IN OUT NOCOPY order_line_rec,
2305: p_txn_sub_type_rec IN txn_sub_type_rec,
2306: p_trx_detail_exist IN boolean,
2307: p_trackable_parent IN boolean,
2308: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
2309: x_order_shipment_tbl OUT NOCOPY order_shipment_tbl,
2310: px_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,
2311: x_return_status OUT NOCOPY varchar2)
2312: IS

Line 2310: px_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,

2306: p_trx_detail_exist IN boolean,
2307: p_trackable_parent IN boolean,
2308: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
2309: x_order_shipment_tbl OUT NOCOPY order_shipment_tbl,
2310: px_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,
2311: x_return_status OUT NOCOPY varchar2)
2312: IS
2313: x_msg_count number;
2314: x_msg_data varchar2(2000);

Line 2348: l_trx_rec csi_datastructures_pub.transaction_rec;

2344: l_msg_count number;
2345: l_msg_data varchar2(2000);
2346:
2347: -- Included Transaction rec as part of fix for Bug 2767338
2348: l_trx_rec csi_datastructures_pub.transaction_rec;
2349:
2350: ---Added (Start) for m-to-m enhancements
2351: l_temp_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2352: ---Added (End) for m-to-m enhancements

Line 3731: p_trx_rec in OUT NOCOPY csi_datastructures_pub.transaction_rec,

3727:
3728: PROCEDURE decrement_source_instance(
3729: p_instance_id in number,
3730: p_quantity in number,
3731: p_trx_rec in OUT NOCOPY csi_datastructures_pub.transaction_rec,
3732: x_return_status OUT NOCOPY varchar2)
3733: IS
3734:
3735: l_instance_rec csi_datastructures_pub.instance_rec;

Line 3735: l_instance_rec csi_datastructures_pub.instance_rec;

3731: p_trx_rec in OUT NOCOPY csi_datastructures_pub.transaction_rec,
3732: x_return_status OUT NOCOPY varchar2)
3733: IS
3734:
3735: l_instance_rec csi_datastructures_pub.instance_rec;
3736: l_party_tbl csi_datastructures_pub.party_tbl;
3737: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
3738: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
3739: l_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 3736: l_party_tbl csi_datastructures_pub.party_tbl;

3732: x_return_status OUT NOCOPY varchar2)
3733: IS
3734:
3735: l_instance_rec csi_datastructures_pub.instance_rec;
3736: l_party_tbl csi_datastructures_pub.party_tbl;
3737: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
3738: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
3739: l_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3740: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 3737: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;

3733: IS
3734:
3735: l_instance_rec csi_datastructures_pub.instance_rec;
3736: l_party_tbl csi_datastructures_pub.party_tbl;
3737: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
3738: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
3739: l_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3740: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
3741: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;

Line 3738: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

3734:
3735: l_instance_rec csi_datastructures_pub.instance_rec;
3736: l_party_tbl csi_datastructures_pub.party_tbl;
3737: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
3738: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
3739: l_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3740: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
3741: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
3742: l_inst_id_lst csi_datastructures_pub.id_tbl;

Line 3739: l_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

3735: l_instance_rec csi_datastructures_pub.instance_rec;
3736: l_party_tbl csi_datastructures_pub.party_tbl;
3737: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
3738: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
3739: l_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3740: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
3741: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
3742: l_inst_id_lst csi_datastructures_pub.id_tbl;
3743:

Line 3740: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

3736: l_party_tbl csi_datastructures_pub.party_tbl;
3737: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
3738: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
3739: l_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3740: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
3741: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
3742: l_inst_id_lst csi_datastructures_pub.id_tbl;
3743:
3744: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 3741: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;

3737: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
3738: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
3739: l_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3740: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
3741: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
3742: l_inst_id_lst csi_datastructures_pub.id_tbl;
3743:
3744: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3745: l_msg_count number;

Line 3742: l_inst_id_lst csi_datastructures_pub.id_tbl;

3738: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
3739: l_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3740: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
3741: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
3742: l_inst_id_lst csi_datastructures_pub.id_tbl;
3743:
3744: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3745: l_msg_count number;
3746: l_msg_data varchar2(2000);

Line 3835: p_instance_hdr_rec IN csi_datastructures_pub.instance_header_rec,

3831:
3832: END dump_customer_products;
3833:
3834: PROCEDURE make_non_hdr_rec(
3835: p_instance_hdr_rec IN csi_datastructures_pub.instance_header_rec,
3836: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,
3837: x_return_status OUT NOCOPY varchar2)
3838: IS
3839:

Line 3836: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,

3832: END dump_customer_products;
3833:
3834: PROCEDURE make_non_hdr_rec(
3835: p_instance_hdr_rec IN csi_datastructures_pub.instance_header_rec,
3836: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,
3837: x_return_status OUT NOCOPY varchar2)
3838: IS
3839:
3840: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;

Line 3840: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;

3836: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,
3837: x_return_status OUT NOCOPY varchar2)
3838: IS
3839:
3840: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
3841: l_instance_tbl csi_datastructures_pub.instance_tbl;
3842:
3843: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3844:

Line 3841: l_instance_tbl csi_datastructures_pub.instance_tbl;

3837: x_return_status OUT NOCOPY varchar2)
3838: IS
3839:
3840: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
3841: l_instance_tbl csi_datastructures_pub.instance_tbl;
3842:
3843: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3844:
3845: BEGIN

Line 3875: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

3871: p_instance_id IN number,
3872: p_qty_ratio IN number,
3873: p_qty_completed IN number,
3874: p_organization_id IN number,
3875: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
3876: x_splitted_instances OUT NOCOPY csi_datastructures_pub.instance_tbl,
3877: x_return_status OUT NOCOPY varchar2)
3878: IS
3879:

Line 3876: x_splitted_instances OUT NOCOPY csi_datastructures_pub.instance_tbl,

3872: p_qty_ratio IN number,
3873: p_qty_completed IN number,
3874: p_organization_id IN number,
3875: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
3876: x_splitted_instances OUT NOCOPY csi_datastructures_pub.instance_tbl,
3877: x_return_status OUT NOCOPY varchar2)
3878: IS
3879:
3880: l_qty_remaining number;

Line 3882: l_init_instance_rec csi_datastructures_pub.instance_rec;

3878: IS
3879:
3880: l_qty_remaining number;
3881:
3882: l_init_instance_rec csi_datastructures_pub.instance_rec;
3883:
3884: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3885: l_msg_data varchar2(2000);
3886: l_msg_count number;

Line 3890: l_splitted_instances csi_datastructures_pub.instance_tbl;

3886: l_msg_count number;
3887:
3888: l_split_flag boolean := FALSE;
3889:
3890: l_splitted_instances csi_datastructures_pub.instance_tbl;
3891: l_s_ind binary_integer;
3892:
3893: -- get_item_instance_details variables
3894: l_g_instance_rec csi_datastructures_pub.instance_header_rec;

Line 3894: l_g_instance_rec csi_datastructures_pub.instance_header_rec;

3890: l_splitted_instances csi_datastructures_pub.instance_tbl;
3891: l_s_ind binary_integer;
3892:
3893: -- get_item_instance_details variables
3894: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
3895: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
3896: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
3897: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
3898: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 3895: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;

3891: l_s_ind binary_integer;
3892:
3893: -- get_item_instance_details variables
3894: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
3895: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
3896: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
3897: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
3898: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
3899: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 3896: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;

3892:
3893: -- get_item_instance_details variables
3894: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
3895: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
3896: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
3897: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
3898: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
3899: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3900: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;

Line 3897: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;

3893: -- get_item_instance_details variables
3894: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
3895: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
3896: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
3897: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
3898: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
3899: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3900: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
3901: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;

Line 3898: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;

3894: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
3895: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
3896: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
3897: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
3898: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
3899: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3900: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
3901: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
3902: l_g_time_stamp date;

Line 3899: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;

3895: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
3896: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
3897: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
3898: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
3899: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3900: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
3901: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
3902: l_g_time_stamp date;
3903:

Line 3900: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;

3896: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
3897: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
3898: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
3899: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3900: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
3901: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
3902: l_g_time_stamp date;
3903:
3904: -- make_non_hdr variables

Line 3901: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;

3897: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
3898: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
3899: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3900: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
3901: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
3902: l_g_time_stamp date;
3903:
3904: -- make_non_hdr variables
3905: l_instance_rec csi_datastructures_pub.instance_rec;

Line 3905: l_instance_rec csi_datastructures_pub.instance_rec;

3901: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
3902: l_g_time_stamp date;
3903:
3904: -- make_non_hdr variables
3905: l_instance_rec csi_datastructures_pub.instance_rec;
3906:
3907: -- update_item_instance variables
3908: l_u_instance_rec csi_datastructures_pub.instance_rec;
3909: l_u_parties_tbl csi_datastructures_pub.party_tbl;

Line 3908: l_u_instance_rec csi_datastructures_pub.instance_rec;

3904: -- make_non_hdr variables
3905: l_instance_rec csi_datastructures_pub.instance_rec;
3906:
3907: -- update_item_instance variables
3908: l_u_instance_rec csi_datastructures_pub.instance_rec;
3909: l_u_parties_tbl csi_datastructures_pub.party_tbl;
3910: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
3911: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
3912: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 3909: l_u_parties_tbl csi_datastructures_pub.party_tbl;

3905: l_instance_rec csi_datastructures_pub.instance_rec;
3906:
3907: -- update_item_instance variables
3908: l_u_instance_rec csi_datastructures_pub.instance_rec;
3909: l_u_parties_tbl csi_datastructures_pub.party_tbl;
3910: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
3911: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
3912: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3913: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 3910: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

3906:
3907: -- update_item_instance variables
3908: l_u_instance_rec csi_datastructures_pub.instance_rec;
3909: l_u_parties_tbl csi_datastructures_pub.party_tbl;
3910: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
3911: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
3912: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3913: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
3914: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;

Line 3911: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;

3907: -- update_item_instance variables
3908: l_u_instance_rec csi_datastructures_pub.instance_rec;
3909: l_u_parties_tbl csi_datastructures_pub.party_tbl;
3910: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
3911: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
3912: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3913: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
3914: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
3915: l_u_instance_ids_list csi_datastructures_pub.id_tbl;

Line 3912: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

3908: l_u_instance_rec csi_datastructures_pub.instance_rec;
3909: l_u_parties_tbl csi_datastructures_pub.party_tbl;
3910: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
3911: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
3912: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3913: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
3914: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
3915: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
3916:

Line 3913: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

3909: l_u_parties_tbl csi_datastructures_pub.party_tbl;
3910: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
3911: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
3912: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3913: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
3914: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
3915: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
3916:
3917: -- create_item_instance varaibles

Line 3914: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;

3910: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
3911: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
3912: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3913: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
3914: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
3915: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
3916:
3917: -- create_item_instance varaibles
3918: l_c_instance_rec csi_datastructures_pub.instance_rec;

Line 3915: l_u_instance_ids_list csi_datastructures_pub.id_tbl;

3911: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
3912: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3913: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
3914: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
3915: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
3916:
3917: -- create_item_instance varaibles
3918: l_c_instance_rec csi_datastructures_pub.instance_rec;
3919: l_c_parties_tbl csi_datastructures_pub.party_tbl;

Line 3918: l_c_instance_rec csi_datastructures_pub.instance_rec;

3914: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
3915: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
3916:
3917: -- create_item_instance varaibles
3918: l_c_instance_rec csi_datastructures_pub.instance_rec;
3919: l_c_parties_tbl csi_datastructures_pub.party_tbl;
3920: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
3921: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
3922: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 3919: l_c_parties_tbl csi_datastructures_pub.party_tbl;

3915: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
3916:
3917: -- create_item_instance varaibles
3918: l_c_instance_rec csi_datastructures_pub.instance_rec;
3919: l_c_parties_tbl csi_datastructures_pub.party_tbl;
3920: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
3921: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
3922: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3923: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 3920: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

3916:
3917: -- create_item_instance varaibles
3918: l_c_instance_rec csi_datastructures_pub.instance_rec;
3919: l_c_parties_tbl csi_datastructures_pub.party_tbl;
3920: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
3921: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
3922: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3923: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
3924: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;

Line 3921: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;

3917: -- create_item_instance varaibles
3918: l_c_instance_rec csi_datastructures_pub.instance_rec;
3919: l_c_parties_tbl csi_datastructures_pub.party_tbl;
3920: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
3921: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
3922: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3923: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
3924: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;
3925: c_pa_ind binary_integer;

Line 3922: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

3918: l_c_instance_rec csi_datastructures_pub.instance_rec;
3919: l_c_parties_tbl csi_datastructures_pub.party_tbl;
3920: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
3921: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
3922: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3923: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
3924: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;
3925: c_pa_ind binary_integer;
3926:

Line 3923: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

3919: l_c_parties_tbl csi_datastructures_pub.party_tbl;
3920: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
3921: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
3922: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3923: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
3924: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;
3925: c_pa_ind binary_integer;
3926:
3927: BEGIN

Line 3924: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;

3920: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
3921: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
3922: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3923: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
3924: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;
3925: c_pa_ind binary_integer;
3926:
3927: BEGIN
3928:

Line 4146: p_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

4142:
4143: PROCEDURE convert_wip_instance_to_cp(
4144: p_instance_id IN number,
4145: p_line_id IN number,
4146: p_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
4147: x_return_status OUT NOCOPY varchar2)
4148: IS
4149:
4150: l_party_site_id number;

Line 4160: l_u_instance_rec csi_datastructures_pub.instance_rec;

4156:
4157: l_location_type_code varchar2(80);
4158: l_inst_object_ver_num number;
4159:
4160: l_u_instance_rec csi_datastructures_pub.instance_rec;
4161: l_u_party_tbl csi_datastructures_pub.party_tbl;
4162: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4163: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4164: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 4161: l_u_party_tbl csi_datastructures_pub.party_tbl;

4157: l_location_type_code varchar2(80);
4158: l_inst_object_ver_num number;
4159:
4160: l_u_instance_rec csi_datastructures_pub.instance_rec;
4161: l_u_party_tbl csi_datastructures_pub.party_tbl;
4162: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4163: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4164: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4165: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 4162: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;

4158: l_inst_object_ver_num number;
4159:
4160: l_u_instance_rec csi_datastructures_pub.instance_rec;
4161: l_u_party_tbl csi_datastructures_pub.party_tbl;
4162: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4163: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4164: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4165: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4166: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;

Line 4163: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

4159:
4160: l_u_instance_rec csi_datastructures_pub.instance_rec;
4161: l_u_party_tbl csi_datastructures_pub.party_tbl;
4162: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4163: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4164: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4165: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4166: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4167: l_u_inst_id_lst csi_datastructures_pub.id_tbl;

Line 4164: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

4160: l_u_instance_rec csi_datastructures_pub.instance_rec;
4161: l_u_party_tbl csi_datastructures_pub.party_tbl;
4162: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4163: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4164: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4165: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4166: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4167: l_u_inst_id_lst csi_datastructures_pub.id_tbl;
4168:

Line 4165: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

4161: l_u_party_tbl csi_datastructures_pub.party_tbl;
4162: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4163: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4164: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4165: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4166: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4167: l_u_inst_id_lst csi_datastructures_pub.id_tbl;
4168:
4169: l_instance_party_id number;

Line 4166: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;

4162: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4163: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4164: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4165: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4166: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4167: l_u_inst_id_lst csi_datastructures_pub.id_tbl;
4168:
4169: l_instance_party_id number;
4170: l_pty_object_ver_num number;

Line 4167: l_u_inst_id_lst csi_datastructures_pub.id_tbl;

4163: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4164: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4165: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4166: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4167: l_u_inst_id_lst csi_datastructures_pub.id_tbl;
4168:
4169: l_instance_party_id number;
4170: l_pty_object_ver_num number;
4171: l_pa_object_ver_num number;

Line 4342: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,

4338: PROCEDURE get_comp_instances_from_wip(
4339: p_wip_entity_id IN number,
4340: p_organization_id IN number,
4341: p_cps_tbl IN customer_products_tbl,
4342: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
4343: x_iir_tbl OUT nocopy csi_datastructures_pub.ii_relationship_tbl,
4344: x_return_status OUT nocopy varchar2)
4345: IS
4346:

Line 4343: x_iir_tbl OUT nocopy csi_datastructures_pub.ii_relationship_tbl,

4339: p_wip_entity_id IN number,
4340: p_organization_id IN number,
4341: p_cps_tbl IN customer_products_tbl,
4342: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
4343: x_iir_tbl OUT nocopy csi_datastructures_pub.ii_relationship_tbl,
4344: x_return_status OUT nocopy varchar2)
4345: IS
4346:
4347: l_cps_tbl customer_products_tbl;

Line 4350: l_iir_tbl csi_datastructures_pub.ii_relationship_tbl;

4346:
4347: l_cps_tbl customer_products_tbl;
4348: l_qty_per_assy number := 0;
4349: l_iir_ind binary_integer := 0;
4350: l_iir_tbl csi_datastructures_pub.ii_relationship_tbl;
4351: l_serial_code number;
4352:
4353: l_splitted_instances csi_datastructures_pub.instance_tbl;
4354: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 4353: l_splitted_instances csi_datastructures_pub.instance_tbl;

4349: l_iir_ind binary_integer := 0;
4350: l_iir_tbl csi_datastructures_pub.ii_relationship_tbl;
4351: l_serial_code number;
4352:
4353: l_splitted_instances csi_datastructures_pub.instance_tbl;
4354: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4355:
4356: CURSOR req_cur IS
4357: SELECT wip.inventory_item_id,

Line 4392: p_iir_tbl IN csi_datastructures_pub.ii_relationship_tbl)

4388: AND quantity <= p_qty_per_assy;
4389:
4390: FUNCTION already_allocated(
4391: p_subject_id IN number,
4392: p_iir_tbl IN csi_datastructures_pub.ii_relationship_tbl)
4393: RETURN BOOLEAN
4394: IS
4395: l_allocated boolean := FALSE;
4396: BEGIN

Line 4618: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

4614:
4615:
4616: -- convert txn_systems in to csi_systems
4617: PROCEDURE create_csi_systems(
4618: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
4619: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
4620: px_tld_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
4621: x_return_status OUT NOCOPY varchar2)
4622: IS

Line 4624: l_system_rec csi_datastructures_pub.system_rec;

4620: px_tld_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
4621: x_return_status OUT NOCOPY varchar2)
4622: IS
4623: l_system_exist boolean := FALSE;
4624: l_system_rec csi_datastructures_pub.system_rec;
4625: l_system_id number;
4626:
4627: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4628: l_msg_count number;

Line 4794: p_instance_rec IN csi_datastructures_pub.instance_rec,

4790: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4791: END proc_for_last_mtl_trx ;
4792:
4793: PROCEDURE auto_split_instances(
4794: p_instance_rec IN csi_datastructures_pub.instance_rec,
4795: px_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
4796: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
4797: x_return_status OUT nocopy varchar2)
4798: IS

Line 4795: px_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,

4791: END proc_for_last_mtl_trx ;
4792:
4793: PROCEDURE auto_split_instances(
4794: p_instance_rec IN csi_datastructures_pub.instance_rec,
4795: px_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
4796: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
4797: x_return_status OUT nocopy varchar2)
4798: IS
4799: l_src_instance_rec csi_datastructures_pub.instance_rec;

Line 4796: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,

4792:
4793: PROCEDURE auto_split_instances(
4794: p_instance_rec IN csi_datastructures_pub.instance_rec,
4795: px_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
4796: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
4797: x_return_status OUT nocopy varchar2)
4798: IS
4799: l_src_instance_rec csi_datastructures_pub.instance_rec;
4800: l_instance_tbl csi_datastructures_pub.instance_tbl;

Line 4799: l_src_instance_rec csi_datastructures_pub.instance_rec;

4795: px_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
4796: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
4797: x_return_status OUT nocopy varchar2)
4798: IS
4799: l_src_instance_rec csi_datastructures_pub.instance_rec;
4800: l_instance_tbl csi_datastructures_pub.instance_tbl;
4801: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4802: l_msg_count number;
4803: l_msg_data varchar2(2000);

Line 4800: l_instance_tbl csi_datastructures_pub.instance_tbl;

4796: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
4797: x_return_status OUT nocopy varchar2)
4798: IS
4799: l_src_instance_rec csi_datastructures_pub.instance_rec;
4800: l_instance_tbl csi_datastructures_pub.instance_tbl;
4801: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4802: l_msg_count number;
4803: l_msg_data varchar2(2000);
4804: BEGIN

Line 4877: p_pricing_attribs_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,

4873: p_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
4874: p_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
4875: p_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
4876: p_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
4877: p_pricing_attribs_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
4878: p_order_line_rec IN order_line_rec,
4879: p_trx_rec IN csi_datastructures_pub.transaction_rec,
4880: p_source IN varchar2,
4881: p_validate_only IN varchar2,

Line 4879: p_trx_rec IN csi_datastructures_pub.transaction_rec,

4875: p_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
4876: p_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
4877: p_pricing_attribs_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
4878: p_order_line_rec IN order_line_rec,
4879: p_trx_rec IN csi_datastructures_pub.transaction_rec,
4880: p_source IN varchar2,
4881: p_validate_only IN varchar2,
4882: px_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,
4883: x_return_status OUT NOCOPY varchar2,

Line 4882: px_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,

4878: p_order_line_rec IN order_line_rec,
4879: p_trx_rec IN csi_datastructures_pub.transaction_rec,
4880: p_source IN varchar2,
4881: p_validate_only IN varchar2,
4882: px_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,
4883: x_return_status OUT NOCOPY varchar2,
4884: x_msg_count OUT NOCOPY number,
4885: x_msg_data OUT NOCOPY varchar2)
4886: IS

Line 4900: l_tmp_instance_rec csi_datastructures_pub.instance_rec;

4896: l_order_line_rec order_line_rec;
4897: l_item_control_rec item_control_rec;
4898:
4899: x_trx_sub_type_rec txn_sub_type_rec;
4900: l_tmp_instance_rec csi_datastructures_pub.instance_rec;
4901: l_upd_instance_rec csi_datastructures_pub.instance_rec;
4902: l_upd_txn_rec csi_datastructures_pub.transaction_rec;
4903: l_upd_party_tbl csi_datastructures_pub.party_tbl;
4904: l_upd_party_acct_tbl csi_datastructures_pub.party_account_tbl;

Line 4901: l_upd_instance_rec csi_datastructures_pub.instance_rec;

4897: l_item_control_rec item_control_rec;
4898:
4899: x_trx_sub_type_rec txn_sub_type_rec;
4900: l_tmp_instance_rec csi_datastructures_pub.instance_rec;
4901: l_upd_instance_rec csi_datastructures_pub.instance_rec;
4902: l_upd_txn_rec csi_datastructures_pub.transaction_rec;
4903: l_upd_party_tbl csi_datastructures_pub.party_tbl;
4904: l_upd_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4905: l_upd_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

Line 4902: l_upd_txn_rec csi_datastructures_pub.transaction_rec;

4898:
4899: x_trx_sub_type_rec txn_sub_type_rec;
4900: l_tmp_instance_rec csi_datastructures_pub.instance_rec;
4901: l_upd_instance_rec csi_datastructures_pub.instance_rec;
4902: l_upd_txn_rec csi_datastructures_pub.transaction_rec;
4903: l_upd_party_tbl csi_datastructures_pub.party_tbl;
4904: l_upd_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4905: l_upd_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4906: l_upd_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 4903: l_upd_party_tbl csi_datastructures_pub.party_tbl;

4899: x_trx_sub_type_rec txn_sub_type_rec;
4900: l_tmp_instance_rec csi_datastructures_pub.instance_rec;
4901: l_upd_instance_rec csi_datastructures_pub.instance_rec;
4902: l_upd_txn_rec csi_datastructures_pub.transaction_rec;
4903: l_upd_party_tbl csi_datastructures_pub.party_tbl;
4904: l_upd_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4905: l_upd_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4906: l_upd_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4907: l_upd_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 4904: l_upd_party_acct_tbl csi_datastructures_pub.party_account_tbl;

4900: l_tmp_instance_rec csi_datastructures_pub.instance_rec;
4901: l_upd_instance_rec csi_datastructures_pub.instance_rec;
4902: l_upd_txn_rec csi_datastructures_pub.transaction_rec;
4903: l_upd_party_tbl csi_datastructures_pub.party_tbl;
4904: l_upd_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4905: l_upd_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4906: l_upd_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4907: l_upd_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4908: l_upd_org_units_tbl csi_datastructures_pub.organization_units_tbl;

Line 4905: l_upd_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

4901: l_upd_instance_rec csi_datastructures_pub.instance_rec;
4902: l_upd_txn_rec csi_datastructures_pub.transaction_rec;
4903: l_upd_party_tbl csi_datastructures_pub.party_tbl;
4904: l_upd_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4905: l_upd_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4906: l_upd_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4907: l_upd_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4908: l_upd_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4909: l_inst_id_lst csi_datastructures_pub.id_tbl;

Line 4906: l_upd_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

4902: l_upd_txn_rec csi_datastructures_pub.transaction_rec;
4903: l_upd_party_tbl csi_datastructures_pub.party_tbl;
4904: l_upd_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4905: l_upd_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4906: l_upd_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4907: l_upd_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4908: l_upd_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4909: l_inst_id_lst csi_datastructures_pub.id_tbl;
4910: l_upd_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;

Line 4907: l_upd_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

4903: l_upd_party_tbl csi_datastructures_pub.party_tbl;
4904: l_upd_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4905: l_upd_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4906: l_upd_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4907: l_upd_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4908: l_upd_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4909: l_inst_id_lst csi_datastructures_pub.id_tbl;
4910: l_upd_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
4911:

Line 4908: l_upd_org_units_tbl csi_datastructures_pub.organization_units_tbl;

4904: l_upd_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4905: l_upd_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4906: l_upd_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4907: l_upd_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4908: l_upd_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4909: l_inst_id_lst csi_datastructures_pub.id_tbl;
4910: l_upd_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
4911:
4912: l_upd_so_instance_rec csi_datastructures_pub.instance_rec;

Line 4909: l_inst_id_lst csi_datastructures_pub.id_tbl;

4905: l_upd_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4906: l_upd_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4907: l_upd_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4908: l_upd_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4909: l_inst_id_lst csi_datastructures_pub.id_tbl;
4910: l_upd_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
4911:
4912: l_upd_so_instance_rec csi_datastructures_pub.instance_rec;
4913: l_upd_so_party_tbl csi_datastructures_pub.party_tbl;

Line 4910: l_upd_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;

4906: l_upd_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4907: l_upd_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4908: l_upd_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4909: l_inst_id_lst csi_datastructures_pub.id_tbl;
4910: l_upd_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
4911:
4912: l_upd_so_instance_rec csi_datastructures_pub.instance_rec;
4913: l_upd_so_party_tbl csi_datastructures_pub.party_tbl;
4914: l_upd_so_party_acct_tbl csi_datastructures_pub.party_account_tbl;

Line 4912: l_upd_so_instance_rec csi_datastructures_pub.instance_rec;

4908: l_upd_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4909: l_inst_id_lst csi_datastructures_pub.id_tbl;
4910: l_upd_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
4911:
4912: l_upd_so_instance_rec csi_datastructures_pub.instance_rec;
4913: l_upd_so_party_tbl csi_datastructures_pub.party_tbl;
4914: l_upd_so_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4915: l_upd_so_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4916: l_upd_so_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 4913: l_upd_so_party_tbl csi_datastructures_pub.party_tbl;

4909: l_inst_id_lst csi_datastructures_pub.id_tbl;
4910: l_upd_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
4911:
4912: l_upd_so_instance_rec csi_datastructures_pub.instance_rec;
4913: l_upd_so_party_tbl csi_datastructures_pub.party_tbl;
4914: l_upd_so_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4915: l_upd_so_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4916: l_upd_so_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4917: l_upd_so_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 4914: l_upd_so_party_acct_tbl csi_datastructures_pub.party_account_tbl;

4910: l_upd_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
4911:
4912: l_upd_so_instance_rec csi_datastructures_pub.instance_rec;
4913: l_upd_so_party_tbl csi_datastructures_pub.party_tbl;
4914: l_upd_so_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4915: l_upd_so_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4916: l_upd_so_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4917: l_upd_so_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4918: l_upd_so_org_units_tbl csi_datastructures_pub.organization_units_tbl;

Line 4915: l_upd_so_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

4911:
4912: l_upd_so_instance_rec csi_datastructures_pub.instance_rec;
4913: l_upd_so_party_tbl csi_datastructures_pub.party_tbl;
4914: l_upd_so_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4915: l_upd_so_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4916: l_upd_so_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4917: l_upd_so_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4918: l_upd_so_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4919:

Line 4916: l_upd_so_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

4912: l_upd_so_instance_rec csi_datastructures_pub.instance_rec;
4913: l_upd_so_party_tbl csi_datastructures_pub.party_tbl;
4914: l_upd_so_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4915: l_upd_so_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4916: l_upd_so_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4917: l_upd_so_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4918: l_upd_so_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4919:
4920: l_cre_instance_rec csi_datastructures_pub.instance_rec;

Line 4917: l_upd_so_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

4913: l_upd_so_party_tbl csi_datastructures_pub.party_tbl;
4914: l_upd_so_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4915: l_upd_so_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4916: l_upd_so_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4917: l_upd_so_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4918: l_upd_so_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4919:
4920: l_cre_instance_rec csi_datastructures_pub.instance_rec;
4921: l_cre_txn_rec csi_datastructures_pub.transaction_rec;

Line 4918: l_upd_so_org_units_tbl csi_datastructures_pub.organization_units_tbl;

4914: l_upd_so_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4915: l_upd_so_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4916: l_upd_so_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4917: l_upd_so_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4918: l_upd_so_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4919:
4920: l_cre_instance_rec csi_datastructures_pub.instance_rec;
4921: l_cre_txn_rec csi_datastructures_pub.transaction_rec;
4922: l_cre_party_tbl csi_datastructures_pub.party_tbl;

Line 4920: l_cre_instance_rec csi_datastructures_pub.instance_rec;

4916: l_upd_so_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4917: l_upd_so_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4918: l_upd_so_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4919:
4920: l_cre_instance_rec csi_datastructures_pub.instance_rec;
4921: l_cre_txn_rec csi_datastructures_pub.transaction_rec;
4922: l_cre_party_tbl csi_datastructures_pub.party_tbl;
4923: l_cre_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4924: l_cre_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

Line 4921: l_cre_txn_rec csi_datastructures_pub.transaction_rec;

4917: l_upd_so_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4918: l_upd_so_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4919:
4920: l_cre_instance_rec csi_datastructures_pub.instance_rec;
4921: l_cre_txn_rec csi_datastructures_pub.transaction_rec;
4922: l_cre_party_tbl csi_datastructures_pub.party_tbl;
4923: l_cre_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4924: l_cre_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4925: l_cre_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 4922: l_cre_party_tbl csi_datastructures_pub.party_tbl;

4918: l_upd_so_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4919:
4920: l_cre_instance_rec csi_datastructures_pub.instance_rec;
4921: l_cre_txn_rec csi_datastructures_pub.transaction_rec;
4922: l_cre_party_tbl csi_datastructures_pub.party_tbl;
4923: l_cre_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4924: l_cre_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4925: l_cre_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4926: l_cre_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 4923: l_cre_party_acct_tbl csi_datastructures_pub.party_account_tbl;

4919:
4920: l_cre_instance_rec csi_datastructures_pub.instance_rec;
4921: l_cre_txn_rec csi_datastructures_pub.transaction_rec;
4922: l_cre_party_tbl csi_datastructures_pub.party_tbl;
4923: l_cre_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4924: l_cre_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4925: l_cre_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4926: l_cre_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4927: l_cre_org_units_tbl csi_datastructures_pub.organization_units_tbl;

Line 4924: l_cre_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

4920: l_cre_instance_rec csi_datastructures_pub.instance_rec;
4921: l_cre_txn_rec csi_datastructures_pub.transaction_rec;
4922: l_cre_party_tbl csi_datastructures_pub.party_tbl;
4923: l_cre_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4924: l_cre_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4925: l_cre_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4926: l_cre_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4927: l_cre_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4928: l_cre_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;

Line 4925: l_cre_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

4921: l_cre_txn_rec csi_datastructures_pub.transaction_rec;
4922: l_cre_party_tbl csi_datastructures_pub.party_tbl;
4923: l_cre_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4924: l_cre_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4925: l_cre_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4926: l_cre_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4927: l_cre_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4928: l_cre_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
4929: l_cre_systems_rec csi_datastructures_pub.system_rec;

Line 4926: l_cre_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

4922: l_cre_party_tbl csi_datastructures_pub.party_tbl;
4923: l_cre_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4924: l_cre_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4925: l_cre_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4926: l_cre_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4927: l_cre_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4928: l_cre_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
4929: l_cre_systems_rec csi_datastructures_pub.system_rec;
4930:

Line 4927: l_cre_org_units_tbl csi_datastructures_pub.organization_units_tbl;

4923: l_cre_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4924: l_cre_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4925: l_cre_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4926: l_cre_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4927: l_cre_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4928: l_cre_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
4929: l_cre_systems_rec csi_datastructures_pub.system_rec;
4930:
4931: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;

Line 4928: l_cre_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;

4924: l_cre_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4925: l_cre_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4926: l_cre_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4927: l_cre_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4928: l_cre_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
4929: l_cre_systems_rec csi_datastructures_pub.system_rec;
4930:
4931: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
4932: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;

Line 4929: l_cre_systems_rec csi_datastructures_pub.system_rec;

4925: l_cre_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4926: l_cre_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4927: l_cre_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4928: l_cre_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
4929: l_cre_systems_rec csi_datastructures_pub.system_rec;
4930:
4931: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
4932: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
4933: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

Line 4952: l_old_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

4948:
4949: /* Pricing Attributes variables */
4950: l_old_index NUMBER := 0;
4951: l_new_index NUMBER := 0;
4952: l_old_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4953: l_new_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4954:
4955: /* Extended Attributes variables */
4956: l_ext_old_index NUMBER := 0;

Line 4953: l_new_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

4949: /* Pricing Attributes variables */
4950: l_old_index NUMBER := 0;
4951: l_new_index NUMBER := 0;
4952: l_old_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4953: l_new_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4954:
4955: /* Extended Attributes variables */
4956: l_ext_old_index NUMBER := 0;
4957: l_ext_new_index NUMBER := 0;

Line 4958: l_old_extended_attribs_tbl csi_datastructures_pub.extend_attrib_values_tbl;

4954:
4955: /* Extended Attributes variables */
4956: l_ext_old_index NUMBER := 0;
4957: l_ext_new_index NUMBER := 0;
4958: l_old_extended_attribs_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4959: l_new_extended_attribs_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4960:
4961: /* Decrement and Increment Logic variables */
4962: l_un_exp_instance_rec csi_datastructures_pub.instance_rec;

Line 4959: l_new_extended_attribs_tbl csi_datastructures_pub.extend_attrib_values_tbl;

4955: /* Extended Attributes variables */
4956: l_ext_old_index NUMBER := 0;
4957: l_ext_new_index NUMBER := 0;
4958: l_old_extended_attribs_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4959: l_new_extended_attribs_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4960:
4961: /* Decrement and Increment Logic variables */
4962: l_un_exp_instance_rec csi_datastructures_pub.instance_rec;
4963: l_un_exp_party_tbl csi_datastructures_pub.party_tbl;

Line 4962: l_un_exp_instance_rec csi_datastructures_pub.instance_rec;

4958: l_old_extended_attribs_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4959: l_new_extended_attribs_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4960:
4961: /* Decrement and Increment Logic variables */
4962: l_un_exp_instance_rec csi_datastructures_pub.instance_rec;
4963: l_un_exp_party_tbl csi_datastructures_pub.party_tbl;
4964: l_un_exp_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4965: l_un_exp_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4966: l_un_exp_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 4963: l_un_exp_party_tbl csi_datastructures_pub.party_tbl;

4959: l_new_extended_attribs_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4960:
4961: /* Decrement and Increment Logic variables */
4962: l_un_exp_instance_rec csi_datastructures_pub.instance_rec;
4963: l_un_exp_party_tbl csi_datastructures_pub.party_tbl;
4964: l_un_exp_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4965: l_un_exp_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4966: l_un_exp_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4967: l_un_exp_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 4964: l_un_exp_party_acct_tbl csi_datastructures_pub.party_account_tbl;

4960:
4961: /* Decrement and Increment Logic variables */
4962: l_un_exp_instance_rec csi_datastructures_pub.instance_rec;
4963: l_un_exp_party_tbl csi_datastructures_pub.party_tbl;
4964: l_un_exp_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4965: l_un_exp_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4966: l_un_exp_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4967: l_un_exp_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4968: l_un_exp_org_units_tbl csi_datastructures_pub.organization_units_tbl;

Line 4965: l_un_exp_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

4961: /* Decrement and Increment Logic variables */
4962: l_un_exp_instance_rec csi_datastructures_pub.instance_rec;
4963: l_un_exp_party_tbl csi_datastructures_pub.party_tbl;
4964: l_un_exp_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4965: l_un_exp_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4966: l_un_exp_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4967: l_un_exp_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4968: l_un_exp_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4969: l_un_exp_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;

Line 4966: l_un_exp_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

4962: l_un_exp_instance_rec csi_datastructures_pub.instance_rec;
4963: l_un_exp_party_tbl csi_datastructures_pub.party_tbl;
4964: l_un_exp_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4965: l_un_exp_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4966: l_un_exp_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4967: l_un_exp_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4968: l_un_exp_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4969: l_un_exp_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
4970: l_un_exp_systems_rec csi_datastructures_pub.system_rec;

Line 4967: l_un_exp_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

4963: l_un_exp_party_tbl csi_datastructures_pub.party_tbl;
4964: l_un_exp_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4965: l_un_exp_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4966: l_un_exp_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4967: l_un_exp_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4968: l_un_exp_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4969: l_un_exp_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
4970: l_un_exp_systems_rec csi_datastructures_pub.system_rec;
4971:

Line 4968: l_un_exp_org_units_tbl csi_datastructures_pub.organization_units_tbl;

4964: l_un_exp_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4965: l_un_exp_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4966: l_un_exp_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4967: l_un_exp_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4968: l_un_exp_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4969: l_un_exp_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
4970: l_un_exp_systems_rec csi_datastructures_pub.system_rec;
4971:
4972: l_trx_rec csi_datastructures_pub.transaction_rec;

Line 4969: l_un_exp_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;

4965: l_un_exp_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4966: l_un_exp_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4967: l_un_exp_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4968: l_un_exp_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4969: l_un_exp_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
4970: l_un_exp_systems_rec csi_datastructures_pub.system_rec;
4971:
4972: l_trx_rec csi_datastructures_pub.transaction_rec;
4973: l_auto_split_instances csi_datastructures_pub.instance_tbl;

Line 4970: l_un_exp_systems_rec csi_datastructures_pub.system_rec;

4966: l_un_exp_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4967: l_un_exp_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4968: l_un_exp_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4969: l_un_exp_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
4970: l_un_exp_systems_rec csi_datastructures_pub.system_rec;
4971:
4972: l_trx_rec csi_datastructures_pub.transaction_rec;
4973: l_auto_split_instances csi_datastructures_pub.instance_tbl;
4974:

Line 4972: l_trx_rec csi_datastructures_pub.transaction_rec;

4968: l_un_exp_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4969: l_un_exp_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
4970: l_un_exp_systems_rec csi_datastructures_pub.system_rec;
4971:
4972: l_trx_rec csi_datastructures_pub.transaction_rec;
4973: l_auto_split_instances csi_datastructures_pub.instance_tbl;
4974:
4975: l_split_src_inst_rec csi_datastructures_pub.instance_rec;
4976: l_split_src_trx_rec csi_datastructures_pub.transaction_rec;

Line 4973: l_auto_split_instances csi_datastructures_pub.instance_tbl;

4969: l_un_exp_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
4970: l_un_exp_systems_rec csi_datastructures_pub.system_rec;
4971:
4972: l_trx_rec csi_datastructures_pub.transaction_rec;
4973: l_auto_split_instances csi_datastructures_pub.instance_tbl;
4974:
4975: l_split_src_inst_rec csi_datastructures_pub.instance_rec;
4976: l_split_src_trx_rec csi_datastructures_pub.transaction_rec;
4977: l_split_new_inst_rec csi_datastructures_pub.instance_rec;

Line 4975: l_split_src_inst_rec csi_datastructures_pub.instance_rec;

4971:
4972: l_trx_rec csi_datastructures_pub.transaction_rec;
4973: l_auto_split_instances csi_datastructures_pub.instance_tbl;
4974:
4975: l_split_src_inst_rec csi_datastructures_pub.instance_rec;
4976: l_split_src_trx_rec csi_datastructures_pub.transaction_rec;
4977: l_split_new_inst_rec csi_datastructures_pub.instance_rec;
4978: l_sys_query_rec csi_datastructures_pub.system_query_rec;
4979: x_systems_tbl csi_datastructures_pub.systems_tbl;

Line 4976: l_split_src_trx_rec csi_datastructures_pub.transaction_rec;

4972: l_trx_rec csi_datastructures_pub.transaction_rec;
4973: l_auto_split_instances csi_datastructures_pub.instance_tbl;
4974:
4975: l_split_src_inst_rec csi_datastructures_pub.instance_rec;
4976: l_split_src_trx_rec csi_datastructures_pub.transaction_rec;
4977: l_split_new_inst_rec csi_datastructures_pub.instance_rec;
4978: l_sys_query_rec csi_datastructures_pub.system_query_rec;
4979: x_systems_tbl csi_datastructures_pub.systems_tbl;
4980:

Line 4977: l_split_new_inst_rec csi_datastructures_pub.instance_rec;

4973: l_auto_split_instances csi_datastructures_pub.instance_tbl;
4974:
4975: l_split_src_inst_rec csi_datastructures_pub.instance_rec;
4976: l_split_src_trx_rec csi_datastructures_pub.transaction_rec;
4977: l_split_new_inst_rec csi_datastructures_pub.instance_rec;
4978: l_sys_query_rec csi_datastructures_pub.system_query_rec;
4979: x_systems_tbl csi_datastructures_pub.systems_tbl;
4980:
4981: /* expire item instance variables */

Line 4978: l_sys_query_rec csi_datastructures_pub.system_query_rec;

4974:
4975: l_split_src_inst_rec csi_datastructures_pub.instance_rec;
4976: l_split_src_trx_rec csi_datastructures_pub.transaction_rec;
4977: l_split_new_inst_rec csi_datastructures_pub.instance_rec;
4978: l_sys_query_rec csi_datastructures_pub.system_query_rec;
4979: x_systems_tbl csi_datastructures_pub.systems_tbl;
4980:
4981: /* expire item instance variables */
4982: l_exp_instance_rec csi_datastructures_pub.instance_rec;

Line 4979: x_systems_tbl csi_datastructures_pub.systems_tbl;

4975: l_split_src_inst_rec csi_datastructures_pub.instance_rec;
4976: l_split_src_trx_rec csi_datastructures_pub.transaction_rec;
4977: l_split_new_inst_rec csi_datastructures_pub.instance_rec;
4978: l_sys_query_rec csi_datastructures_pub.system_query_rec;
4979: x_systems_tbl csi_datastructures_pub.systems_tbl;
4980:
4981: /* expire item instance variables */
4982: l_exp_instance_rec csi_datastructures_pub.instance_rec;
4983: l_exp_instance_id_lst csi_datastructures_pub.id_tbl;

Line 4982: l_exp_instance_rec csi_datastructures_pub.instance_rec;

4978: l_sys_query_rec csi_datastructures_pub.system_query_rec;
4979: x_systems_tbl csi_datastructures_pub.systems_tbl;
4980:
4981: /* expire item instance variables */
4982: l_exp_instance_rec csi_datastructures_pub.instance_rec;
4983: l_exp_instance_id_lst csi_datastructures_pub.id_tbl;
4984: l_expire_flag BOOLEAN := FALSE;
4985:
4986: /* non source processing variables */

Line 4983: l_exp_instance_id_lst csi_datastructures_pub.id_tbl;

4979: x_systems_tbl csi_datastructures_pub.systems_tbl;
4980:
4981: /* expire item instance variables */
4982: l_exp_instance_rec csi_datastructures_pub.instance_rec;
4983: l_exp_instance_id_lst csi_datastructures_pub.id_tbl;
4984: l_expire_flag BOOLEAN := FALSE;
4985:
4986: /* non source processing variables */
4987: l_ns_instance_rec csi_datastructures_pub.instance_rec;

Line 4987: l_ns_instance_rec csi_datastructures_pub.instance_rec;

4983: l_exp_instance_id_lst csi_datastructures_pub.id_tbl;
4984: l_expire_flag BOOLEAN := FALSE;
4985:
4986: /* non source processing variables */
4987: l_ns_instance_rec csi_datastructures_pub.instance_rec;
4988: l_ns_party_tbl csi_datastructures_pub.party_tbl;
4989: l_ns_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4990: l_ns_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4991: l_ns_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 4988: l_ns_party_tbl csi_datastructures_pub.party_tbl;

4984: l_expire_flag BOOLEAN := FALSE;
4985:
4986: /* non source processing variables */
4987: l_ns_instance_rec csi_datastructures_pub.instance_rec;
4988: l_ns_party_tbl csi_datastructures_pub.party_tbl;
4989: l_ns_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4990: l_ns_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4991: l_ns_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4992: l_ns_org_units_tbl csi_datastructures_pub.organization_units_tbl;

Line 4989: l_ns_party_acct_tbl csi_datastructures_pub.party_account_tbl;

4985:
4986: /* non source processing variables */
4987: l_ns_instance_rec csi_datastructures_pub.instance_rec;
4988: l_ns_party_tbl csi_datastructures_pub.party_tbl;
4989: l_ns_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4990: l_ns_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4991: l_ns_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4992: l_ns_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4993: l_ns_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

Line 4990: l_ns_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

4986: /* non source processing variables */
4987: l_ns_instance_rec csi_datastructures_pub.instance_rec;
4988: l_ns_party_tbl csi_datastructures_pub.party_tbl;
4989: l_ns_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4990: l_ns_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4991: l_ns_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4992: l_ns_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4993: l_ns_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4994: l_ns_inst_id_lst csi_datastructures_pub.id_tbl;

Line 4991: l_ns_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

4987: l_ns_instance_rec csi_datastructures_pub.instance_rec;
4988: l_ns_party_tbl csi_datastructures_pub.party_tbl;
4989: l_ns_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4990: l_ns_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4991: l_ns_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4992: l_ns_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4993: l_ns_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4994: l_ns_inst_id_lst csi_datastructures_pub.id_tbl;
4995:

Line 4992: l_ns_org_units_tbl csi_datastructures_pub.organization_units_tbl;

4988: l_ns_party_tbl csi_datastructures_pub.party_tbl;
4989: l_ns_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4990: l_ns_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4991: l_ns_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4992: l_ns_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4993: l_ns_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4994: l_ns_inst_id_lst csi_datastructures_pub.id_tbl;
4995:
4996: l_chg_instance_rec csi_datastructures_pub.instance_rec;

Line 4993: l_ns_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

4989: l_ns_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4990: l_ns_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4991: l_ns_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4992: l_ns_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4993: l_ns_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4994: l_ns_inst_id_lst csi_datastructures_pub.id_tbl;
4995:
4996: l_chg_instance_rec csi_datastructures_pub.instance_rec;
4997: l_chg_party_tbl csi_datastructures_pub.party_tbl;

Line 4994: l_ns_inst_id_lst csi_datastructures_pub.id_tbl;

4990: l_ns_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4991: l_ns_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4992: l_ns_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4993: l_ns_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4994: l_ns_inst_id_lst csi_datastructures_pub.id_tbl;
4995:
4996: l_chg_instance_rec csi_datastructures_pub.instance_rec;
4997: l_chg_party_tbl csi_datastructures_pub.party_tbl;
4998: l_chg_party_acct_tbl csi_datastructures_pub.party_account_tbl;

Line 4996: l_chg_instance_rec csi_datastructures_pub.instance_rec;

4992: l_ns_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4993: l_ns_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4994: l_ns_inst_id_lst csi_datastructures_pub.id_tbl;
4995:
4996: l_chg_instance_rec csi_datastructures_pub.instance_rec;
4997: l_chg_party_tbl csi_datastructures_pub.party_tbl;
4998: l_chg_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4999: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5000: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 4997: l_chg_party_tbl csi_datastructures_pub.party_tbl;

4993: l_ns_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4994: l_ns_inst_id_lst csi_datastructures_pub.id_tbl;
4995:
4996: l_chg_instance_rec csi_datastructures_pub.instance_rec;
4997: l_chg_party_tbl csi_datastructures_pub.party_tbl;
4998: l_chg_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4999: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5000: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5001: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;

Line 4998: l_chg_party_acct_tbl csi_datastructures_pub.party_account_tbl;

4994: l_ns_inst_id_lst csi_datastructures_pub.id_tbl;
4995:
4996: l_chg_instance_rec csi_datastructures_pub.instance_rec;
4997: l_chg_party_tbl csi_datastructures_pub.party_tbl;
4998: l_chg_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4999: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5000: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5001: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5002: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

Line 4999: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

4995:
4996: l_chg_instance_rec csi_datastructures_pub.instance_rec;
4997: l_chg_party_tbl csi_datastructures_pub.party_tbl;
4998: l_chg_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4999: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5000: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5001: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5002: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5003: l_chg_inst_id_lst csi_datastructures_pub.id_tbl;

Line 5000: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

4996: l_chg_instance_rec csi_datastructures_pub.instance_rec;
4997: l_chg_party_tbl csi_datastructures_pub.party_tbl;
4998: l_chg_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4999: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5000: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5001: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5002: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5003: l_chg_inst_id_lst csi_datastructures_pub.id_tbl;
5004: l_chg_txn_rec csi_datastructures_pub.transaction_rec;

Line 5001: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;

4997: l_chg_party_tbl csi_datastructures_pub.party_tbl;
4998: l_chg_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4999: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5000: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5001: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5002: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5003: l_chg_inst_id_lst csi_datastructures_pub.id_tbl;
5004: l_chg_txn_rec csi_datastructures_pub.transaction_rec;
5005:

Line 5002: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

4998: l_chg_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4999: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5000: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5001: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5002: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5003: l_chg_inst_id_lst csi_datastructures_pub.id_tbl;
5004: l_chg_txn_rec csi_datastructures_pub.transaction_rec;
5005:
5006: l_all_tld_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

Line 5003: l_chg_inst_id_lst csi_datastructures_pub.id_tbl;

4999: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5000: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5001: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5002: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5003: l_chg_inst_id_lst csi_datastructures_pub.id_tbl;
5004: l_chg_txn_rec csi_datastructures_pub.transaction_rec;
5005:
5006: l_all_tld_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5007: l_all_tld_account_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

Line 5004: l_chg_txn_rec csi_datastructures_pub.transaction_rec;

5000: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5001: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5002: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5003: l_chg_inst_id_lst csi_datastructures_pub.id_tbl;
5004: l_chg_txn_rec csi_datastructures_pub.transaction_rec;
5005:
5006: l_all_tld_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5007: l_all_tld_account_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5008: l_all_tld_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

Line 5067: l_exp_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;

5063: is_instance_rma BOOLEAN := FALSE;
5064: l_relationship_id NUMBER;
5065: l_ii_rel_obj_ver_num NUMBER;
5066: l_instance_pty_id NUMBER;
5067: l_exp_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;
5068: l_exp_instance_id_tbl csi_datastructures_pub.id_tbl;
5069:
5070: l_dflt_inst_status_id NUMBER;
5071: l_owner_party_id NUMBER;

Line 5068: l_exp_instance_id_tbl csi_datastructures_pub.id_tbl;

5064: l_relationship_id NUMBER;
5065: l_ii_rel_obj_ver_num NUMBER;
5066: l_instance_pty_id NUMBER;
5067: l_exp_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;
5068: l_exp_instance_id_tbl csi_datastructures_pub.id_tbl;
5069:
5070: l_dflt_inst_status_id NUMBER;
5071: l_owner_party_id NUMBER;
5072: l_internal_party_id NUMBER;

Line 5077: l_bom_std_item_rec csi_datastructures_pub.instance_rec;

5073: l_ownership_flag VARCHAR2(1);
5074:
5075: -- explode_bom variables
5076: l_bom_ind binary_integer := 0;
5077: l_bom_std_item_rec csi_datastructures_pub.instance_rec;
5078: l_bom_std_item_tbl csi_datastructures_pub.instance_tbl;
5079:
5080: l_comp_instance_tbl csi_datastructures_pub.instance_tbl;
5081: l_comp_relation_tbl csi_datastructures_pub.ii_relationship_tbl;

Line 5078: l_bom_std_item_tbl csi_datastructures_pub.instance_tbl;

5074:
5075: -- explode_bom variables
5076: l_bom_ind binary_integer := 0;
5077: l_bom_std_item_rec csi_datastructures_pub.instance_rec;
5078: l_bom_std_item_tbl csi_datastructures_pub.instance_tbl;
5079:
5080: l_comp_instance_tbl csi_datastructures_pub.instance_tbl;
5081: l_comp_relation_tbl csi_datastructures_pub.ii_relationship_tbl;
5082:

Line 5080: l_comp_instance_tbl csi_datastructures_pub.instance_tbl;

5076: l_bom_ind binary_integer := 0;
5077: l_bom_std_item_rec csi_datastructures_pub.instance_rec;
5078: l_bom_std_item_tbl csi_datastructures_pub.instance_tbl;
5079:
5080: l_comp_instance_tbl csi_datastructures_pub.instance_tbl;
5081: l_comp_relation_tbl csi_datastructures_pub.ii_relationship_tbl;
5082:
5083: l_active_end_date date := fnd_api.g_miss_date;
5084: l_call_contracts varchar2(1) := fnd_api.g_true;

Line 5081: l_comp_relation_tbl csi_datastructures_pub.ii_relationship_tbl;

5077: l_bom_std_item_rec csi_datastructures_pub.instance_rec;
5078: l_bom_std_item_tbl csi_datastructures_pub.instance_tbl;
5079:
5080: l_comp_instance_tbl csi_datastructures_pub.instance_tbl;
5081: l_comp_relation_tbl csi_datastructures_pub.ii_relationship_tbl;
5082:
5083: l_active_end_date date := fnd_api.g_miss_date;
5084: l_call_contracts varchar2(1) := fnd_api.g_true;
5085:

Line 5095: l_owner_pty_rec csi_datastructures_pub.party_rec;

5091: -- Partner Order changes
5092: l_upd_party_site_id number;
5093: l_cre_party_site_id number;
5094:
5095: l_owner_pty_rec csi_datastructures_pub.party_rec;
5096: l_owner_acct_rec csi_datastructures_pub.party_account_rec;
5097:
5098: --brmanesh 01-DEC-2003
5099: l_wip_job_id number;

Line 5096: l_owner_acct_rec csi_datastructures_pub.party_account_rec;

5092: l_upd_party_site_id number;
5093: l_cre_party_site_id number;
5094:
5095: l_owner_pty_rec csi_datastructures_pub.party_rec;
5096: l_owner_acct_rec csi_datastructures_pub.party_account_rec;
5097:
5098: --brmanesh 01-DEC-2003
5099: l_wip_job_id number;
5100: l_wip_iir_tbl csi_datastructures_pub.ii_relationship_tbl;

Line 5100: l_wip_iir_tbl csi_datastructures_pub.ii_relationship_tbl;

5096: l_owner_acct_rec csi_datastructures_pub.party_account_rec;
5097:
5098: --brmanesh 01-DEC-2003
5099: l_wip_job_id number;
5100: l_wip_iir_tbl csi_datastructures_pub.ii_relationship_tbl;
5101: l_cps_tbl customer_products_tbl;
5102: l_cp_ind binary_integer := 0;
5103: l_all_cps_tbl customer_products_tbl;
5104: l_single_cps_tbl customer_products_tbl;

Line 5909: NVL(csi_datastructures_pub.g_install_param_rec.ownership_override_at_txn,'N');

5905: l_owner_party_id <> l_upd_party_tbl(1).party_id
5906: THEN
5907:
5908: l_ownership_flag:=
5909: NVL(csi_datastructures_pub.g_install_param_rec.ownership_override_at_txn,'N');
5910:
5911: IF l_ownership_flag = 'N' Then
5912: fnd_message.set_name('CSI','CSI_SHIP_OWNER_MISMATCH');
5913: fnd_message.set_token('OLD_PARTY_ID',l_owner_party_id);

Line 8411: px_trx_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec)

8407:
8408: PROCEDURE oke_shipment(
8409: p_mtl_txn_id IN number,
8410: x_return_status OUT NOCOPY varchar2,
8411: px_trx_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec)
8412: IS
8413:
8414: l_oke_source_table varchar2(30) := csi_interface_pkg.g_oke_source_table;
8415:

Line 8426: l_csi_txn_rec csi_datastructures_pub.transaction_rec;

8422:
8423: l_source_header_rec csi_interface_pkg.source_header_rec;
8424: l_source_line_rec csi_interface_pkg.source_line_rec;
8425:
8426: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
8427:
8428: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
8429: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8430: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

Line 8437: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

8433: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8434: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8435: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8436:
8437: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
8438:
8439: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
8440: l_return_message varchar2(2000);
8441: l_msg_count number;

Line 8444: l_error_rec csi_datastructures_pub.transaction_error_rec;

8440: l_return_message varchar2(2000);
8441: l_msg_count number;
8442: l_msg_data varchar2(2000);
8443:
8444: l_error_rec csi_datastructures_pub.transaction_error_rec;
8445:
8446: BEGIN
8447:
8448: savepoint oke_shipment;