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 1401: p_trx_rec IN csi_datastructures_pub.transaction_rec,

1397:
1398: PROCEDURE process_non_source(
1399: p_txn_line_detail_rec IN csi_t_datastructures_grp.txn_line_detail_rec,
1400: p_call_contracts IN varchar2 := fnd_api.g_true,
1401: p_trx_rec IN csi_datastructures_pub.transaction_rec,
1402: x_return_status OUT NOCOPY varchar2)
1403: IS
1404:
1405: l_trx_rec csi_datastructures_pub.transaction_rec;

Line 1405: l_trx_rec csi_datastructures_pub.transaction_rec;

1401: p_trx_rec IN csi_datastructures_pub.transaction_rec,
1402: x_return_status OUT NOCOPY varchar2)
1403: IS
1404:
1405: l_trx_rec csi_datastructures_pub.transaction_rec;
1406:
1407: l_ns_instance_rec csi_datastructures_pub.instance_rec;
1408: l_ns_party_tbl csi_datastructures_pub.party_tbl;
1409: l_ns_party_acct_tbl csi_datastructures_pub.party_account_tbl;

Line 1407: l_ns_instance_rec csi_datastructures_pub.instance_rec;

1403: IS
1404:
1405: l_trx_rec csi_datastructures_pub.transaction_rec;
1406:
1407: l_ns_instance_rec csi_datastructures_pub.instance_rec;
1408: l_ns_party_tbl csi_datastructures_pub.party_tbl;
1409: l_ns_party_acct_tbl csi_datastructures_pub.party_account_tbl;
1410: l_ns_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
1411: l_ns_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 1408: l_ns_party_tbl csi_datastructures_pub.party_tbl;

1404:
1405: l_trx_rec csi_datastructures_pub.transaction_rec;
1406:
1407: l_ns_instance_rec csi_datastructures_pub.instance_rec;
1408: l_ns_party_tbl csi_datastructures_pub.party_tbl;
1409: l_ns_party_acct_tbl csi_datastructures_pub.party_account_tbl;
1410: l_ns_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
1411: l_ns_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1412: l_ns_org_units_tbl csi_datastructures_pub.organization_units_tbl;

Line 1409: l_ns_party_acct_tbl csi_datastructures_pub.party_account_tbl;

1405: l_trx_rec csi_datastructures_pub.transaction_rec;
1406:
1407: l_ns_instance_rec csi_datastructures_pub.instance_rec;
1408: l_ns_party_tbl csi_datastructures_pub.party_tbl;
1409: l_ns_party_acct_tbl csi_datastructures_pub.party_account_tbl;
1410: l_ns_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
1411: l_ns_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1412: l_ns_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1413: l_ns_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

Line 1410: l_ns_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

1406:
1407: l_ns_instance_rec csi_datastructures_pub.instance_rec;
1408: l_ns_party_tbl csi_datastructures_pub.party_tbl;
1409: l_ns_party_acct_tbl csi_datastructures_pub.party_account_tbl;
1410: l_ns_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
1411: l_ns_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1412: l_ns_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1413: l_ns_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1414: l_ns_inst_id_lst csi_datastructures_pub.id_tbl;

Line 1411: l_ns_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

1407: l_ns_instance_rec csi_datastructures_pub.instance_rec;
1408: l_ns_party_tbl csi_datastructures_pub.party_tbl;
1409: l_ns_party_acct_tbl csi_datastructures_pub.party_account_tbl;
1410: l_ns_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
1411: l_ns_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1412: l_ns_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1413: l_ns_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1414: l_ns_inst_id_lst csi_datastructures_pub.id_tbl;
1415:

Line 1412: l_ns_org_units_tbl csi_datastructures_pub.organization_units_tbl;

1408: l_ns_party_tbl csi_datastructures_pub.party_tbl;
1409: l_ns_party_acct_tbl csi_datastructures_pub.party_account_tbl;
1410: l_ns_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
1411: l_ns_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1412: l_ns_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1413: l_ns_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1414: l_ns_inst_id_lst csi_datastructures_pub.id_tbl;
1415:
1416: l_ii_relation_code varchar2(30);

Line 1413: l_ns_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

1409: l_ns_party_acct_tbl csi_datastructures_pub.party_account_tbl;
1410: l_ns_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
1411: l_ns_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1412: l_ns_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1413: l_ns_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1414: l_ns_inst_id_lst csi_datastructures_pub.id_tbl;
1415:
1416: l_ii_relation_code varchar2(30);
1417: l_location_code varchar2(30);

Line 1414: l_ns_inst_id_lst csi_datastructures_pub.id_tbl;

1410: l_ns_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
1411: l_ns_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1412: l_ns_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1413: l_ns_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1414: l_ns_inst_id_lst csi_datastructures_pub.id_tbl;
1415:
1416: l_ii_relation_code varchar2(30);
1417: l_location_code varchar2(30);
1418: l_serial_number varchar2(80);

Line 1420: l_exp_instance_id_lst csi_datastructures_pub.id_tbl;

1416: l_ii_relation_code varchar2(30);
1417: l_location_code varchar2(30);
1418: l_serial_number varchar2(80);
1419: l_active_end_date date;
1420: l_exp_instance_id_lst csi_datastructures_pub.id_tbl;
1421: l_exp_instance_rec csi_datastructures_pub.instance_rec;
1422:
1423: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1424: l_msg_count number;

Line 1421: l_exp_instance_rec csi_datastructures_pub.instance_rec;

1417: l_location_code varchar2(30);
1418: l_serial_number varchar2(80);
1419: l_active_end_date date;
1420: l_exp_instance_id_lst csi_datastructures_pub.id_tbl;
1421: l_exp_instance_rec csi_datastructures_pub.instance_rec;
1422:
1423: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1424: l_msg_count number;
1425: l_msg_data varchar2(2000);

Line 1692: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

1688: PROCEDURE get_order_shipment_rec(
1689: p_mtl_transaction_id IN NUMBER,
1690: p_order_line_rec IN order_line_rec,
1691: p_txn_sub_type_rec IN txn_sub_type_rec,
1692: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
1693: x_order_shipment_tbl OUT NOCOPY order_shipment_tbl,
1694: px_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,
1695: x_return_status OUT NOCOPY varchar2)
1696: IS

Line 1694: px_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,

1690: p_order_line_rec IN order_line_rec,
1691: p_txn_sub_type_rec IN txn_sub_type_rec,
1692: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
1693: x_order_shipment_tbl OUT NOCOPY order_shipment_tbl,
1694: px_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,
1695: x_return_status OUT NOCOPY varchar2)
1696: IS
1697:
1698: l_party_tbl csi_datastructures_pub.party_tbl;

Line 1698: l_party_tbl csi_datastructures_pub.party_tbl;

1694: px_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,
1695: x_return_status OUT NOCOPY varchar2)
1696: IS
1697:
1698: l_party_tbl csi_datastructures_pub.party_tbl;
1699: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
1700: l_party_query_rec csi_datastructures_pub.party_query_rec;
1701: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1702: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;

Line 1699: l_party_account_tbl csi_datastructures_pub.party_account_tbl;

1695: x_return_status OUT NOCOPY varchar2)
1696: IS
1697:
1698: l_party_tbl csi_datastructures_pub.party_tbl;
1699: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
1700: l_party_query_rec csi_datastructures_pub.party_query_rec;
1701: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1702: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;
1703: l_ext_attrib_val_tabl csi_datastructures_pub.extend_attrib_values_tbl;

Line 1700: l_party_query_rec csi_datastructures_pub.party_query_rec;

1696: IS
1697:
1698: l_party_tbl csi_datastructures_pub.party_tbl;
1699: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
1700: l_party_query_rec csi_datastructures_pub.party_query_rec;
1701: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1702: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;
1703: l_ext_attrib_val_tabl csi_datastructures_pub.extend_attrib_values_tbl;
1704: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 1701: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;

1697:
1698: l_party_tbl csi_datastructures_pub.party_tbl;
1699: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
1700: l_party_query_rec csi_datastructures_pub.party_query_rec;
1701: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1702: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;
1703: l_ext_attrib_val_tabl csi_datastructures_pub.extend_attrib_values_tbl;
1704: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
1705: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;

Line 1702: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;

1698: l_party_tbl csi_datastructures_pub.party_tbl;
1699: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
1700: l_party_query_rec csi_datastructures_pub.party_query_rec;
1701: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1702: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;
1703: l_ext_attrib_val_tabl csi_datastructures_pub.extend_attrib_values_tbl;
1704: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
1705: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1706: l_inst_query_rec csi_datastructures_pub.instance_query_rec;

Line 1703: l_ext_attrib_val_tabl csi_datastructures_pub.extend_attrib_values_tbl;

1699: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
1700: l_party_query_rec csi_datastructures_pub.party_query_rec;
1701: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1702: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;
1703: l_ext_attrib_val_tabl csi_datastructures_pub.extend_attrib_values_tbl;
1704: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
1705: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1706: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
1707:

Line 1704: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

1700: l_party_query_rec csi_datastructures_pub.party_query_rec;
1701: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1702: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;
1703: l_ext_attrib_val_tabl csi_datastructures_pub.extend_attrib_values_tbl;
1704: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
1705: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1706: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
1707:
1708: -- Added a column reservable_type from mtl_systems_items for negative quantity check.

Line 1705: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;

1701: l_pty_acct_query_rec csi_datastructures_pub.party_account_query_rec;
1702: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;
1703: l_ext_attrib_val_tabl csi_datastructures_pub.extend_attrib_values_tbl;
1704: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
1705: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1706: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
1707:
1708: -- Added a column reservable_type from mtl_systems_items for negative quantity check.
1709: l_cre_instance_rec csi_datastructures_pub.instance_rec;

Line 1706: l_inst_query_rec csi_datastructures_pub.instance_query_rec;

1702: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;
1703: l_ext_attrib_val_tabl csi_datastructures_pub.extend_attrib_values_tbl;
1704: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
1705: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1706: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
1707:
1708: -- Added a column reservable_type from mtl_systems_items for negative quantity check.
1709: l_cre_instance_rec csi_datastructures_pub.instance_rec;
1710: l_cre_party_tbl csi_datastructures_pub.party_tbl;

Line 1709: l_cre_instance_rec csi_datastructures_pub.instance_rec;

1705: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1706: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
1707:
1708: -- Added a column reservable_type from mtl_systems_items for negative quantity check.
1709: l_cre_instance_rec csi_datastructures_pub.instance_rec;
1710: l_cre_party_tbl csi_datastructures_pub.party_tbl;
1711: l_cre_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1712: l_cre_party_acct_tbl csi_datastructures_pub.party_account_tbl;
1713: l_cre_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 1710: l_cre_party_tbl csi_datastructures_pub.party_tbl;

1706: l_inst_query_rec csi_datastructures_pub.instance_query_rec;
1707:
1708: -- Added a column reservable_type from mtl_systems_items for negative quantity check.
1709: l_cre_instance_rec csi_datastructures_pub.instance_rec;
1710: l_cre_party_tbl csi_datastructures_pub.party_tbl;
1711: l_cre_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1712: l_cre_party_acct_tbl csi_datastructures_pub.party_account_tbl;
1713: l_cre_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
1714: l_cre_org_units_tbl csi_datastructures_pub.organization_units_tbl;

Line 1711: l_cre_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

1707:
1708: -- Added a column reservable_type from mtl_systems_items for negative quantity check.
1709: l_cre_instance_rec csi_datastructures_pub.instance_rec;
1710: l_cre_party_tbl csi_datastructures_pub.party_tbl;
1711: l_cre_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1712: l_cre_party_acct_tbl csi_datastructures_pub.party_account_tbl;
1713: l_cre_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
1714: l_cre_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1715: l_cre_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

Line 1712: l_cre_party_acct_tbl csi_datastructures_pub.party_account_tbl;

1708: -- Added a column reservable_type from mtl_systems_items for negative quantity check.
1709: l_cre_instance_rec csi_datastructures_pub.instance_rec;
1710: l_cre_party_tbl csi_datastructures_pub.party_tbl;
1711: l_cre_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1712: l_cre_party_acct_tbl csi_datastructures_pub.party_account_tbl;
1713: l_cre_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
1714: l_cre_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1715: l_cre_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1716: l_trx_rec csi_datastructures_pub.transaction_rec;

Line 1713: l_cre_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

1709: l_cre_instance_rec csi_datastructures_pub.instance_rec;
1710: l_cre_party_tbl csi_datastructures_pub.party_tbl;
1711: l_cre_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1712: l_cre_party_acct_tbl csi_datastructures_pub.party_account_tbl;
1713: l_cre_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
1714: l_cre_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1715: l_cre_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1716: l_trx_rec csi_datastructures_pub.transaction_rec;
1717:

Line 1714: l_cre_org_units_tbl csi_datastructures_pub.organization_units_tbl;

1710: l_cre_party_tbl csi_datastructures_pub.party_tbl;
1711: l_cre_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1712: l_cre_party_acct_tbl csi_datastructures_pub.party_account_tbl;
1713: l_cre_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
1714: l_cre_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1715: l_cre_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1716: l_trx_rec csi_datastructures_pub.transaction_rec;
1717:
1718: -- Added for updating instance to ZERO

Line 1715: l_cre_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

1711: l_cre_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1712: l_cre_party_acct_tbl csi_datastructures_pub.party_account_tbl;
1713: l_cre_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
1714: l_cre_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1715: l_cre_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1716: l_trx_rec csi_datastructures_pub.transaction_rec;
1717:
1718: -- Added for updating instance to ZERO
1719: l_zero_instance_rec csi_datastructures_pub.instance_rec;

Line 1716: l_trx_rec csi_datastructures_pub.transaction_rec;

1712: l_cre_party_acct_tbl csi_datastructures_pub.party_account_tbl;
1713: l_cre_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
1714: l_cre_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1715: l_cre_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1716: l_trx_rec csi_datastructures_pub.transaction_rec;
1717:
1718: -- Added for updating instance to ZERO
1719: l_zero_instance_rec csi_datastructures_pub.instance_rec;
1720: l_zero_parties_tbl csi_datastructures_pub.party_tbl;

Line 1719: l_zero_instance_rec csi_datastructures_pub.instance_rec;

1715: l_cre_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1716: l_trx_rec csi_datastructures_pub.transaction_rec;
1717:
1718: -- Added for updating instance to ZERO
1719: l_zero_instance_rec csi_datastructures_pub.instance_rec;
1720: l_zero_parties_tbl csi_datastructures_pub.party_tbl;
1721: l_zero_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1722: l_zero_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1723: l_zero_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 1720: l_zero_parties_tbl csi_datastructures_pub.party_tbl;

1716: l_trx_rec csi_datastructures_pub.transaction_rec;
1717:
1718: -- Added for updating instance to ZERO
1719: l_zero_instance_rec csi_datastructures_pub.instance_rec;
1720: l_zero_parties_tbl csi_datastructures_pub.party_tbl;
1721: l_zero_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1722: l_zero_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1723: l_zero_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1724: l_zero_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 1721: l_zero_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

1717:
1718: -- Added for updating instance to ZERO
1719: l_zero_instance_rec csi_datastructures_pub.instance_rec;
1720: l_zero_parties_tbl csi_datastructures_pub.party_tbl;
1721: l_zero_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1722: l_zero_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1723: l_zero_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1724: l_zero_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1725: l_zero_assets_tbl csi_datastructures_pub.instance_asset_tbl;

Line 1722: l_zero_org_units_tbl csi_datastructures_pub.organization_units_tbl;

1718: -- Added for updating instance to ZERO
1719: l_zero_instance_rec csi_datastructures_pub.instance_rec;
1720: l_zero_parties_tbl csi_datastructures_pub.party_tbl;
1721: l_zero_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1722: l_zero_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1723: l_zero_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1724: l_zero_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1725: l_zero_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1726: l_inst_id_lst csi_datastructures_pub.id_tbl;

Line 1723: l_zero_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

1719: l_zero_instance_rec csi_datastructures_pub.instance_rec;
1720: l_zero_parties_tbl csi_datastructures_pub.party_tbl;
1721: l_zero_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1722: l_zero_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1723: l_zero_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1724: l_zero_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1725: l_zero_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1726: l_inst_id_lst csi_datastructures_pub.id_tbl;
1727:

Line 1724: l_zero_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

1720: l_zero_parties_tbl csi_datastructures_pub.party_tbl;
1721: l_zero_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1722: l_zero_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1723: l_zero_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1724: l_zero_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1725: l_zero_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1726: l_inst_id_lst csi_datastructures_pub.id_tbl;
1727:
1728: x_msg_count NUMBER;

Line 1725: l_zero_assets_tbl csi_datastructures_pub.instance_asset_tbl;

1721: l_zero_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
1722: l_zero_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1723: l_zero_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1724: l_zero_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1725: l_zero_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1726: l_inst_id_lst csi_datastructures_pub.id_tbl;
1727:
1728: x_msg_count NUMBER;
1729: x_msg_data varchar2(2000);

Line 1726: l_inst_id_lst csi_datastructures_pub.id_tbl;

1722: l_zero_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1723: l_zero_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1724: l_zero_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
1725: l_zero_assets_tbl csi_datastructures_pub.instance_asset_tbl;
1726: l_inst_id_lst csi_datastructures_pub.id_tbl;
1727:
1728: x_msg_count NUMBER;
1729: x_msg_data varchar2(2000);
1730: l_party_id NUMBER;

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

2169: l_cre_instance_rec.mfg_serial_number_flag := 'Y';
2170: END IF;
2171:
2172: -- Building Party Rec for creating Instance with missing Quantity
2173: l_cre_party_tbl(1).party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
2174:
2175: l_cre_party_tbl(1).party_source_table := 'HZ_PARTIES';
2176: l_cre_party_tbl(1).relationship_type_code := 'OWNER';
2177: l_cre_party_tbl(1).contact_flag := 'N';

Line 2367: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

2363: p_order_line_rec IN OUT NOCOPY order_line_rec,
2364: p_txn_sub_type_rec IN txn_sub_type_rec,
2365: p_trx_detail_exist IN boolean,
2366: p_trackable_parent IN boolean,
2367: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
2368: x_order_shipment_tbl OUT NOCOPY order_shipment_tbl,
2369: px_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,
2370: x_return_status OUT NOCOPY varchar2)
2371: IS

Line 2369: px_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,

2365: p_trx_detail_exist IN boolean,
2366: p_trackable_parent IN boolean,
2367: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
2368: x_order_shipment_tbl OUT NOCOPY order_shipment_tbl,
2369: px_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,
2370: x_return_status OUT NOCOPY varchar2)
2371: IS
2372: x_msg_count number;
2373: x_msg_data varchar2(2000);

Line 2407: l_trx_rec csi_datastructures_pub.transaction_rec;

2403: l_msg_count number;
2404: l_msg_data varchar2(2000);
2405:
2406: -- Included Transaction rec as part of fix for Bug 2767338
2407: l_trx_rec csi_datastructures_pub.transaction_rec;
2408:
2409: ---Added (Start) for m-to-m enhancements
2410: l_temp_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
2411: ---Added (End) for m-to-m enhancements

Line 3790: p_trx_rec in OUT NOCOPY csi_datastructures_pub.transaction_rec,

3786:
3787: PROCEDURE decrement_source_instance(
3788: p_instance_id in number,
3789: p_quantity in number,
3790: p_trx_rec in OUT NOCOPY csi_datastructures_pub.transaction_rec,
3791: x_return_status OUT NOCOPY varchar2)
3792: IS
3793:
3794: l_instance_rec csi_datastructures_pub.instance_rec;

Line 3794: l_instance_rec csi_datastructures_pub.instance_rec;

3790: p_trx_rec in OUT NOCOPY csi_datastructures_pub.transaction_rec,
3791: x_return_status OUT NOCOPY varchar2)
3792: IS
3793:
3794: l_instance_rec csi_datastructures_pub.instance_rec;
3795: l_party_tbl csi_datastructures_pub.party_tbl;
3796: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
3797: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
3798: l_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 3795: l_party_tbl csi_datastructures_pub.party_tbl;

3791: x_return_status OUT NOCOPY varchar2)
3792: IS
3793:
3794: l_instance_rec csi_datastructures_pub.instance_rec;
3795: l_party_tbl csi_datastructures_pub.party_tbl;
3796: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
3797: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
3798: l_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3799: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 3796: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;

3792: IS
3793:
3794: l_instance_rec csi_datastructures_pub.instance_rec;
3795: l_party_tbl csi_datastructures_pub.party_tbl;
3796: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
3797: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
3798: l_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3799: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
3800: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;

Line 3797: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

3793:
3794: l_instance_rec csi_datastructures_pub.instance_rec;
3795: l_party_tbl csi_datastructures_pub.party_tbl;
3796: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
3797: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
3798: l_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3799: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
3800: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
3801: l_inst_id_lst csi_datastructures_pub.id_tbl;

Line 3798: l_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

3794: l_instance_rec csi_datastructures_pub.instance_rec;
3795: l_party_tbl csi_datastructures_pub.party_tbl;
3796: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
3797: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
3798: l_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3799: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
3800: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
3801: l_inst_id_lst csi_datastructures_pub.id_tbl;
3802:

Line 3799: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

3795: l_party_tbl csi_datastructures_pub.party_tbl;
3796: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
3797: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
3798: l_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3799: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
3800: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
3801: l_inst_id_lst csi_datastructures_pub.id_tbl;
3802:
3803: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 3800: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;

3796: l_party_acct_tbl csi_datastructures_pub.party_account_tbl;
3797: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
3798: l_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3799: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
3800: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
3801: l_inst_id_lst csi_datastructures_pub.id_tbl;
3802:
3803: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3804: l_msg_count number;

Line 3801: l_inst_id_lst csi_datastructures_pub.id_tbl;

3797: l_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
3798: l_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3799: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
3800: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
3801: l_inst_id_lst csi_datastructures_pub.id_tbl;
3802:
3803: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3804: l_msg_count number;
3805: l_msg_data varchar2(2000);

Line 3914: p_instance_hdr_rec IN csi_datastructures_pub.instance_header_rec,

3910:
3911: END dump_customer_products;
3912:
3913: PROCEDURE make_non_hdr_rec(
3914: p_instance_hdr_rec IN csi_datastructures_pub.instance_header_rec,
3915: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,
3916: x_return_status OUT NOCOPY varchar2)
3917: IS
3918:

Line 3915: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,

3911: END dump_customer_products;
3912:
3913: PROCEDURE make_non_hdr_rec(
3914: p_instance_hdr_rec IN csi_datastructures_pub.instance_header_rec,
3915: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,
3916: x_return_status OUT NOCOPY varchar2)
3917: IS
3918:
3919: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;

Line 3919: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;

3915: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,
3916: x_return_status OUT NOCOPY varchar2)
3917: IS
3918:
3919: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
3920: l_instance_tbl csi_datastructures_pub.instance_tbl;
3921:
3922: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3923:

Line 3920: l_instance_tbl csi_datastructures_pub.instance_tbl;

3916: x_return_status OUT NOCOPY varchar2)
3917: IS
3918:
3919: l_instance_hdr_tbl csi_datastructures_pub.instance_header_tbl;
3920: l_instance_tbl csi_datastructures_pub.instance_tbl;
3921:
3922: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3923:
3924: BEGIN

Line 3954: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

3950: p_instance_id IN number,
3951: p_qty_ratio IN number,
3952: p_qty_completed IN number,
3953: p_organization_id IN number,
3954: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
3955: x_splitted_instances OUT NOCOPY csi_datastructures_pub.instance_tbl,
3956: x_return_status OUT NOCOPY varchar2)
3957: IS
3958:

Line 3955: x_splitted_instances OUT NOCOPY csi_datastructures_pub.instance_tbl,

3951: p_qty_ratio IN number,
3952: p_qty_completed IN number,
3953: p_organization_id IN number,
3954: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
3955: x_splitted_instances OUT NOCOPY csi_datastructures_pub.instance_tbl,
3956: x_return_status OUT NOCOPY varchar2)
3957: IS
3958:
3959: l_qty_remaining number;

Line 3961: l_init_instance_rec csi_datastructures_pub.instance_rec;

3957: IS
3958:
3959: l_qty_remaining number;
3960:
3961: l_init_instance_rec csi_datastructures_pub.instance_rec;
3962:
3963: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3964: l_msg_data varchar2(2000);
3965: l_msg_count number;

Line 3969: l_splitted_instances csi_datastructures_pub.instance_tbl;

3965: l_msg_count number;
3966:
3967: l_split_flag boolean := FALSE;
3968:
3969: l_splitted_instances csi_datastructures_pub.instance_tbl;
3970: l_s_ind binary_integer;
3971:
3972: -- get_item_instance_details variables
3973: l_g_instance_rec csi_datastructures_pub.instance_header_rec;

Line 3973: l_g_instance_rec csi_datastructures_pub.instance_header_rec;

3969: l_splitted_instances csi_datastructures_pub.instance_tbl;
3970: l_s_ind binary_integer;
3971:
3972: -- get_item_instance_details variables
3973: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
3974: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
3975: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
3976: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
3977: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 3974: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;

3970: l_s_ind binary_integer;
3971:
3972: -- get_item_instance_details variables
3973: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
3974: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
3975: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
3976: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
3977: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
3978: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 3975: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;

3971:
3972: -- get_item_instance_details variables
3973: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
3974: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
3975: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
3976: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
3977: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
3978: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3979: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;

Line 3976: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;

3972: -- get_item_instance_details variables
3973: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
3974: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
3975: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
3976: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
3977: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
3978: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3979: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
3980: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;

Line 3977: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;

3973: l_g_instance_rec csi_datastructures_pub.instance_header_rec;
3974: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
3975: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
3976: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
3977: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
3978: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3979: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
3980: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
3981: l_g_time_stamp date;

Line 3978: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;

3974: l_g_ph_tbl csi_datastructures_pub.party_header_tbl;
3975: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
3976: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
3977: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
3978: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3979: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
3980: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
3981: l_g_time_stamp date;
3982:

Line 3979: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;

3975: l_g_pah_tbl csi_datastructures_pub.party_account_header_tbl;
3976: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
3977: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
3978: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3979: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
3980: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
3981: l_g_time_stamp date;
3982:
3983: -- make_non_hdr variables

Line 3980: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;

3976: l_g_ouh_tbl csi_datastructures_pub.org_units_header_tbl;
3977: l_g_pa_tbl csi_datastructures_pub.pricing_attribs_tbl;
3978: l_g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3979: l_g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
3980: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
3981: l_g_time_stamp date;
3982:
3983: -- make_non_hdr variables
3984: l_instance_rec csi_datastructures_pub.instance_rec;

Line 3984: l_instance_rec csi_datastructures_pub.instance_rec;

3980: l_g_iah_tbl csi_datastructures_pub.instance_asset_header_tbl;
3981: l_g_time_stamp date;
3982:
3983: -- make_non_hdr variables
3984: l_instance_rec csi_datastructures_pub.instance_rec;
3985:
3986: -- update_item_instance variables
3987: l_u_instance_rec csi_datastructures_pub.instance_rec;
3988: l_u_parties_tbl csi_datastructures_pub.party_tbl;

Line 3987: l_u_instance_rec csi_datastructures_pub.instance_rec;

3983: -- make_non_hdr variables
3984: l_instance_rec csi_datastructures_pub.instance_rec;
3985:
3986: -- update_item_instance variables
3987: l_u_instance_rec csi_datastructures_pub.instance_rec;
3988: l_u_parties_tbl csi_datastructures_pub.party_tbl;
3989: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
3990: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
3991: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 3988: l_u_parties_tbl csi_datastructures_pub.party_tbl;

3984: l_instance_rec csi_datastructures_pub.instance_rec;
3985:
3986: -- update_item_instance variables
3987: l_u_instance_rec csi_datastructures_pub.instance_rec;
3988: l_u_parties_tbl csi_datastructures_pub.party_tbl;
3989: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
3990: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
3991: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3992: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 3989: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

3985:
3986: -- update_item_instance variables
3987: l_u_instance_rec csi_datastructures_pub.instance_rec;
3988: l_u_parties_tbl csi_datastructures_pub.party_tbl;
3989: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
3990: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
3991: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3992: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
3993: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;

Line 3990: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;

3986: -- update_item_instance variables
3987: l_u_instance_rec csi_datastructures_pub.instance_rec;
3988: l_u_parties_tbl csi_datastructures_pub.party_tbl;
3989: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
3990: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
3991: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3992: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
3993: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
3994: l_u_instance_ids_list csi_datastructures_pub.id_tbl;

Line 3991: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

3987: l_u_instance_rec csi_datastructures_pub.instance_rec;
3988: l_u_parties_tbl csi_datastructures_pub.party_tbl;
3989: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
3990: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
3991: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3992: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
3993: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
3994: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
3995:

Line 3992: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

3988: l_u_parties_tbl csi_datastructures_pub.party_tbl;
3989: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
3990: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
3991: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3992: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
3993: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
3994: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
3995:
3996: -- create_item_instance varaibles

Line 3993: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;

3989: l_u_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
3990: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
3991: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3992: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
3993: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
3994: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
3995:
3996: -- create_item_instance varaibles
3997: l_c_instance_rec csi_datastructures_pub.instance_rec;

Line 3994: l_u_instance_ids_list csi_datastructures_pub.id_tbl;

3990: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
3991: l_u_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
3992: l_u_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
3993: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
3994: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
3995:
3996: -- create_item_instance varaibles
3997: l_c_instance_rec csi_datastructures_pub.instance_rec;
3998: l_c_parties_tbl csi_datastructures_pub.party_tbl;

Line 3997: l_c_instance_rec csi_datastructures_pub.instance_rec;

3993: l_u_assets_tbl csi_datastructures_pub.instance_asset_tbl;
3994: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
3995:
3996: -- create_item_instance varaibles
3997: l_c_instance_rec csi_datastructures_pub.instance_rec;
3998: l_c_parties_tbl csi_datastructures_pub.party_tbl;
3999: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
4000: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4001: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 3998: l_c_parties_tbl csi_datastructures_pub.party_tbl;

3994: l_u_instance_ids_list csi_datastructures_pub.id_tbl;
3995:
3996: -- create_item_instance varaibles
3997: l_c_instance_rec csi_datastructures_pub.instance_rec;
3998: l_c_parties_tbl csi_datastructures_pub.party_tbl;
3999: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
4000: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4001: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4002: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 3999: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

3995:
3996: -- create_item_instance varaibles
3997: l_c_instance_rec csi_datastructures_pub.instance_rec;
3998: l_c_parties_tbl csi_datastructures_pub.party_tbl;
3999: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
4000: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4001: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4002: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
4003: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;

Line 4000: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;

3996: -- create_item_instance varaibles
3997: l_c_instance_rec csi_datastructures_pub.instance_rec;
3998: l_c_parties_tbl csi_datastructures_pub.party_tbl;
3999: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
4000: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4001: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4002: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
4003: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;
4004: c_pa_ind binary_integer;

Line 4001: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

3997: l_c_instance_rec csi_datastructures_pub.instance_rec;
3998: l_c_parties_tbl csi_datastructures_pub.party_tbl;
3999: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
4000: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4001: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4002: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
4003: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;
4004: c_pa_ind binary_integer;
4005:

Line 4002: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

3998: l_c_parties_tbl csi_datastructures_pub.party_tbl;
3999: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
4000: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4001: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4002: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
4003: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;
4004: c_pa_ind binary_integer;
4005:
4006: BEGIN

Line 4003: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;

3999: l_c_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
4000: l_c_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4001: l_c_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4002: l_c_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
4003: l_c_assets_tbl csi_datastructures_pub.instance_asset_tbl;
4004: c_pa_ind binary_integer;
4005:
4006: BEGIN
4007:

Line 4225: p_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

4221:
4222: PROCEDURE convert_wip_instance_to_cp(
4223: p_instance_id IN number,
4224: p_line_id IN number,
4225: p_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
4226: x_return_status OUT NOCOPY varchar2)
4227: IS
4228:
4229: l_party_site_id number;

Line 4239: l_u_instance_rec csi_datastructures_pub.instance_rec;

4235:
4236: l_location_type_code varchar2(80);
4237: l_inst_object_ver_num number;
4238:
4239: l_u_instance_rec csi_datastructures_pub.instance_rec;
4240: l_u_party_tbl csi_datastructures_pub.party_tbl;
4241: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4242: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4243: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 4240: l_u_party_tbl csi_datastructures_pub.party_tbl;

4236: l_location_type_code varchar2(80);
4237: l_inst_object_ver_num number;
4238:
4239: l_u_instance_rec csi_datastructures_pub.instance_rec;
4240: l_u_party_tbl csi_datastructures_pub.party_tbl;
4241: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4242: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4243: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4244: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 4241: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;

4237: l_inst_object_ver_num number;
4238:
4239: l_u_instance_rec csi_datastructures_pub.instance_rec;
4240: l_u_party_tbl csi_datastructures_pub.party_tbl;
4241: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4242: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4243: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4244: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4245: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;

Line 4242: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

4238:
4239: l_u_instance_rec csi_datastructures_pub.instance_rec;
4240: l_u_party_tbl csi_datastructures_pub.party_tbl;
4241: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4242: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4243: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4244: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4245: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4246: l_u_inst_id_lst csi_datastructures_pub.id_tbl;

Line 4243: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

4239: l_u_instance_rec csi_datastructures_pub.instance_rec;
4240: l_u_party_tbl csi_datastructures_pub.party_tbl;
4241: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4242: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4243: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4244: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4245: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4246: l_u_inst_id_lst csi_datastructures_pub.id_tbl;
4247:

Line 4244: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

4240: l_u_party_tbl csi_datastructures_pub.party_tbl;
4241: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4242: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4243: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4244: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4245: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4246: l_u_inst_id_lst csi_datastructures_pub.id_tbl;
4247:
4248: l_instance_party_id number;

Line 4245: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;

4241: l_u_party_acct_tbl csi_datastructures_pub.party_account_tbl;
4242: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4243: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4244: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4245: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4246: l_u_inst_id_lst csi_datastructures_pub.id_tbl;
4247:
4248: l_instance_party_id number;
4249: l_pty_object_ver_num number;

Line 4246: l_u_inst_id_lst csi_datastructures_pub.id_tbl;

4242: l_u_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
4243: l_u_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
4244: l_u_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
4245: l_u_org_units_tbl csi_datastructures_pub.organization_units_tbl;
4246: l_u_inst_id_lst csi_datastructures_pub.id_tbl;
4247:
4248: l_instance_party_id number;
4249: l_pty_object_ver_num number;
4250: l_pa_object_ver_num number;

Line 4421: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,

4417: PROCEDURE get_comp_instances_from_wip(
4418: p_wip_entity_id IN number,
4419: p_organization_id IN number,
4420: p_cps_tbl IN customer_products_tbl,
4421: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
4422: x_iir_tbl OUT nocopy csi_datastructures_pub.ii_relationship_tbl,
4423: x_return_status OUT nocopy varchar2)
4424: IS
4425:

Line 4422: x_iir_tbl OUT nocopy csi_datastructures_pub.ii_relationship_tbl,

4418: p_wip_entity_id IN number,
4419: p_organization_id IN number,
4420: p_cps_tbl IN customer_products_tbl,
4421: px_csi_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
4422: x_iir_tbl OUT nocopy csi_datastructures_pub.ii_relationship_tbl,
4423: x_return_status OUT nocopy varchar2)
4424: IS
4425:
4426: l_cps_tbl customer_products_tbl;

Line 4429: l_iir_tbl csi_datastructures_pub.ii_relationship_tbl;

4425:
4426: l_cps_tbl customer_products_tbl;
4427: l_qty_per_assy number := 0;
4428: l_iir_ind binary_integer := 0;
4429: l_iir_tbl csi_datastructures_pub.ii_relationship_tbl;
4430: l_serial_code number;
4431:
4432: l_splitted_instances csi_datastructures_pub.instance_tbl;
4433: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 4432: l_splitted_instances csi_datastructures_pub.instance_tbl;

4428: l_iir_ind binary_integer := 0;
4429: l_iir_tbl csi_datastructures_pub.ii_relationship_tbl;
4430: l_serial_code number;
4431:
4432: l_splitted_instances csi_datastructures_pub.instance_tbl;
4433: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4434:
4435: CURSOR req_cur IS
4436: SELECT wip.inventory_item_id,

Line 4471: p_iir_tbl IN csi_datastructures_pub.ii_relationship_tbl)

4467: AND quantity <= p_qty_per_assy;
4468:
4469: FUNCTION already_allocated(
4470: p_subject_id IN number,
4471: p_iir_tbl IN csi_datastructures_pub.ii_relationship_tbl)
4472: RETURN BOOLEAN
4473: IS
4474: l_allocated boolean := FALSE;
4475: BEGIN

Line 4697: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,

4693:
4694:
4695: -- convert txn_systems in to csi_systems
4696: PROCEDURE create_csi_systems(
4697: px_csi_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
4698: px_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
4699: px_tld_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
4700: x_return_status OUT NOCOPY varchar2)
4701: IS

Line 4703: l_system_rec csi_datastructures_pub.system_rec;

4699: px_tld_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
4700: x_return_status OUT NOCOPY varchar2)
4701: IS
4702: l_system_exist boolean := FALSE;
4703: l_system_rec csi_datastructures_pub.system_rec;
4704: l_system_id number;
4705:
4706: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4707: l_msg_count number;

Line 4873: p_instance_rec IN csi_datastructures_pub.instance_rec,

4869: x_return_status := fnd_api.g_ret_sts_unexp_error ;
4870: END proc_for_last_mtl_trx ;
4871:
4872: PROCEDURE auto_split_instances(
4873: p_instance_rec IN csi_datastructures_pub.instance_rec,
4874: px_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
4875: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
4876: x_return_status OUT nocopy varchar2)
4877: IS

Line 4874: px_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,

4870: END proc_for_last_mtl_trx ;
4871:
4872: PROCEDURE auto_split_instances(
4873: p_instance_rec IN csi_datastructures_pub.instance_rec,
4874: px_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
4875: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
4876: x_return_status OUT nocopy varchar2)
4877: IS
4878: l_src_instance_rec csi_datastructures_pub.instance_rec;

Line 4875: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,

4871:
4872: PROCEDURE auto_split_instances(
4873: p_instance_rec IN csi_datastructures_pub.instance_rec,
4874: px_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
4875: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
4876: x_return_status OUT nocopy varchar2)
4877: IS
4878: l_src_instance_rec csi_datastructures_pub.instance_rec;
4879: l_instance_tbl csi_datastructures_pub.instance_tbl;

Line 4878: l_src_instance_rec csi_datastructures_pub.instance_rec;

4874: px_txn_rec IN OUT nocopy csi_datastructures_pub.transaction_rec,
4875: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
4876: x_return_status OUT nocopy varchar2)
4877: IS
4878: l_src_instance_rec csi_datastructures_pub.instance_rec;
4879: l_instance_tbl csi_datastructures_pub.instance_tbl;
4880: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4881: l_msg_count number;
4882: l_msg_data varchar2(2000);

Line 4879: l_instance_tbl csi_datastructures_pub.instance_tbl;

4875: x_instance_tbl OUT nocopy csi_datastructures_pub.instance_tbl,
4876: x_return_status OUT nocopy varchar2)
4877: IS
4878: l_src_instance_rec csi_datastructures_pub.instance_rec;
4879: l_instance_tbl csi_datastructures_pub.instance_tbl;
4880: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4881: l_msg_count number;
4882: l_msg_data varchar2(2000);
4883: BEGIN

Line 5077: p_pricing_attribs_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,

5073: p_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
5074: p_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
5075: p_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
5076: p_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
5077: p_pricing_attribs_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
5078: p_order_line_rec IN order_line_rec,
5079: p_trx_rec IN csi_datastructures_pub.transaction_rec,
5080: p_source IN varchar2,
5081: p_validate_only IN varchar2,

Line 5079: p_trx_rec IN csi_datastructures_pub.transaction_rec,

5075: p_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
5076: p_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
5077: p_pricing_attribs_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
5078: p_order_line_rec IN order_line_rec,
5079: p_trx_rec IN csi_datastructures_pub.transaction_rec,
5080: p_source IN varchar2,
5081: p_validate_only IN varchar2,
5082: px_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,
5083: x_return_status OUT NOCOPY varchar2,

Line 5082: px_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,

5078: p_order_line_rec IN order_line_rec,
5079: p_trx_rec IN csi_datastructures_pub.transaction_rec,
5080: p_source IN varchar2,
5081: p_validate_only IN varchar2,
5082: px_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec,
5083: x_return_status OUT NOCOPY varchar2,
5084: x_msg_count OUT NOCOPY number,
5085: x_msg_data OUT NOCOPY varchar2)
5086: IS

Line 5100: l_tmp_instance_rec csi_datastructures_pub.instance_rec;

5096: l_order_line_rec order_line_rec;
5097: l_item_control_rec item_control_rec;
5098:
5099: x_trx_sub_type_rec txn_sub_type_rec;
5100: l_tmp_instance_rec csi_datastructures_pub.instance_rec;
5101: l_upd_instance_rec csi_datastructures_pub.instance_rec;
5102: l_upd_txn_rec csi_datastructures_pub.transaction_rec;
5103: l_upd_party_tbl csi_datastructures_pub.party_tbl;
5104: l_upd_party_acct_tbl csi_datastructures_pub.party_account_tbl;

Line 5101: l_upd_instance_rec csi_datastructures_pub.instance_rec;

5097: l_item_control_rec item_control_rec;
5098:
5099: x_trx_sub_type_rec txn_sub_type_rec;
5100: l_tmp_instance_rec csi_datastructures_pub.instance_rec;
5101: l_upd_instance_rec csi_datastructures_pub.instance_rec;
5102: l_upd_txn_rec csi_datastructures_pub.transaction_rec;
5103: l_upd_party_tbl csi_datastructures_pub.party_tbl;
5104: l_upd_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5105: l_upd_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

Line 5102: l_upd_txn_rec csi_datastructures_pub.transaction_rec;

5098:
5099: x_trx_sub_type_rec txn_sub_type_rec;
5100: l_tmp_instance_rec csi_datastructures_pub.instance_rec;
5101: l_upd_instance_rec csi_datastructures_pub.instance_rec;
5102: l_upd_txn_rec csi_datastructures_pub.transaction_rec;
5103: l_upd_party_tbl csi_datastructures_pub.party_tbl;
5104: l_upd_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5105: l_upd_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5106: l_upd_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 5103: l_upd_party_tbl csi_datastructures_pub.party_tbl;

5099: x_trx_sub_type_rec txn_sub_type_rec;
5100: l_tmp_instance_rec csi_datastructures_pub.instance_rec;
5101: l_upd_instance_rec csi_datastructures_pub.instance_rec;
5102: l_upd_txn_rec csi_datastructures_pub.transaction_rec;
5103: l_upd_party_tbl csi_datastructures_pub.party_tbl;
5104: l_upd_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5105: l_upd_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5106: l_upd_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5107: l_upd_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 5104: l_upd_party_acct_tbl csi_datastructures_pub.party_account_tbl;

5100: l_tmp_instance_rec csi_datastructures_pub.instance_rec;
5101: l_upd_instance_rec csi_datastructures_pub.instance_rec;
5102: l_upd_txn_rec csi_datastructures_pub.transaction_rec;
5103: l_upd_party_tbl csi_datastructures_pub.party_tbl;
5104: l_upd_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5105: l_upd_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5106: l_upd_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5107: l_upd_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5108: l_upd_org_units_tbl csi_datastructures_pub.organization_units_tbl;

Line 5105: l_upd_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

5101: l_upd_instance_rec csi_datastructures_pub.instance_rec;
5102: l_upd_txn_rec csi_datastructures_pub.transaction_rec;
5103: l_upd_party_tbl csi_datastructures_pub.party_tbl;
5104: l_upd_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5105: l_upd_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5106: l_upd_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5107: l_upd_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5108: l_upd_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5109: l_inst_id_lst csi_datastructures_pub.id_tbl;

Line 5106: l_upd_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

5102: l_upd_txn_rec csi_datastructures_pub.transaction_rec;
5103: l_upd_party_tbl csi_datastructures_pub.party_tbl;
5104: l_upd_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5105: l_upd_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5106: l_upd_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5107: l_upd_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5108: l_upd_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5109: l_inst_id_lst csi_datastructures_pub.id_tbl;
5110: l_upd_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;

Line 5107: l_upd_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

5103: l_upd_party_tbl csi_datastructures_pub.party_tbl;
5104: l_upd_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5105: l_upd_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5106: l_upd_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5107: l_upd_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5108: l_upd_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5109: l_inst_id_lst csi_datastructures_pub.id_tbl;
5110: l_upd_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
5111:

Line 5108: l_upd_org_units_tbl csi_datastructures_pub.organization_units_tbl;

5104: l_upd_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5105: l_upd_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5106: l_upd_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5107: l_upd_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5108: l_upd_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5109: l_inst_id_lst csi_datastructures_pub.id_tbl;
5110: l_upd_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
5111:
5112: l_upd_so_instance_rec csi_datastructures_pub.instance_rec;

Line 5109: l_inst_id_lst csi_datastructures_pub.id_tbl;

5105: l_upd_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5106: l_upd_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5107: l_upd_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5108: l_upd_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5109: l_inst_id_lst csi_datastructures_pub.id_tbl;
5110: l_upd_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
5111:
5112: l_upd_so_instance_rec csi_datastructures_pub.instance_rec;
5113: l_upd_so_party_tbl csi_datastructures_pub.party_tbl;

Line 5110: l_upd_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;

5106: l_upd_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5107: l_upd_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5108: l_upd_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5109: l_inst_id_lst csi_datastructures_pub.id_tbl;
5110: l_upd_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
5111:
5112: l_upd_so_instance_rec csi_datastructures_pub.instance_rec;
5113: l_upd_so_party_tbl csi_datastructures_pub.party_tbl;
5114: l_upd_so_party_acct_tbl csi_datastructures_pub.party_account_tbl;

Line 5112: l_upd_so_instance_rec csi_datastructures_pub.instance_rec;

5108: l_upd_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5109: l_inst_id_lst csi_datastructures_pub.id_tbl;
5110: l_upd_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
5111:
5112: l_upd_so_instance_rec csi_datastructures_pub.instance_rec;
5113: l_upd_so_party_tbl csi_datastructures_pub.party_tbl;
5114: l_upd_so_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5115: l_upd_so_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5116: l_upd_so_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 5113: l_upd_so_party_tbl csi_datastructures_pub.party_tbl;

5109: l_inst_id_lst csi_datastructures_pub.id_tbl;
5110: l_upd_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
5111:
5112: l_upd_so_instance_rec csi_datastructures_pub.instance_rec;
5113: l_upd_so_party_tbl csi_datastructures_pub.party_tbl;
5114: l_upd_so_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5115: l_upd_so_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5116: l_upd_so_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5117: l_upd_so_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 5114: l_upd_so_party_acct_tbl csi_datastructures_pub.party_account_tbl;

5110: l_upd_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
5111:
5112: l_upd_so_instance_rec csi_datastructures_pub.instance_rec;
5113: l_upd_so_party_tbl csi_datastructures_pub.party_tbl;
5114: l_upd_so_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5115: l_upd_so_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5116: l_upd_so_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5117: l_upd_so_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5118: l_upd_so_org_units_tbl csi_datastructures_pub.organization_units_tbl;

Line 5115: l_upd_so_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

5111:
5112: l_upd_so_instance_rec csi_datastructures_pub.instance_rec;
5113: l_upd_so_party_tbl csi_datastructures_pub.party_tbl;
5114: l_upd_so_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5115: l_upd_so_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5116: l_upd_so_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5117: l_upd_so_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5118: l_upd_so_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5119:

Line 5116: l_upd_so_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

5112: l_upd_so_instance_rec csi_datastructures_pub.instance_rec;
5113: l_upd_so_party_tbl csi_datastructures_pub.party_tbl;
5114: l_upd_so_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5115: l_upd_so_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5116: l_upd_so_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5117: l_upd_so_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5118: l_upd_so_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5119:
5120: l_cre_instance_rec csi_datastructures_pub.instance_rec;

Line 5117: l_upd_so_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

5113: l_upd_so_party_tbl csi_datastructures_pub.party_tbl;
5114: l_upd_so_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5115: l_upd_so_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5116: l_upd_so_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5117: l_upd_so_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5118: l_upd_so_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5119:
5120: l_cre_instance_rec csi_datastructures_pub.instance_rec;
5121: l_cre_txn_rec csi_datastructures_pub.transaction_rec;

Line 5118: l_upd_so_org_units_tbl csi_datastructures_pub.organization_units_tbl;

5114: l_upd_so_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5115: l_upd_so_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5116: l_upd_so_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5117: l_upd_so_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5118: l_upd_so_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5119:
5120: l_cre_instance_rec csi_datastructures_pub.instance_rec;
5121: l_cre_txn_rec csi_datastructures_pub.transaction_rec;
5122: l_cre_party_tbl csi_datastructures_pub.party_tbl;

Line 5120: l_cre_instance_rec csi_datastructures_pub.instance_rec;

5116: l_upd_so_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5117: l_upd_so_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5118: l_upd_so_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5119:
5120: l_cre_instance_rec csi_datastructures_pub.instance_rec;
5121: l_cre_txn_rec csi_datastructures_pub.transaction_rec;
5122: l_cre_party_tbl csi_datastructures_pub.party_tbl;
5123: l_cre_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5124: l_cre_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

Line 5121: l_cre_txn_rec csi_datastructures_pub.transaction_rec;

5117: l_upd_so_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5118: l_upd_so_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5119:
5120: l_cre_instance_rec csi_datastructures_pub.instance_rec;
5121: l_cre_txn_rec csi_datastructures_pub.transaction_rec;
5122: l_cre_party_tbl csi_datastructures_pub.party_tbl;
5123: l_cre_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5124: l_cre_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5125: l_cre_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 5122: l_cre_party_tbl csi_datastructures_pub.party_tbl;

5118: l_upd_so_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5119:
5120: l_cre_instance_rec csi_datastructures_pub.instance_rec;
5121: l_cre_txn_rec csi_datastructures_pub.transaction_rec;
5122: l_cre_party_tbl csi_datastructures_pub.party_tbl;
5123: l_cre_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5124: l_cre_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5125: l_cre_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5126: l_cre_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 5123: l_cre_party_acct_tbl csi_datastructures_pub.party_account_tbl;

5119:
5120: l_cre_instance_rec csi_datastructures_pub.instance_rec;
5121: l_cre_txn_rec csi_datastructures_pub.transaction_rec;
5122: l_cre_party_tbl csi_datastructures_pub.party_tbl;
5123: l_cre_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5124: l_cre_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5125: l_cre_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5126: l_cre_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5127: l_cre_org_units_tbl csi_datastructures_pub.organization_units_tbl;

Line 5124: l_cre_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

5120: l_cre_instance_rec csi_datastructures_pub.instance_rec;
5121: l_cre_txn_rec csi_datastructures_pub.transaction_rec;
5122: l_cre_party_tbl csi_datastructures_pub.party_tbl;
5123: l_cre_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5124: l_cre_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5125: l_cre_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5126: l_cre_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5127: l_cre_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5128: l_cre_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;

Line 5125: l_cre_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

5121: l_cre_txn_rec csi_datastructures_pub.transaction_rec;
5122: l_cre_party_tbl csi_datastructures_pub.party_tbl;
5123: l_cre_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5124: l_cre_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5125: l_cre_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5126: l_cre_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5127: l_cre_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5128: l_cre_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
5129: l_cre_systems_rec csi_datastructures_pub.system_rec;

Line 5126: l_cre_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

5122: l_cre_party_tbl csi_datastructures_pub.party_tbl;
5123: l_cre_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5124: l_cre_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5125: l_cre_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5126: l_cre_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5127: l_cre_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5128: l_cre_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
5129: l_cre_systems_rec csi_datastructures_pub.system_rec;
5130:

Line 5127: l_cre_org_units_tbl csi_datastructures_pub.organization_units_tbl;

5123: l_cre_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5124: l_cre_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5125: l_cre_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5126: l_cre_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5127: l_cre_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5128: l_cre_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
5129: l_cre_systems_rec csi_datastructures_pub.system_rec;
5130:
5131: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;

Line 5128: l_cre_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;

5124: l_cre_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5125: l_cre_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5126: l_cre_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5127: l_cre_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5128: l_cre_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
5129: l_cre_systems_rec csi_datastructures_pub.system_rec;
5130:
5131: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
5132: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;

Line 5129: l_cre_systems_rec csi_datastructures_pub.system_rec;

5125: l_cre_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5126: l_cre_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5127: l_cre_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5128: l_cre_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
5129: l_cre_systems_rec csi_datastructures_pub.system_rec;
5130:
5131: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
5132: l_txn_line_query_rec csi_t_datastructures_grp.txn_line_query_rec;
5133: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;

Line 5152: l_old_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

5148:
5149: /* Pricing Attributes variables */
5150: l_old_index NUMBER := 0;
5151: l_new_index NUMBER := 0;
5152: l_old_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5153: l_new_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5154:
5155: /* Extended Attributes variables */
5156: l_ext_old_index NUMBER := 0;

Line 5153: l_new_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

5149: /* Pricing Attributes variables */
5150: l_old_index NUMBER := 0;
5151: l_new_index NUMBER := 0;
5152: l_old_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5153: l_new_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5154:
5155: /* Extended Attributes variables */
5156: l_ext_old_index NUMBER := 0;
5157: l_ext_new_index NUMBER := 0;

Line 5158: l_old_extended_attribs_tbl csi_datastructures_pub.extend_attrib_values_tbl;

5154:
5155: /* Extended Attributes variables */
5156: l_ext_old_index NUMBER := 0;
5157: l_ext_new_index NUMBER := 0;
5158: l_old_extended_attribs_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5159: l_new_extended_attribs_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5160:
5161: /* Decrement and Increment Logic variables */
5162: l_un_exp_instance_rec csi_datastructures_pub.instance_rec;

Line 5159: l_new_extended_attribs_tbl csi_datastructures_pub.extend_attrib_values_tbl;

5155: /* Extended Attributes variables */
5156: l_ext_old_index NUMBER := 0;
5157: l_ext_new_index NUMBER := 0;
5158: l_old_extended_attribs_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5159: l_new_extended_attribs_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5160:
5161: /* Decrement and Increment Logic variables */
5162: l_un_exp_instance_rec csi_datastructures_pub.instance_rec;
5163: l_un_exp_party_tbl csi_datastructures_pub.party_tbl;

Line 5162: l_un_exp_instance_rec csi_datastructures_pub.instance_rec;

5158: l_old_extended_attribs_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5159: l_new_extended_attribs_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5160:
5161: /* Decrement and Increment Logic variables */
5162: l_un_exp_instance_rec csi_datastructures_pub.instance_rec;
5163: l_un_exp_party_tbl csi_datastructures_pub.party_tbl;
5164: l_un_exp_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5165: l_un_exp_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5166: l_un_exp_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 5163: l_un_exp_party_tbl csi_datastructures_pub.party_tbl;

5159: l_new_extended_attribs_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5160:
5161: /* Decrement and Increment Logic variables */
5162: l_un_exp_instance_rec csi_datastructures_pub.instance_rec;
5163: l_un_exp_party_tbl csi_datastructures_pub.party_tbl;
5164: l_un_exp_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5165: l_un_exp_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5166: l_un_exp_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5167: l_un_exp_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 5164: l_un_exp_party_acct_tbl csi_datastructures_pub.party_account_tbl;

5160:
5161: /* Decrement and Increment Logic variables */
5162: l_un_exp_instance_rec csi_datastructures_pub.instance_rec;
5163: l_un_exp_party_tbl csi_datastructures_pub.party_tbl;
5164: l_un_exp_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5165: l_un_exp_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5166: l_un_exp_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5167: l_un_exp_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5168: l_un_exp_org_units_tbl csi_datastructures_pub.organization_units_tbl;

Line 5165: l_un_exp_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

5161: /* Decrement and Increment Logic variables */
5162: l_un_exp_instance_rec csi_datastructures_pub.instance_rec;
5163: l_un_exp_party_tbl csi_datastructures_pub.party_tbl;
5164: l_un_exp_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5165: l_un_exp_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5166: l_un_exp_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5167: l_un_exp_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5168: l_un_exp_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5169: l_un_exp_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;

Line 5166: l_un_exp_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

5162: l_un_exp_instance_rec csi_datastructures_pub.instance_rec;
5163: l_un_exp_party_tbl csi_datastructures_pub.party_tbl;
5164: l_un_exp_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5165: l_un_exp_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5166: l_un_exp_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5167: l_un_exp_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5168: l_un_exp_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5169: l_un_exp_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
5170: l_un_exp_systems_rec csi_datastructures_pub.system_rec;

Line 5167: l_un_exp_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

5163: l_un_exp_party_tbl csi_datastructures_pub.party_tbl;
5164: l_un_exp_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5165: l_un_exp_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5166: l_un_exp_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5167: l_un_exp_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5168: l_un_exp_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5169: l_un_exp_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
5170: l_un_exp_systems_rec csi_datastructures_pub.system_rec;
5171:

Line 5168: l_un_exp_org_units_tbl csi_datastructures_pub.organization_units_tbl;

5164: l_un_exp_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5165: l_un_exp_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5166: l_un_exp_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5167: l_un_exp_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5168: l_un_exp_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5169: l_un_exp_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
5170: l_un_exp_systems_rec csi_datastructures_pub.system_rec;
5171:
5172: l_trx_rec csi_datastructures_pub.transaction_rec;

Line 5169: l_un_exp_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;

5165: l_un_exp_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5166: l_un_exp_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5167: l_un_exp_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5168: l_un_exp_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5169: l_un_exp_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
5170: l_un_exp_systems_rec csi_datastructures_pub.system_rec;
5171:
5172: l_trx_rec csi_datastructures_pub.transaction_rec;
5173: l_auto_split_instances csi_datastructures_pub.instance_tbl;

Line 5170: l_un_exp_systems_rec csi_datastructures_pub.system_rec;

5166: l_un_exp_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5167: l_un_exp_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5168: l_un_exp_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5169: l_un_exp_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
5170: l_un_exp_systems_rec csi_datastructures_pub.system_rec;
5171:
5172: l_trx_rec csi_datastructures_pub.transaction_rec;
5173: l_auto_split_instances csi_datastructures_pub.instance_tbl;
5174:

Line 5172: l_trx_rec csi_datastructures_pub.transaction_rec;

5168: l_un_exp_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5169: l_un_exp_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
5170: l_un_exp_systems_rec csi_datastructures_pub.system_rec;
5171:
5172: l_trx_rec csi_datastructures_pub.transaction_rec;
5173: l_auto_split_instances csi_datastructures_pub.instance_tbl;
5174:
5175: l_split_src_inst_rec csi_datastructures_pub.instance_rec;
5176: l_split_src_trx_rec csi_datastructures_pub.transaction_rec;

Line 5173: l_auto_split_instances csi_datastructures_pub.instance_tbl;

5169: l_un_exp_ii_rltns_tbl csi_datastructures_pub.ii_relationship_tbl;
5170: l_un_exp_systems_rec csi_datastructures_pub.system_rec;
5171:
5172: l_trx_rec csi_datastructures_pub.transaction_rec;
5173: l_auto_split_instances csi_datastructures_pub.instance_tbl;
5174:
5175: l_split_src_inst_rec csi_datastructures_pub.instance_rec;
5176: l_split_src_trx_rec csi_datastructures_pub.transaction_rec;
5177: l_split_new_inst_rec csi_datastructures_pub.instance_rec;

Line 5175: l_split_src_inst_rec csi_datastructures_pub.instance_rec;

5171:
5172: l_trx_rec csi_datastructures_pub.transaction_rec;
5173: l_auto_split_instances csi_datastructures_pub.instance_tbl;
5174:
5175: l_split_src_inst_rec csi_datastructures_pub.instance_rec;
5176: l_split_src_trx_rec csi_datastructures_pub.transaction_rec;
5177: l_split_new_inst_rec csi_datastructures_pub.instance_rec;
5178: l_sys_query_rec csi_datastructures_pub.system_query_rec;
5179: x_systems_tbl csi_datastructures_pub.systems_tbl;

Line 5176: l_split_src_trx_rec csi_datastructures_pub.transaction_rec;

5172: l_trx_rec csi_datastructures_pub.transaction_rec;
5173: l_auto_split_instances csi_datastructures_pub.instance_tbl;
5174:
5175: l_split_src_inst_rec csi_datastructures_pub.instance_rec;
5176: l_split_src_trx_rec csi_datastructures_pub.transaction_rec;
5177: l_split_new_inst_rec csi_datastructures_pub.instance_rec;
5178: l_sys_query_rec csi_datastructures_pub.system_query_rec;
5179: x_systems_tbl csi_datastructures_pub.systems_tbl;
5180:

Line 5177: l_split_new_inst_rec csi_datastructures_pub.instance_rec;

5173: l_auto_split_instances csi_datastructures_pub.instance_tbl;
5174:
5175: l_split_src_inst_rec csi_datastructures_pub.instance_rec;
5176: l_split_src_trx_rec csi_datastructures_pub.transaction_rec;
5177: l_split_new_inst_rec csi_datastructures_pub.instance_rec;
5178: l_sys_query_rec csi_datastructures_pub.system_query_rec;
5179: x_systems_tbl csi_datastructures_pub.systems_tbl;
5180:
5181: /* expire item instance variables */

Line 5178: l_sys_query_rec csi_datastructures_pub.system_query_rec;

5174:
5175: l_split_src_inst_rec csi_datastructures_pub.instance_rec;
5176: l_split_src_trx_rec csi_datastructures_pub.transaction_rec;
5177: l_split_new_inst_rec csi_datastructures_pub.instance_rec;
5178: l_sys_query_rec csi_datastructures_pub.system_query_rec;
5179: x_systems_tbl csi_datastructures_pub.systems_tbl;
5180:
5181: /* expire item instance variables */
5182: l_exp_instance_rec csi_datastructures_pub.instance_rec;

Line 5179: x_systems_tbl csi_datastructures_pub.systems_tbl;

5175: l_split_src_inst_rec csi_datastructures_pub.instance_rec;
5176: l_split_src_trx_rec csi_datastructures_pub.transaction_rec;
5177: l_split_new_inst_rec csi_datastructures_pub.instance_rec;
5178: l_sys_query_rec csi_datastructures_pub.system_query_rec;
5179: x_systems_tbl csi_datastructures_pub.systems_tbl;
5180:
5181: /* expire item instance variables */
5182: l_exp_instance_rec csi_datastructures_pub.instance_rec;
5183: l_exp_instance_id_lst csi_datastructures_pub.id_tbl;

Line 5182: l_exp_instance_rec csi_datastructures_pub.instance_rec;

5178: l_sys_query_rec csi_datastructures_pub.system_query_rec;
5179: x_systems_tbl csi_datastructures_pub.systems_tbl;
5180:
5181: /* expire item instance variables */
5182: l_exp_instance_rec csi_datastructures_pub.instance_rec;
5183: l_exp_instance_id_lst csi_datastructures_pub.id_tbl;
5184: l_expire_flag BOOLEAN := FALSE;
5185:
5186: /* non source processing variables */

Line 5183: l_exp_instance_id_lst csi_datastructures_pub.id_tbl;

5179: x_systems_tbl csi_datastructures_pub.systems_tbl;
5180:
5181: /* expire item instance variables */
5182: l_exp_instance_rec csi_datastructures_pub.instance_rec;
5183: l_exp_instance_id_lst csi_datastructures_pub.id_tbl;
5184: l_expire_flag BOOLEAN := FALSE;
5185:
5186: /* non source processing variables */
5187: l_ns_instance_rec csi_datastructures_pub.instance_rec;

Line 5187: l_ns_instance_rec csi_datastructures_pub.instance_rec;

5183: l_exp_instance_id_lst csi_datastructures_pub.id_tbl;
5184: l_expire_flag BOOLEAN := FALSE;
5185:
5186: /* non source processing variables */
5187: l_ns_instance_rec csi_datastructures_pub.instance_rec;
5188: l_ns_party_tbl csi_datastructures_pub.party_tbl;
5189: l_ns_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5190: l_ns_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5191: l_ns_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 5188: l_ns_party_tbl csi_datastructures_pub.party_tbl;

5184: l_expire_flag BOOLEAN := FALSE;
5185:
5186: /* non source processing variables */
5187: l_ns_instance_rec csi_datastructures_pub.instance_rec;
5188: l_ns_party_tbl csi_datastructures_pub.party_tbl;
5189: l_ns_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5190: l_ns_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5191: l_ns_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5192: l_ns_org_units_tbl csi_datastructures_pub.organization_units_tbl;

Line 5189: l_ns_party_acct_tbl csi_datastructures_pub.party_account_tbl;

5185:
5186: /* non source processing variables */
5187: l_ns_instance_rec csi_datastructures_pub.instance_rec;
5188: l_ns_party_tbl csi_datastructures_pub.party_tbl;
5189: l_ns_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5190: l_ns_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5191: l_ns_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5192: l_ns_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5193: l_ns_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

Line 5190: l_ns_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

5186: /* non source processing variables */
5187: l_ns_instance_rec csi_datastructures_pub.instance_rec;
5188: l_ns_party_tbl csi_datastructures_pub.party_tbl;
5189: l_ns_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5190: l_ns_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5191: l_ns_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5192: l_ns_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5193: l_ns_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5194: l_ns_inst_id_lst csi_datastructures_pub.id_tbl;

Line 5191: l_ns_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

5187: l_ns_instance_rec csi_datastructures_pub.instance_rec;
5188: l_ns_party_tbl csi_datastructures_pub.party_tbl;
5189: l_ns_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5190: l_ns_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5191: l_ns_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5192: l_ns_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5193: l_ns_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5194: l_ns_inst_id_lst csi_datastructures_pub.id_tbl;
5195:

Line 5192: l_ns_org_units_tbl csi_datastructures_pub.organization_units_tbl;

5188: l_ns_party_tbl csi_datastructures_pub.party_tbl;
5189: l_ns_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5190: l_ns_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5191: l_ns_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5192: l_ns_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5193: l_ns_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5194: l_ns_inst_id_lst csi_datastructures_pub.id_tbl;
5195:
5196: l_chg_instance_rec csi_datastructures_pub.instance_rec;

Line 5193: l_ns_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

5189: l_ns_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5190: l_ns_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5191: l_ns_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5192: l_ns_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5193: l_ns_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5194: l_ns_inst_id_lst csi_datastructures_pub.id_tbl;
5195:
5196: l_chg_instance_rec csi_datastructures_pub.instance_rec;
5197: l_chg_party_tbl csi_datastructures_pub.party_tbl;

Line 5194: l_ns_inst_id_lst csi_datastructures_pub.id_tbl;

5190: l_ns_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5191: l_ns_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5192: l_ns_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5193: l_ns_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5194: l_ns_inst_id_lst csi_datastructures_pub.id_tbl;
5195:
5196: l_chg_instance_rec csi_datastructures_pub.instance_rec;
5197: l_chg_party_tbl csi_datastructures_pub.party_tbl;
5198: l_chg_party_acct_tbl csi_datastructures_pub.party_account_tbl;

Line 5196: l_chg_instance_rec csi_datastructures_pub.instance_rec;

5192: l_ns_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5193: l_ns_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5194: l_ns_inst_id_lst csi_datastructures_pub.id_tbl;
5195:
5196: l_chg_instance_rec csi_datastructures_pub.instance_rec;
5197: l_chg_party_tbl csi_datastructures_pub.party_tbl;
5198: l_chg_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5199: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5200: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 5197: l_chg_party_tbl csi_datastructures_pub.party_tbl;

5193: l_ns_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5194: l_ns_inst_id_lst csi_datastructures_pub.id_tbl;
5195:
5196: l_chg_instance_rec csi_datastructures_pub.instance_rec;
5197: l_chg_party_tbl csi_datastructures_pub.party_tbl;
5198: l_chg_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5199: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5200: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5201: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;

Line 5198: l_chg_party_acct_tbl csi_datastructures_pub.party_account_tbl;

5194: l_ns_inst_id_lst csi_datastructures_pub.id_tbl;
5195:
5196: l_chg_instance_rec csi_datastructures_pub.instance_rec;
5197: l_chg_party_tbl csi_datastructures_pub.party_tbl;
5198: l_chg_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5199: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5200: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5201: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5202: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

Line 5199: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

5195:
5196: l_chg_instance_rec csi_datastructures_pub.instance_rec;
5197: l_chg_party_tbl csi_datastructures_pub.party_tbl;
5198: l_chg_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5199: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5200: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5201: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5202: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5203: l_chg_inst_id_lst csi_datastructures_pub.id_tbl;

Line 5200: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;

5196: l_chg_instance_rec csi_datastructures_pub.instance_rec;
5197: l_chg_party_tbl csi_datastructures_pub.party_tbl;
5198: l_chg_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5199: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5200: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5201: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5202: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5203: l_chg_inst_id_lst csi_datastructures_pub.id_tbl;
5204: l_chg_txn_rec csi_datastructures_pub.transaction_rec;

Line 5201: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;

5197: l_chg_party_tbl csi_datastructures_pub.party_tbl;
5198: l_chg_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5199: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5200: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5201: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5202: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5203: l_chg_inst_id_lst csi_datastructures_pub.id_tbl;
5204: l_chg_txn_rec csi_datastructures_pub.transaction_rec;
5205:

Line 5202: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;

5198: l_chg_party_acct_tbl csi_datastructures_pub.party_account_tbl;
5199: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5200: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5201: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5202: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5203: l_chg_inst_id_lst csi_datastructures_pub.id_tbl;
5204: l_chg_txn_rec csi_datastructures_pub.transaction_rec;
5205:
5206: l_all_tld_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

Line 5203: l_chg_inst_id_lst csi_datastructures_pub.id_tbl;

5199: l_chg_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
5200: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5201: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5202: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5203: l_chg_inst_id_lst csi_datastructures_pub.id_tbl;
5204: l_chg_txn_rec csi_datastructures_pub.transaction_rec;
5205:
5206: l_all_tld_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5207: l_all_tld_account_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;

Line 5204: l_chg_txn_rec csi_datastructures_pub.transaction_rec;

5200: l_chg_ext_attrib_val_tbl csi_datastructures_pub.extend_attrib_values_tbl;
5201: l_chg_org_units_tbl csi_datastructures_pub.organization_units_tbl;
5202: l_chg_inst_asset_tbl csi_datastructures_pub.instance_asset_tbl;
5203: l_chg_inst_id_lst csi_datastructures_pub.id_tbl;
5204: l_chg_txn_rec csi_datastructures_pub.transaction_rec;
5205:
5206: l_all_tld_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;
5207: l_all_tld_account_tbl csi_t_datastructures_grp.txn_pty_acct_detail_tbl;
5208: l_all_tld_oa_tbl csi_t_datastructures_grp.txn_org_assgn_tbl;

Line 5267: l_exp_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;

5263: is_instance_rma BOOLEAN := FALSE;
5264: l_relationship_id NUMBER;
5265: l_ii_rel_obj_ver_num NUMBER;
5266: l_instance_pty_id NUMBER;
5267: l_exp_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;
5268: l_exp_instance_id_tbl csi_datastructures_pub.id_tbl;
5269:
5270: l_dflt_inst_status_id NUMBER;
5271: l_owner_party_id NUMBER;

Line 5268: l_exp_instance_id_tbl csi_datastructures_pub.id_tbl;

5264: l_relationship_id NUMBER;
5265: l_ii_rel_obj_ver_num NUMBER;
5266: l_instance_pty_id NUMBER;
5267: l_exp_ii_relationship_rec csi_datastructures_pub.ii_relationship_rec;
5268: l_exp_instance_id_tbl csi_datastructures_pub.id_tbl;
5269:
5270: l_dflt_inst_status_id NUMBER;
5271: l_owner_party_id NUMBER;
5272: l_internal_party_id NUMBER;

Line 5277: l_bom_std_item_rec csi_datastructures_pub.instance_rec;

5273: l_ownership_flag VARCHAR2(1);
5274:
5275: -- explode_bom variables
5276: l_bom_ind binary_integer := 0;
5277: l_bom_std_item_rec csi_datastructures_pub.instance_rec;
5278: l_bom_std_item_tbl csi_datastructures_pub.instance_tbl;
5279:
5280: l_comp_instance_tbl csi_datastructures_pub.instance_tbl;
5281: l_comp_relation_tbl csi_datastructures_pub.ii_relationship_tbl;

Line 5278: l_bom_std_item_tbl csi_datastructures_pub.instance_tbl;

5274:
5275: -- explode_bom variables
5276: l_bom_ind binary_integer := 0;
5277: l_bom_std_item_rec csi_datastructures_pub.instance_rec;
5278: l_bom_std_item_tbl csi_datastructures_pub.instance_tbl;
5279:
5280: l_comp_instance_tbl csi_datastructures_pub.instance_tbl;
5281: l_comp_relation_tbl csi_datastructures_pub.ii_relationship_tbl;
5282:

Line 5280: l_comp_instance_tbl csi_datastructures_pub.instance_tbl;

5276: l_bom_ind binary_integer := 0;
5277: l_bom_std_item_rec csi_datastructures_pub.instance_rec;
5278: l_bom_std_item_tbl csi_datastructures_pub.instance_tbl;
5279:
5280: l_comp_instance_tbl csi_datastructures_pub.instance_tbl;
5281: l_comp_relation_tbl csi_datastructures_pub.ii_relationship_tbl;
5282:
5283: l_active_end_date date := fnd_api.g_miss_date;
5284: l_call_contracts varchar2(1) := fnd_api.g_true;

Line 5281: l_comp_relation_tbl csi_datastructures_pub.ii_relationship_tbl;

5277: l_bom_std_item_rec csi_datastructures_pub.instance_rec;
5278: l_bom_std_item_tbl csi_datastructures_pub.instance_tbl;
5279:
5280: l_comp_instance_tbl csi_datastructures_pub.instance_tbl;
5281: l_comp_relation_tbl csi_datastructures_pub.ii_relationship_tbl;
5282:
5283: l_active_end_date date := fnd_api.g_miss_date;
5284: l_call_contracts varchar2(1) := fnd_api.g_true;
5285:

Line 5295: l_owner_pty_rec csi_datastructures_pub.party_rec;

5291: -- Partner Order changes
5292: l_upd_party_site_id number;
5293: l_cre_party_site_id number;
5294:
5295: l_owner_pty_rec csi_datastructures_pub.party_rec;
5296: l_owner_acct_rec csi_datastructures_pub.party_account_rec;
5297:
5298: --brmanesh 01-DEC-2003
5299: l_wip_job_id number;

Line 5296: l_owner_acct_rec csi_datastructures_pub.party_account_rec;

5292: l_upd_party_site_id number;
5293: l_cre_party_site_id number;
5294:
5295: l_owner_pty_rec csi_datastructures_pub.party_rec;
5296: l_owner_acct_rec csi_datastructures_pub.party_account_rec;
5297:
5298: --brmanesh 01-DEC-2003
5299: l_wip_job_id number;
5300: l_wip_iir_tbl csi_datastructures_pub.ii_relationship_tbl;

Line 5300: l_wip_iir_tbl csi_datastructures_pub.ii_relationship_tbl;

5296: l_owner_acct_rec csi_datastructures_pub.party_account_rec;
5297:
5298: --brmanesh 01-DEC-2003
5299: l_wip_job_id number;
5300: l_wip_iir_tbl csi_datastructures_pub.ii_relationship_tbl;
5301: l_cps_tbl customer_products_tbl;
5302: l_cp_ind binary_integer := 0;
5303: l_all_cps_tbl customer_products_tbl;
5304: l_single_cps_tbl customer_products_tbl;

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

6165: l_owner_party_id <> l_upd_party_tbl(1).party_id
6166: THEN
6167:
6168: l_ownership_flag:=
6169: NVL(csi_datastructures_pub.g_install_param_rec.ownership_override_at_txn,'N');
6170:
6171: IF l_ownership_flag = 'N' Then
6172: fnd_message.set_name('CSI','CSI_SHIP_OWNER_MISMATCH');
6173: fnd_message.set_token('OLD_PARTY_ID',l_owner_party_id);

Line 8730: px_trx_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec)

8726:
8727: PROCEDURE oke_shipment(
8728: p_mtl_txn_id IN number,
8729: x_return_status OUT NOCOPY varchar2,
8730: px_trx_error_rec IN OUT NOCOPY csi_datastructures_pub.transaction_error_rec)
8731: IS
8732:
8733: l_oke_source_table varchar2(30) := csi_interface_pkg.g_oke_source_table;
8734:

Line 8745: l_csi_txn_rec csi_datastructures_pub.transaction_rec;

8741:
8742: l_source_header_rec csi_interface_pkg.source_header_rec;
8743: l_source_line_rec csi_interface_pkg.source_line_rec;
8744:
8745: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
8746:
8747: l_txn_line_rec csi_t_datastructures_grp.txn_line_rec;
8748: l_txn_line_detail_tbl csi_t_datastructures_grp.txn_line_detail_tbl;
8749: l_txn_party_tbl csi_t_datastructures_grp.txn_party_detail_tbl;

Line 8756: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

8752: l_txn_ii_rltns_tbl csi_t_datastructures_grp.txn_ii_rltns_tbl;
8753: l_txn_eav_tbl csi_t_datastructures_grp.txn_ext_attrib_vals_tbl;
8754: l_txn_systems_tbl csi_t_datastructures_grp.txn_systems_tbl;
8755:
8756: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
8757:
8758: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
8759: l_return_message varchar2(2000);
8760: l_msg_count number;

Line 8763: l_error_rec csi_datastructures_pub.transaction_error_rec;

8759: l_return_message varchar2(2000);
8760: l_msg_count number;
8761: l_msg_data varchar2(2000);
8762:
8763: l_error_rec csi_datastructures_pub.transaction_error_rec;
8764:
8765: BEGIN
8766:
8767: savepoint oke_shipment;