eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_DIAGNOSTICS_PKG dependencies on CSI_DATASTRUCTURES_PUB

Line 283: p_inst_tbl IN csi_datastructures_pub.instance_tbl

279:
280: --
281: PROCEDURE Build_Inst_Rec_of_Table
282: (
283: p_inst_tbl IN csi_datastructures_pub.instance_tbl
284: ,p_inst_rec_tab IN OUT NOCOPY csi_diagnostics_pkg.instance_rec_tab
285: ,p_inst_hist_tbl IN OUT NOCOPY csi_diagnostics_pkg.T_NUM
286: ) IS
287: BEGIN

Line 371: p_ii_relationship_tbl IN csi_datastructures_pub.ii_relationship_tbl

367: END Build_Inst_Rec_of_Table;
368: --
369: PROCEDURE Build_Rel_Rec_of_Table
370: (
371: p_ii_relationship_tbl IN csi_datastructures_pub.ii_relationship_tbl
372: ,p_ii_relationship_rec_tab IN OUT NOCOPY csi_diagnostics_pkg.ii_relationship_rec_tab
373: ,p_rel_hist_tbl IN OUT NOCOPY csi_diagnostics_pkg.T_NUM
374: ) IS
375: BEGIN

Line 412: p_version_label_tbl IN csi_datastructures_pub.version_label_tbl

408: END Build_Rel_Rec_of_Table;
409: --
410: PROCEDURE Build_Ver_Label_Rec_of_Table
411: (
412: p_version_label_tbl IN csi_datastructures_pub.version_label_tbl
413: ,p_version_label_rec_tab IN OUT NOCOPY csi_diagnostics_pkg.version_label_rec_tab
414: ,p_ver_label_hist_tbl IN OUT NOCOPY csi_diagnostics_pkg.T_NUM
415: ) IS
416: BEGIN

Line 449: ( p_party_tbl IN csi_datastructures_pub.party_tbl

445: END LOOP;
446: END Build_Ver_Label_Rec_of_Table;
447: --
448: PROCEDURE Build_Party_Rec_of_Table
449: ( p_party_tbl IN csi_datastructures_pub.party_tbl
450: ,p_party_rec_tab IN OUT NOCOPY csi_diagnostics_pkg.party_rec_tab
451: ,p_party_hist_tbl IN OUT NOCOPY csi_diagnostics_pkg.T_NUM
452: ) IS
453: BEGIN

Line 491: p_account_tbl IN csi_datastructures_pub.party_account_tbl

487: END Build_Party_Rec_of_Table;
488: --
489: PROCEDURE Build_Acct_Rec_of_Table
490: (
491: p_account_tbl IN csi_datastructures_pub.party_account_tbl
492: ,p_account_rec_tab IN OUT NOCOPY csi_diagnostics_pkg.account_rec_tab
493: ,p_account_hist_tbl IN OUT NOCOPY csi_diagnostics_pkg.T_NUM
494: ) IS
495: BEGIN

Line 534: p_org_tbl IN csi_datastructures_pub.organization_units_tbl

530: END Build_Acct_Rec_of_Table;
531: --
532: PROCEDURE Build_Org_Rec_of_Table
533: (
534: p_org_tbl IN csi_datastructures_pub.organization_units_tbl
535: ,p_org_units_rec_tab IN OUT NOCOPY csi_diagnostics_pkg.org_units_rec_tab
536: ,p_org_hist_tbl IN OUT NOCOPY csi_diagnostics_pkg.T_NUM
537: ) IS
538: BEGIN

Line 571: p_pricing_tbl IN csi_datastructures_pub.pricing_attribs_tbl

567: END Build_Org_Rec_of_Table;
568: --
569: PROCEDURE Build_pricing_Rec_of_Table
570: (
571: p_pricing_tbl IN csi_datastructures_pub.pricing_attribs_tbl
572: ,p_pricing_rec_tab IN OUT NOCOPY csi_diagnostics_pkg.pricing_attribs_rec_tab
573: ,p_pricing_hist_tbl IN OUT NOCOPY csi_diagnostics_pkg.T_NUM
574: ) IS
575: BEGIN

Line 707: p_ext_attr_tbl IN csi_datastructures_pub.extend_attrib_values_tbl

703: END Build_pricing_Rec_of_Table;
704: --
705: PROCEDURE Build_Ext_Attr_Rec_Table
706: (
707: p_ext_attr_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
708: ,p_ext_attr_rec_tab IN OUT NOCOPY csi_diagnostics_pkg.extend_attrib_values_rec_tab
709: ,p_ext_hist_tbl IN OUT NOCOPY csi_diagnostics_pkg.T_NUM
710: ) IS
711:

Line 746: p_asset_tbl IN csi_datastructures_pub.instance_asset_tbl

742: END Build_Ext_Attr_Rec_Table;
743: --
744: PROCEDURE Build_Asset_Rec_Table
745: (
746: p_asset_tbl IN csi_datastructures_pub.instance_asset_tbl
747: ,p_asset_rec_tab IN OUT NOCOPY csi_diagnostics_pkg.instance_asset_rec_tab
748: ,p_asset_hist_tbl IN OUT NOCOPY csi_diagnostics_pkg.T_NUM
749: ) IS
750:

Line 774: p_inst_h_rec IN csi_datastructures_pub.instance_header_rec,

770: END Build_Asset_Rec_Table;
771: --
772:
773: PROCEDURE make_non_header(
774: p_inst_h_rec IN csi_datastructures_pub.instance_header_rec,
775: p_pty_h_tbl IN csi_datastructures_pub.party_header_tbl,
776: p_pa_h_tbl IN csi_datastructures_pub.party_account_header_tbl,
777: p_ou_h_tbl IN csi_datastructures_pub.org_units_header_tbl,
778: p_asset_h_tbl IN csi_datastructures_pub.instance_asset_header_tbl,

Line 775: p_pty_h_tbl IN csi_datastructures_pub.party_header_tbl,

771: --
772:
773: PROCEDURE make_non_header(
774: p_inst_h_rec IN csi_datastructures_pub.instance_header_rec,
775: p_pty_h_tbl IN csi_datastructures_pub.party_header_tbl,
776: p_pa_h_tbl IN csi_datastructures_pub.party_account_header_tbl,
777: p_ou_h_tbl IN csi_datastructures_pub.org_units_header_tbl,
778: p_asset_h_tbl IN csi_datastructures_pub.instance_asset_header_tbl,
779: x_inst_rec OUT nocopy csi_datastructures_pub.instance_rec,

Line 776: p_pa_h_tbl IN csi_datastructures_pub.party_account_header_tbl,

772:
773: PROCEDURE make_non_header(
774: p_inst_h_rec IN csi_datastructures_pub.instance_header_rec,
775: p_pty_h_tbl IN csi_datastructures_pub.party_header_tbl,
776: p_pa_h_tbl IN csi_datastructures_pub.party_account_header_tbl,
777: p_ou_h_tbl IN csi_datastructures_pub.org_units_header_tbl,
778: p_asset_h_tbl IN csi_datastructures_pub.instance_asset_header_tbl,
779: x_inst_rec OUT nocopy csi_datastructures_pub.instance_rec,
780: x_pty_tbl OUT nocopy csi_datastructures_pub.party_tbl,

Line 777: p_ou_h_tbl IN csi_datastructures_pub.org_units_header_tbl,

773: PROCEDURE make_non_header(
774: p_inst_h_rec IN csi_datastructures_pub.instance_header_rec,
775: p_pty_h_tbl IN csi_datastructures_pub.party_header_tbl,
776: p_pa_h_tbl IN csi_datastructures_pub.party_account_header_tbl,
777: p_ou_h_tbl IN csi_datastructures_pub.org_units_header_tbl,
778: p_asset_h_tbl IN csi_datastructures_pub.instance_asset_header_tbl,
779: x_inst_rec OUT nocopy csi_datastructures_pub.instance_rec,
780: x_pty_tbl OUT nocopy csi_datastructures_pub.party_tbl,
781: x_pa_tbl OUT nocopy csi_datastructures_pub.party_account_tbl,

Line 778: p_asset_h_tbl IN csi_datastructures_pub.instance_asset_header_tbl,

774: p_inst_h_rec IN csi_datastructures_pub.instance_header_rec,
775: p_pty_h_tbl IN csi_datastructures_pub.party_header_tbl,
776: p_pa_h_tbl IN csi_datastructures_pub.party_account_header_tbl,
777: p_ou_h_tbl IN csi_datastructures_pub.org_units_header_tbl,
778: p_asset_h_tbl IN csi_datastructures_pub.instance_asset_header_tbl,
779: x_inst_rec OUT nocopy csi_datastructures_pub.instance_rec,
780: x_pty_tbl OUT nocopy csi_datastructures_pub.party_tbl,
781: x_pa_tbl OUT nocopy csi_datastructures_pub.party_account_tbl,
782: x_ou_tbl OUT nocopy csi_datastructures_pub.organization_units_tbl,

Line 779: x_inst_rec OUT nocopy csi_datastructures_pub.instance_rec,

775: p_pty_h_tbl IN csi_datastructures_pub.party_header_tbl,
776: p_pa_h_tbl IN csi_datastructures_pub.party_account_header_tbl,
777: p_ou_h_tbl IN csi_datastructures_pub.org_units_header_tbl,
778: p_asset_h_tbl IN csi_datastructures_pub.instance_asset_header_tbl,
779: x_inst_rec OUT nocopy csi_datastructures_pub.instance_rec,
780: x_pty_tbl OUT nocopy csi_datastructures_pub.party_tbl,
781: x_pa_tbl OUT nocopy csi_datastructures_pub.party_account_tbl,
782: x_ou_tbl OUT nocopy csi_datastructures_pub.organization_units_tbl,
783: x_asset_tbl OUT nocopy csi_datastructures_pub.instance_asset_tbl,

Line 780: x_pty_tbl OUT nocopy csi_datastructures_pub.party_tbl,

776: p_pa_h_tbl IN csi_datastructures_pub.party_account_header_tbl,
777: p_ou_h_tbl IN csi_datastructures_pub.org_units_header_tbl,
778: p_asset_h_tbl IN csi_datastructures_pub.instance_asset_header_tbl,
779: x_inst_rec OUT nocopy csi_datastructures_pub.instance_rec,
780: x_pty_tbl OUT nocopy csi_datastructures_pub.party_tbl,
781: x_pa_tbl OUT nocopy csi_datastructures_pub.party_account_tbl,
782: x_ou_tbl OUT nocopy csi_datastructures_pub.organization_units_tbl,
783: x_asset_tbl OUT nocopy csi_datastructures_pub.instance_asset_tbl,
784: x_return_status OUT nocopy varchar2)

Line 781: x_pa_tbl OUT nocopy csi_datastructures_pub.party_account_tbl,

777: p_ou_h_tbl IN csi_datastructures_pub.org_units_header_tbl,
778: p_asset_h_tbl IN csi_datastructures_pub.instance_asset_header_tbl,
779: x_inst_rec OUT nocopy csi_datastructures_pub.instance_rec,
780: x_pty_tbl OUT nocopy csi_datastructures_pub.party_tbl,
781: x_pa_tbl OUT nocopy csi_datastructures_pub.party_account_tbl,
782: x_ou_tbl OUT nocopy csi_datastructures_pub.organization_units_tbl,
783: x_asset_tbl OUT nocopy csi_datastructures_pub.instance_asset_tbl,
784: x_return_status OUT nocopy varchar2)
785: IS

Line 782: x_ou_tbl OUT nocopy csi_datastructures_pub.organization_units_tbl,

778: p_asset_h_tbl IN csi_datastructures_pub.instance_asset_header_tbl,
779: x_inst_rec OUT nocopy csi_datastructures_pub.instance_rec,
780: x_pty_tbl OUT nocopy csi_datastructures_pub.party_tbl,
781: x_pa_tbl OUT nocopy csi_datastructures_pub.party_account_tbl,
782: x_ou_tbl OUT nocopy csi_datastructures_pub.organization_units_tbl,
783: x_asset_tbl OUT nocopy csi_datastructures_pub.instance_asset_tbl,
784: x_return_status OUT nocopy varchar2)
785: IS
786: BEGIN

Line 783: x_asset_tbl OUT nocopy csi_datastructures_pub.instance_asset_tbl,

779: x_inst_rec OUT nocopy csi_datastructures_pub.instance_rec,
780: x_pty_tbl OUT nocopy csi_datastructures_pub.party_tbl,
781: x_pa_tbl OUT nocopy csi_datastructures_pub.party_account_tbl,
782: x_ou_tbl OUT nocopy csi_datastructures_pub.organization_units_tbl,
783: x_asset_tbl OUT nocopy csi_datastructures_pub.instance_asset_tbl,
784: x_return_status OUT nocopy varchar2)
785: IS
786: BEGIN
787:

Line 1007: l_csi_txn_rec csi_datastructures_pub.transaction_rec;

1003: WHERE process_flag <> 'P';
1004:
1005: l_txn_type_id number;
1006: l_error_exists varchar2(1) := 'N';
1007: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
1008:
1009: -- get instance details variables
1010: g_inst_rec csi_datastructures_pub.instance_header_rec;
1011: g_pty_tbl csi_datastructures_pub.party_header_tbl;

Line 1010: g_inst_rec csi_datastructures_pub.instance_header_rec;

1006: l_error_exists varchar2(1) := 'N';
1007: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
1008:
1009: -- get instance details variables
1010: g_inst_rec csi_datastructures_pub.instance_header_rec;
1011: g_pty_tbl csi_datastructures_pub.party_header_tbl;
1012: g_pa_tbl csi_datastructures_pub.party_account_header_tbl;
1013: g_ou_tbl csi_datastructures_pub.org_units_header_tbl;
1014: g_prc_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 1011: g_pty_tbl csi_datastructures_pub.party_header_tbl;

1007: l_csi_txn_rec csi_datastructures_pub.transaction_rec;
1008:
1009: -- get instance details variables
1010: g_inst_rec csi_datastructures_pub.instance_header_rec;
1011: g_pty_tbl csi_datastructures_pub.party_header_tbl;
1012: g_pa_tbl csi_datastructures_pub.party_account_header_tbl;
1013: g_ou_tbl csi_datastructures_pub.org_units_header_tbl;
1014: g_prc_tbl csi_datastructures_pub.pricing_attribs_tbl;
1015: g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 1012: g_pa_tbl csi_datastructures_pub.party_account_header_tbl;

1008:
1009: -- get instance details variables
1010: g_inst_rec csi_datastructures_pub.instance_header_rec;
1011: g_pty_tbl csi_datastructures_pub.party_header_tbl;
1012: g_pa_tbl csi_datastructures_pub.party_account_header_tbl;
1013: g_ou_tbl csi_datastructures_pub.org_units_header_tbl;
1014: g_prc_tbl csi_datastructures_pub.pricing_attribs_tbl;
1015: g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1016: g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;

Line 1013: g_ou_tbl csi_datastructures_pub.org_units_header_tbl;

1009: -- get instance details variables
1010: g_inst_rec csi_datastructures_pub.instance_header_rec;
1011: g_pty_tbl csi_datastructures_pub.party_header_tbl;
1012: g_pa_tbl csi_datastructures_pub.party_account_header_tbl;
1013: g_ou_tbl csi_datastructures_pub.org_units_header_tbl;
1014: g_prc_tbl csi_datastructures_pub.pricing_attribs_tbl;
1015: g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1016: g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
1017: g_asset_tbl csi_datastructures_pub.instance_asset_header_tbl;

Line 1014: g_prc_tbl csi_datastructures_pub.pricing_attribs_tbl;

1010: g_inst_rec csi_datastructures_pub.instance_header_rec;
1011: g_pty_tbl csi_datastructures_pub.party_header_tbl;
1012: g_pa_tbl csi_datastructures_pub.party_account_header_tbl;
1013: g_ou_tbl csi_datastructures_pub.org_units_header_tbl;
1014: g_prc_tbl csi_datastructures_pub.pricing_attribs_tbl;
1015: g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1016: g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
1017: g_asset_tbl csi_datastructures_pub.instance_asset_header_tbl;
1018:

Line 1015: g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;

1011: g_pty_tbl csi_datastructures_pub.party_header_tbl;
1012: g_pa_tbl csi_datastructures_pub.party_account_header_tbl;
1013: g_ou_tbl csi_datastructures_pub.org_units_header_tbl;
1014: g_prc_tbl csi_datastructures_pub.pricing_attribs_tbl;
1015: g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1016: g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
1017: g_asset_tbl csi_datastructures_pub.instance_asset_header_tbl;
1018:
1019:

Line 1016: g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;

1012: g_pa_tbl csi_datastructures_pub.party_account_header_tbl;
1013: g_ou_tbl csi_datastructures_pub.org_units_header_tbl;
1014: g_prc_tbl csi_datastructures_pub.pricing_attribs_tbl;
1015: g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1016: g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
1017: g_asset_tbl csi_datastructures_pub.instance_asset_header_tbl;
1018:
1019:
1020: -- get version label variables

Line 1017: g_asset_tbl csi_datastructures_pub.instance_asset_header_tbl;

1013: g_ou_tbl csi_datastructures_pub.org_units_header_tbl;
1014: g_prc_tbl csi_datastructures_pub.pricing_attribs_tbl;
1015: g_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1016: g_ea_tbl csi_datastructures_pub.extend_attrib_tbl;
1017: g_asset_tbl csi_datastructures_pub.instance_asset_header_tbl;
1018:
1019:
1020: -- get version label variables
1021: g_vl_qry_rec csi_datastructures_pub.version_label_query_rec;

Line 1021: g_vl_qry_rec csi_datastructures_pub.version_label_query_rec;

1017: g_asset_tbl csi_datastructures_pub.instance_asset_header_tbl;
1018:
1019:
1020: -- get version label variables
1021: g_vl_qry_rec csi_datastructures_pub.version_label_query_rec;
1022: g_vl_tbl csi_datastructures_pub.version_label_tbl;
1023:
1024: -- get relationship variables
1025: l_iir_qry_rec csi_datastructures_pub.relationship_query_rec;

Line 1022: g_vl_tbl csi_datastructures_pub.version_label_tbl;

1018:
1019:
1020: -- get version label variables
1021: g_vl_qry_rec csi_datastructures_pub.version_label_query_rec;
1022: g_vl_tbl csi_datastructures_pub.version_label_tbl;
1023:
1024: -- get relationship variables
1025: l_iir_qry_rec csi_datastructures_pub.relationship_query_rec;
1026: g_iir_qry_rec csi_datastructures_pub.relationship_query_rec;

Line 1025: l_iir_qry_rec csi_datastructures_pub.relationship_query_rec;

1021: g_vl_qry_rec csi_datastructures_pub.version_label_query_rec;
1022: g_vl_tbl csi_datastructures_pub.version_label_tbl;
1023:
1024: -- get relationship variables
1025: l_iir_qry_rec csi_datastructures_pub.relationship_query_rec;
1026: g_iir_qry_rec csi_datastructures_pub.relationship_query_rec;
1027: l_iir_tbl csi_datastructures_pub.ii_relationship_tbl;
1028: g_iir_tbl csi_datastructures_pub.ii_relationship_tbl;
1029: iir_ind binary_integer := 0;

Line 1026: g_iir_qry_rec csi_datastructures_pub.relationship_query_rec;

1022: g_vl_tbl csi_datastructures_pub.version_label_tbl;
1023:
1024: -- get relationship variables
1025: l_iir_qry_rec csi_datastructures_pub.relationship_query_rec;
1026: g_iir_qry_rec csi_datastructures_pub.relationship_query_rec;
1027: l_iir_tbl csi_datastructures_pub.ii_relationship_tbl;
1028: g_iir_tbl csi_datastructures_pub.ii_relationship_tbl;
1029: iir_ind binary_integer := 0;
1030:

Line 1027: l_iir_tbl csi_datastructures_pub.ii_relationship_tbl;

1023:
1024: -- get relationship variables
1025: l_iir_qry_rec csi_datastructures_pub.relationship_query_rec;
1026: g_iir_qry_rec csi_datastructures_pub.relationship_query_rec;
1027: l_iir_tbl csi_datastructures_pub.ii_relationship_tbl;
1028: g_iir_tbl csi_datastructures_pub.ii_relationship_tbl;
1029: iir_ind binary_integer := 0;
1030:
1031:

Line 1028: g_iir_tbl csi_datastructures_pub.ii_relationship_tbl;

1024: -- get relationship variables
1025: l_iir_qry_rec csi_datastructures_pub.relationship_query_rec;
1026: g_iir_qry_rec csi_datastructures_pub.relationship_query_rec;
1027: l_iir_tbl csi_datastructures_pub.ii_relationship_tbl;
1028: g_iir_tbl csi_datastructures_pub.ii_relationship_tbl;
1029: iir_ind binary_integer := 0;
1030:
1031:
1032: -- update item instance variables

Line 1033: l_inst_rec csi_datastructures_pub.instance_rec;

1029: iir_ind binary_integer := 0;
1030:
1031:
1032: -- update item instance variables
1033: l_inst_rec csi_datastructures_pub.instance_rec;
1034: l_pty_tbl csi_datastructures_pub.party_tbl;
1035: l_pa_tbl csi_datastructures_pub.party_account_tbl;
1036: l_ou_tbl csi_datastructures_pub.organization_units_tbl;
1037: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 1034: l_pty_tbl csi_datastructures_pub.party_tbl;

1030:
1031:
1032: -- update item instance variables
1033: l_inst_rec csi_datastructures_pub.instance_rec;
1034: l_pty_tbl csi_datastructures_pub.party_tbl;
1035: l_pa_tbl csi_datastructures_pub.party_account_tbl;
1036: l_ou_tbl csi_datastructures_pub.organization_units_tbl;
1037: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1038: l_prc_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 1035: l_pa_tbl csi_datastructures_pub.party_account_tbl;

1031:
1032: -- update item instance variables
1033: l_inst_rec csi_datastructures_pub.instance_rec;
1034: l_pty_tbl csi_datastructures_pub.party_tbl;
1035: l_pa_tbl csi_datastructures_pub.party_account_tbl;
1036: l_ou_tbl csi_datastructures_pub.organization_units_tbl;
1037: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1038: l_prc_tbl csi_datastructures_pub.pricing_attribs_tbl;
1039: l_asset_tbl csi_datastructures_pub.instance_asset_tbl;

Line 1036: l_ou_tbl csi_datastructures_pub.organization_units_tbl;

1032: -- update item instance variables
1033: l_inst_rec csi_datastructures_pub.instance_rec;
1034: l_pty_tbl csi_datastructures_pub.party_tbl;
1035: l_pa_tbl csi_datastructures_pub.party_account_tbl;
1036: l_ou_tbl csi_datastructures_pub.organization_units_tbl;
1037: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1038: l_prc_tbl csi_datastructures_pub.pricing_attribs_tbl;
1039: l_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1040: l_inst_ids_tbl csi_datastructures_pub.id_tbl;

Line 1037: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;

1033: l_inst_rec csi_datastructures_pub.instance_rec;
1034: l_pty_tbl csi_datastructures_pub.party_tbl;
1035: l_pa_tbl csi_datastructures_pub.party_account_tbl;
1036: l_ou_tbl csi_datastructures_pub.organization_units_tbl;
1037: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1038: l_prc_tbl csi_datastructures_pub.pricing_attribs_tbl;
1039: l_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1040: l_inst_ids_tbl csi_datastructures_pub.id_tbl;
1041: l_txn_rec csi_datastructures_pub.transaction_rec;

Line 1038: l_prc_tbl csi_datastructures_pub.pricing_attribs_tbl;

1034: l_pty_tbl csi_datastructures_pub.party_tbl;
1035: l_pa_tbl csi_datastructures_pub.party_account_tbl;
1036: l_ou_tbl csi_datastructures_pub.organization_units_tbl;
1037: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1038: l_prc_tbl csi_datastructures_pub.pricing_attribs_tbl;
1039: l_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1040: l_inst_ids_tbl csi_datastructures_pub.id_tbl;
1041: l_txn_rec csi_datastructures_pub.transaction_rec;
1042: l_vl_tbl csi_datastructures_pub.version_label_tbl;

Line 1039: l_asset_tbl csi_datastructures_pub.instance_asset_tbl;

1035: l_pa_tbl csi_datastructures_pub.party_account_tbl;
1036: l_ou_tbl csi_datastructures_pub.organization_units_tbl;
1037: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1038: l_prc_tbl csi_datastructures_pub.pricing_attribs_tbl;
1039: l_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1040: l_inst_ids_tbl csi_datastructures_pub.id_tbl;
1041: l_txn_rec csi_datastructures_pub.transaction_rec;
1042: l_vl_tbl csi_datastructures_pub.version_label_tbl;
1043:

Line 1040: l_inst_ids_tbl csi_datastructures_pub.id_tbl;

1036: l_ou_tbl csi_datastructures_pub.organization_units_tbl;
1037: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1038: l_prc_tbl csi_datastructures_pub.pricing_attribs_tbl;
1039: l_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1040: l_inst_ids_tbl csi_datastructures_pub.id_tbl;
1041: l_txn_rec csi_datastructures_pub.transaction_rec;
1042: l_vl_tbl csi_datastructures_pub.version_label_tbl;
1043:
1044: l_return_status varchar2(1);

Line 1041: l_txn_rec csi_datastructures_pub.transaction_rec;

1037: l_eav_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1038: l_prc_tbl csi_datastructures_pub.pricing_attribs_tbl;
1039: l_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1040: l_inst_ids_tbl csi_datastructures_pub.id_tbl;
1041: l_txn_rec csi_datastructures_pub.transaction_rec;
1042: l_vl_tbl csi_datastructures_pub.version_label_tbl;
1043:
1044: l_return_status varchar2(1);
1045: l_msg_data varchar2(2000);

Line 1042: l_vl_tbl csi_datastructures_pub.version_label_tbl;

1038: l_prc_tbl csi_datastructures_pub.pricing_attribs_tbl;
1039: l_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1040: l_inst_ids_tbl csi_datastructures_pub.id_tbl;
1041: l_txn_rec csi_datastructures_pub.transaction_rec;
1042: l_vl_tbl csi_datastructures_pub.version_label_tbl;
1043:
1044: l_return_status varchar2(1);
1045: l_msg_data varchar2(2000);
1046: l_msg_count number;

Line 1049: px_inst_rec IN OUT nocopy csi_datastructures_pub.instance_header_rec,

1045: l_msg_data varchar2(2000);
1046: l_msg_count number;
1047:
1048: PROCEDURE init_struct(
1049: px_inst_rec IN OUT nocopy csi_datastructures_pub.instance_header_rec,
1050: px_pty_tbl IN OUT nocopy csi_datastructures_pub.party_header_tbl,
1051: px_pa_tbl IN OUT nocopy csi_datastructures_pub.party_account_header_tbl,
1052: px_ou_tbl IN OUT nocopy csi_datastructures_pub.org_units_header_tbl,
1053: px_prc_tbl IN OUT nocopy csi_datastructures_pub.pricing_attribs_tbl,

Line 1050: px_pty_tbl IN OUT nocopy csi_datastructures_pub.party_header_tbl,

1046: l_msg_count number;
1047:
1048: PROCEDURE init_struct(
1049: px_inst_rec IN OUT nocopy csi_datastructures_pub.instance_header_rec,
1050: px_pty_tbl IN OUT nocopy csi_datastructures_pub.party_header_tbl,
1051: px_pa_tbl IN OUT nocopy csi_datastructures_pub.party_account_header_tbl,
1052: px_ou_tbl IN OUT nocopy csi_datastructures_pub.org_units_header_tbl,
1053: px_prc_tbl IN OUT nocopy csi_datastructures_pub.pricing_attribs_tbl,
1054: px_eav_tbl IN OUT nocopy csi_datastructures_pub.extend_attrib_values_tbl,

Line 1051: px_pa_tbl IN OUT nocopy csi_datastructures_pub.party_account_header_tbl,

1047:
1048: PROCEDURE init_struct(
1049: px_inst_rec IN OUT nocopy csi_datastructures_pub.instance_header_rec,
1050: px_pty_tbl IN OUT nocopy csi_datastructures_pub.party_header_tbl,
1051: px_pa_tbl IN OUT nocopy csi_datastructures_pub.party_account_header_tbl,
1052: px_ou_tbl IN OUT nocopy csi_datastructures_pub.org_units_header_tbl,
1053: px_prc_tbl IN OUT nocopy csi_datastructures_pub.pricing_attribs_tbl,
1054: px_eav_tbl IN OUT nocopy csi_datastructures_pub.extend_attrib_values_tbl,
1055: px_ea_tbl IN OUT nocopy csi_datastructures_pub.extend_attrib_tbl,

Line 1052: px_ou_tbl IN OUT nocopy csi_datastructures_pub.org_units_header_tbl,

1048: PROCEDURE init_struct(
1049: px_inst_rec IN OUT nocopy csi_datastructures_pub.instance_header_rec,
1050: px_pty_tbl IN OUT nocopy csi_datastructures_pub.party_header_tbl,
1051: px_pa_tbl IN OUT nocopy csi_datastructures_pub.party_account_header_tbl,
1052: px_ou_tbl IN OUT nocopy csi_datastructures_pub.org_units_header_tbl,
1053: px_prc_tbl IN OUT nocopy csi_datastructures_pub.pricing_attribs_tbl,
1054: px_eav_tbl IN OUT nocopy csi_datastructures_pub.extend_attrib_values_tbl,
1055: px_ea_tbl IN OUT nocopy csi_datastructures_pub.extend_attrib_tbl,
1056: px_asset_tbl IN OUT nocopy csi_datastructures_pub.instance_asset_header_tbl,

Line 1053: px_prc_tbl IN OUT nocopy csi_datastructures_pub.pricing_attribs_tbl,

1049: px_inst_rec IN OUT nocopy csi_datastructures_pub.instance_header_rec,
1050: px_pty_tbl IN OUT nocopy csi_datastructures_pub.party_header_tbl,
1051: px_pa_tbl IN OUT nocopy csi_datastructures_pub.party_account_header_tbl,
1052: px_ou_tbl IN OUT nocopy csi_datastructures_pub.org_units_header_tbl,
1053: px_prc_tbl IN OUT nocopy csi_datastructures_pub.pricing_attribs_tbl,
1054: px_eav_tbl IN OUT nocopy csi_datastructures_pub.extend_attrib_values_tbl,
1055: px_ea_tbl IN OUT nocopy csi_datastructures_pub.extend_attrib_tbl,
1056: px_asset_tbl IN OUT nocopy csi_datastructures_pub.instance_asset_header_tbl,
1057: px_vl_qry_rec IN OUT nocopy csi_datastructures_pub.version_label_query_rec,

Line 1054: px_eav_tbl IN OUT nocopy csi_datastructures_pub.extend_attrib_values_tbl,

1050: px_pty_tbl IN OUT nocopy csi_datastructures_pub.party_header_tbl,
1051: px_pa_tbl IN OUT nocopy csi_datastructures_pub.party_account_header_tbl,
1052: px_ou_tbl IN OUT nocopy csi_datastructures_pub.org_units_header_tbl,
1053: px_prc_tbl IN OUT nocopy csi_datastructures_pub.pricing_attribs_tbl,
1054: px_eav_tbl IN OUT nocopy csi_datastructures_pub.extend_attrib_values_tbl,
1055: px_ea_tbl IN OUT nocopy csi_datastructures_pub.extend_attrib_tbl,
1056: px_asset_tbl IN OUT nocopy csi_datastructures_pub.instance_asset_header_tbl,
1057: px_vl_qry_rec IN OUT nocopy csi_datastructures_pub.version_label_query_rec,
1058: px_vl_tbl IN OUT nocopy csi_datastructures_pub.version_label_tbl,

Line 1055: px_ea_tbl IN OUT nocopy csi_datastructures_pub.extend_attrib_tbl,

1051: px_pa_tbl IN OUT nocopy csi_datastructures_pub.party_account_header_tbl,
1052: px_ou_tbl IN OUT nocopy csi_datastructures_pub.org_units_header_tbl,
1053: px_prc_tbl IN OUT nocopy csi_datastructures_pub.pricing_attribs_tbl,
1054: px_eav_tbl IN OUT nocopy csi_datastructures_pub.extend_attrib_values_tbl,
1055: px_ea_tbl IN OUT nocopy csi_datastructures_pub.extend_attrib_tbl,
1056: px_asset_tbl IN OUT nocopy csi_datastructures_pub.instance_asset_header_tbl,
1057: px_vl_qry_rec IN OUT nocopy csi_datastructures_pub.version_label_query_rec,
1058: px_vl_tbl IN OUT nocopy csi_datastructures_pub.version_label_tbl,
1059: px_iir_qry_rec IN OUT nocopy csi_datastructures_pub.relationship_query_rec,

Line 1056: px_asset_tbl IN OUT nocopy csi_datastructures_pub.instance_asset_header_tbl,

1052: px_ou_tbl IN OUT nocopy csi_datastructures_pub.org_units_header_tbl,
1053: px_prc_tbl IN OUT nocopy csi_datastructures_pub.pricing_attribs_tbl,
1054: px_eav_tbl IN OUT nocopy csi_datastructures_pub.extend_attrib_values_tbl,
1055: px_ea_tbl IN OUT nocopy csi_datastructures_pub.extend_attrib_tbl,
1056: px_asset_tbl IN OUT nocopy csi_datastructures_pub.instance_asset_header_tbl,
1057: px_vl_qry_rec IN OUT nocopy csi_datastructures_pub.version_label_query_rec,
1058: px_vl_tbl IN OUT nocopy csi_datastructures_pub.version_label_tbl,
1059: px_iir_qry_rec IN OUT nocopy csi_datastructures_pub.relationship_query_rec,
1060: px_iir_tbl IN OUT nocopy csi_datastructures_pub.ii_relationship_tbl)

Line 1057: px_vl_qry_rec IN OUT nocopy csi_datastructures_pub.version_label_query_rec,

1053: px_prc_tbl IN OUT nocopy csi_datastructures_pub.pricing_attribs_tbl,
1054: px_eav_tbl IN OUT nocopy csi_datastructures_pub.extend_attrib_values_tbl,
1055: px_ea_tbl IN OUT nocopy csi_datastructures_pub.extend_attrib_tbl,
1056: px_asset_tbl IN OUT nocopy csi_datastructures_pub.instance_asset_header_tbl,
1057: px_vl_qry_rec IN OUT nocopy csi_datastructures_pub.version_label_query_rec,
1058: px_vl_tbl IN OUT nocopy csi_datastructures_pub.version_label_tbl,
1059: px_iir_qry_rec IN OUT nocopy csi_datastructures_pub.relationship_query_rec,
1060: px_iir_tbl IN OUT nocopy csi_datastructures_pub.ii_relationship_tbl)
1061: IS

Line 1058: px_vl_tbl IN OUT nocopy csi_datastructures_pub.version_label_tbl,

1054: px_eav_tbl IN OUT nocopy csi_datastructures_pub.extend_attrib_values_tbl,
1055: px_ea_tbl IN OUT nocopy csi_datastructures_pub.extend_attrib_tbl,
1056: px_asset_tbl IN OUT nocopy csi_datastructures_pub.instance_asset_header_tbl,
1057: px_vl_qry_rec IN OUT nocopy csi_datastructures_pub.version_label_query_rec,
1058: px_vl_tbl IN OUT nocopy csi_datastructures_pub.version_label_tbl,
1059: px_iir_qry_rec IN OUT nocopy csi_datastructures_pub.relationship_query_rec,
1060: px_iir_tbl IN OUT nocopy csi_datastructures_pub.ii_relationship_tbl)
1061: IS
1062: l_inst_rec csi_datastructures_pub.instance_header_rec;

Line 1059: px_iir_qry_rec IN OUT nocopy csi_datastructures_pub.relationship_query_rec,

1055: px_ea_tbl IN OUT nocopy csi_datastructures_pub.extend_attrib_tbl,
1056: px_asset_tbl IN OUT nocopy csi_datastructures_pub.instance_asset_header_tbl,
1057: px_vl_qry_rec IN OUT nocopy csi_datastructures_pub.version_label_query_rec,
1058: px_vl_tbl IN OUT nocopy csi_datastructures_pub.version_label_tbl,
1059: px_iir_qry_rec IN OUT nocopy csi_datastructures_pub.relationship_query_rec,
1060: px_iir_tbl IN OUT nocopy csi_datastructures_pub.ii_relationship_tbl)
1061: IS
1062: l_inst_rec csi_datastructures_pub.instance_header_rec;
1063: l_vl_qry_rec csi_datastructures_pub.version_label_query_rec;

Line 1060: px_iir_tbl IN OUT nocopy csi_datastructures_pub.ii_relationship_tbl)

1056: px_asset_tbl IN OUT nocopy csi_datastructures_pub.instance_asset_header_tbl,
1057: px_vl_qry_rec IN OUT nocopy csi_datastructures_pub.version_label_query_rec,
1058: px_vl_tbl IN OUT nocopy csi_datastructures_pub.version_label_tbl,
1059: px_iir_qry_rec IN OUT nocopy csi_datastructures_pub.relationship_query_rec,
1060: px_iir_tbl IN OUT nocopy csi_datastructures_pub.ii_relationship_tbl)
1061: IS
1062: l_inst_rec csi_datastructures_pub.instance_header_rec;
1063: l_vl_qry_rec csi_datastructures_pub.version_label_query_rec;
1064: l_iir_qry_rec csi_datastructures_pub.relationship_query_rec;

Line 1062: l_inst_rec csi_datastructures_pub.instance_header_rec;

1058: px_vl_tbl IN OUT nocopy csi_datastructures_pub.version_label_tbl,
1059: px_iir_qry_rec IN OUT nocopy csi_datastructures_pub.relationship_query_rec,
1060: px_iir_tbl IN OUT nocopy csi_datastructures_pub.ii_relationship_tbl)
1061: IS
1062: l_inst_rec csi_datastructures_pub.instance_header_rec;
1063: l_vl_qry_rec csi_datastructures_pub.version_label_query_rec;
1064: l_iir_qry_rec csi_datastructures_pub.relationship_query_rec;
1065: BEGIN
1066: px_inst_rec := l_inst_rec;

Line 1063: l_vl_qry_rec csi_datastructures_pub.version_label_query_rec;

1059: px_iir_qry_rec IN OUT nocopy csi_datastructures_pub.relationship_query_rec,
1060: px_iir_tbl IN OUT nocopy csi_datastructures_pub.ii_relationship_tbl)
1061: IS
1062: l_inst_rec csi_datastructures_pub.instance_header_rec;
1063: l_vl_qry_rec csi_datastructures_pub.version_label_query_rec;
1064: l_iir_qry_rec csi_datastructures_pub.relationship_query_rec;
1065: BEGIN
1066: px_inst_rec := l_inst_rec;
1067: px_vl_qry_rec := l_vl_qry_rec;

Line 1064: l_iir_qry_rec csi_datastructures_pub.relationship_query_rec;

1060: px_iir_tbl IN OUT nocopy csi_datastructures_pub.ii_relationship_tbl)
1061: IS
1062: l_inst_rec csi_datastructures_pub.instance_header_rec;
1063: l_vl_qry_rec csi_datastructures_pub.version_label_query_rec;
1064: l_iir_qry_rec csi_datastructures_pub.relationship_query_rec;
1065: BEGIN
1066: px_inst_rec := l_inst_rec;
1067: px_vl_qry_rec := l_vl_qry_rec;
1068: px_iir_qry_rec := l_iir_qry_rec;

Line 1373: p_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_REC;

1369: log('OTHERS exception from forward sync : '||sqlerrm);
1370: END forward_sync;
1371: --
1372: PROCEDURE insert_full_dump(p_instance_id IN NUMBER) IS
1373: p_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_REC;
1374: p_temp_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_REC;
1375: p_party_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_HEADER_TBL;
1376: p_account_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_HEADER_TBL;
1377: p_org_header_tbl CSI_DATASTRUCTURES_PUB.ORG_UNITS_HEADER_TBL;

Line 1374: p_temp_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_REC;

1370: END forward_sync;
1371: --
1372: PROCEDURE insert_full_dump(p_instance_id IN NUMBER) IS
1373: p_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_REC;
1374: p_temp_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_REC;
1375: p_party_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_HEADER_TBL;
1376: p_account_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_HEADER_TBL;
1377: p_org_header_tbl CSI_DATASTRUCTURES_PUB.ORG_UNITS_HEADER_TBL;
1378: p_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;

Line 1375: p_party_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_HEADER_TBL;

1371: --
1372: PROCEDURE insert_full_dump(p_instance_id IN NUMBER) IS
1373: p_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_REC;
1374: p_temp_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_REC;
1375: p_party_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_HEADER_TBL;
1376: p_account_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_HEADER_TBL;
1377: p_org_header_tbl CSI_DATASTRUCTURES_PUB.ORG_UNITS_HEADER_TBL;
1378: p_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
1379: p_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;

Line 1376: p_account_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_HEADER_TBL;

1372: PROCEDURE insert_full_dump(p_instance_id IN NUMBER) IS
1373: p_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_REC;
1374: p_temp_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_REC;
1375: p_party_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_HEADER_TBL;
1376: p_account_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_HEADER_TBL;
1377: p_org_header_tbl CSI_DATASTRUCTURES_PUB.ORG_UNITS_HEADER_TBL;
1378: p_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
1379: p_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
1380: p_ext_attrib_def_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_TBL;

Line 1377: p_org_header_tbl CSI_DATASTRUCTURES_PUB.ORG_UNITS_HEADER_TBL;

1373: p_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_REC;
1374: p_temp_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_REC;
1375: p_party_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_HEADER_TBL;
1376: p_account_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_HEADER_TBL;
1377: p_org_header_tbl CSI_DATASTRUCTURES_PUB.ORG_UNITS_HEADER_TBL;
1378: p_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
1379: p_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
1380: p_ext_attrib_def_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_TBL;
1381: p_asset_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_HEADER_TBL;

Line 1378: p_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;

1374: p_temp_instance_rec CSI_DATASTRUCTURES_PUB.INSTANCE_HEADER_REC;
1375: p_party_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_HEADER_TBL;
1376: p_account_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_HEADER_TBL;
1377: p_org_header_tbl CSI_DATASTRUCTURES_PUB.ORG_UNITS_HEADER_TBL;
1378: p_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
1379: p_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
1380: p_ext_attrib_def_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_TBL;
1381: p_asset_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_HEADER_TBL;
1382: p_ver_label_query_rec CSI_DATASTRUCTURES_PUB.VERSION_LABEL_QUERY_REC;

Line 1379: p_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;

1375: p_party_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_HEADER_TBL;
1376: p_account_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_HEADER_TBL;
1377: p_org_header_tbl CSI_DATASTRUCTURES_PUB.ORG_UNITS_HEADER_TBL;
1378: p_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
1379: p_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
1380: p_ext_attrib_def_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_TBL;
1381: p_asset_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_HEADER_TBL;
1382: p_ver_label_query_rec CSI_DATASTRUCTURES_PUB.VERSION_LABEL_QUERY_REC;
1383: p_rel_query_rec CSI_DATASTRUCTURES_PUB.RELATIONSHIP_QUERY_REC;

Line 1380: p_ext_attrib_def_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_TBL;

1376: p_account_header_tbl CSI_DATASTRUCTURES_PUB.PARTY_ACCOUNT_HEADER_TBL;
1377: p_org_header_tbl CSI_DATASTRUCTURES_PUB.ORG_UNITS_HEADER_TBL;
1378: p_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
1379: p_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
1380: p_ext_attrib_def_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_TBL;
1381: p_asset_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_HEADER_TBL;
1382: p_ver_label_query_rec CSI_DATASTRUCTURES_PUB.VERSION_LABEL_QUERY_REC;
1383: p_rel_query_rec CSI_DATASTRUCTURES_PUB.RELATIONSHIP_QUERY_REC;
1384: p_temp_rel_query_rec CSI_DATASTRUCTURES_PUB.RELATIONSHIP_QUERY_REC;

Line 1381: p_asset_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_HEADER_TBL;

1377: p_org_header_tbl CSI_DATASTRUCTURES_PUB.ORG_UNITS_HEADER_TBL;
1378: p_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
1379: p_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
1380: p_ext_attrib_def_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_TBL;
1381: p_asset_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_HEADER_TBL;
1382: p_ver_label_query_rec CSI_DATASTRUCTURES_PUB.VERSION_LABEL_QUERY_REC;
1383: p_rel_query_rec CSI_DATASTRUCTURES_PUB.RELATIONSHIP_QUERY_REC;
1384: p_temp_rel_query_rec CSI_DATASTRUCTURES_PUB.RELATIONSHIP_QUERY_REC;
1385: x_version_label_tbl csi_datastructures_pub.version_label_tbl;

Line 1382: p_ver_label_query_rec CSI_DATASTRUCTURES_PUB.VERSION_LABEL_QUERY_REC;

1378: p_pricing_attrib_tbl CSI_DATASTRUCTURES_PUB.PRICING_ATTRIBS_TBL;
1379: p_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
1380: p_ext_attrib_def_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_TBL;
1381: p_asset_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_HEADER_TBL;
1382: p_ver_label_query_rec CSI_DATASTRUCTURES_PUB.VERSION_LABEL_QUERY_REC;
1383: p_rel_query_rec CSI_DATASTRUCTURES_PUB.RELATIONSHIP_QUERY_REC;
1384: p_temp_rel_query_rec CSI_DATASTRUCTURES_PUB.RELATIONSHIP_QUERY_REC;
1385: x_version_label_tbl csi_datastructures_pub.version_label_tbl;
1386: x_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;

Line 1383: p_rel_query_rec CSI_DATASTRUCTURES_PUB.RELATIONSHIP_QUERY_REC;

1379: p_ext_attrib_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_VALUES_TBL;
1380: p_ext_attrib_def_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_TBL;
1381: p_asset_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_HEADER_TBL;
1382: p_ver_label_query_rec CSI_DATASTRUCTURES_PUB.VERSION_LABEL_QUERY_REC;
1383: p_rel_query_rec CSI_DATASTRUCTURES_PUB.RELATIONSHIP_QUERY_REC;
1384: p_temp_rel_query_rec CSI_DATASTRUCTURES_PUB.RELATIONSHIP_QUERY_REC;
1385: x_version_label_tbl csi_datastructures_pub.version_label_tbl;
1386: x_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
1387: l_init_msg_list VARCHAR2(2000);

Line 1384: p_temp_rel_query_rec CSI_DATASTRUCTURES_PUB.RELATIONSHIP_QUERY_REC;

1380: p_ext_attrib_def_tbl CSI_DATASTRUCTURES_PUB.EXTEND_ATTRIB_TBL;
1381: p_asset_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_HEADER_TBL;
1382: p_ver_label_query_rec CSI_DATASTRUCTURES_PUB.VERSION_LABEL_QUERY_REC;
1383: p_rel_query_rec CSI_DATASTRUCTURES_PUB.RELATIONSHIP_QUERY_REC;
1384: p_temp_rel_query_rec CSI_DATASTRUCTURES_PUB.RELATIONSHIP_QUERY_REC;
1385: x_version_label_tbl csi_datastructures_pub.version_label_tbl;
1386: x_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
1387: l_init_msg_list VARCHAR2(2000);
1388: x_return_status VARCHAR2(2000);

Line 1385: x_version_label_tbl csi_datastructures_pub.version_label_tbl;

1381: p_asset_header_tbl CSI_DATASTRUCTURES_PUB.INSTANCE_ASSET_HEADER_TBL;
1382: p_ver_label_query_rec CSI_DATASTRUCTURES_PUB.VERSION_LABEL_QUERY_REC;
1383: p_rel_query_rec CSI_DATASTRUCTURES_PUB.RELATIONSHIP_QUERY_REC;
1384: p_temp_rel_query_rec CSI_DATASTRUCTURES_PUB.RELATIONSHIP_QUERY_REC;
1385: x_version_label_tbl csi_datastructures_pub.version_label_tbl;
1386: x_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
1387: l_init_msg_list VARCHAR2(2000);
1388: x_return_status VARCHAR2(2000);
1389: x_msg_count NUMBER;

Line 1386: x_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;

1382: p_ver_label_query_rec CSI_DATASTRUCTURES_PUB.VERSION_LABEL_QUERY_REC;
1383: p_rel_query_rec CSI_DATASTRUCTURES_PUB.RELATIONSHIP_QUERY_REC;
1384: p_temp_rel_query_rec CSI_DATASTRUCTURES_PUB.RELATIONSHIP_QUERY_REC;
1385: x_version_label_tbl csi_datastructures_pub.version_label_tbl;
1386: x_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
1387: l_init_msg_list VARCHAR2(2000);
1388: x_return_status VARCHAR2(2000);
1389: x_msg_count NUMBER;
1390: x_msg_data VARCHAR2(2000);

Line 1394: l_instance_tbl csi_datastructures_pub.instance_tbl;

1390: x_msg_data VARCHAR2(2000);
1391: l_msg_index NUMBER;
1392: l_msg_count NUMBER;
1393: --
1394: l_instance_tbl csi_datastructures_pub.instance_tbl;
1395: l_party_tbl csi_datastructures_pub.party_tbl;
1396: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
1397: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1398: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 1395: l_party_tbl csi_datastructures_pub.party_tbl;

1391: l_msg_index NUMBER;
1392: l_msg_count NUMBER;
1393: --
1394: l_instance_tbl csi_datastructures_pub.instance_tbl;
1395: l_party_tbl csi_datastructures_pub.party_tbl;
1396: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
1397: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1398: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
1399: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 1396: l_party_account_tbl csi_datastructures_pub.party_account_tbl;

1392: l_msg_count NUMBER;
1393: --
1394: l_instance_tbl csi_datastructures_pub.instance_tbl;
1395: l_party_tbl csi_datastructures_pub.party_tbl;
1396: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
1397: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1398: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
1399: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1400: l_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;

Line 1397: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;

1393: --
1394: l_instance_tbl csi_datastructures_pub.instance_tbl;
1395: l_party_tbl csi_datastructures_pub.party_tbl;
1396: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
1397: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1398: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
1399: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1400: l_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1401: l_version_label_tbl csi_datastructures_pub.version_label_tbl;

Line 1398: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;

1394: l_instance_tbl csi_datastructures_pub.instance_tbl;
1395: l_party_tbl csi_datastructures_pub.party_tbl;
1396: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
1397: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1398: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
1399: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1400: l_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1401: l_version_label_tbl csi_datastructures_pub.version_label_tbl;
1402: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;

Line 1399: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

1395: l_party_tbl csi_datastructures_pub.party_tbl;
1396: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
1397: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1398: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
1399: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1400: l_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1401: l_version_label_tbl csi_datastructures_pub.version_label_tbl;
1402: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
1403: --

Line 1400: l_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;

1396: l_party_account_tbl csi_datastructures_pub.party_account_tbl;
1397: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1398: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
1399: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1400: l_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1401: l_version_label_tbl csi_datastructures_pub.version_label_tbl;
1402: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
1403: --
1404: l_inst_rec_tab csi_diagnostics_pkg.instance_rec_tab;

Line 1401: l_version_label_tbl csi_datastructures_pub.version_label_tbl;

1397: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
1398: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
1399: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1400: l_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1401: l_version_label_tbl csi_datastructures_pub.version_label_tbl;
1402: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
1403: --
1404: l_inst_rec_tab csi_diagnostics_pkg.instance_rec_tab;
1405: l_version_label_rec_tab csi_diagnostics_pkg.version_label_rec_tab;

Line 1402: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;

1398: l_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
1399: l_ext_attrib_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
1400: l_instance_asset_tbl csi_datastructures_pub.instance_asset_tbl;
1401: l_version_label_tbl csi_datastructures_pub.version_label_tbl;
1402: l_ii_relationship_tbl csi_datastructures_pub.ii_relationship_tbl;
1403: --
1404: l_inst_rec_tab csi_diagnostics_pkg.instance_rec_tab;
1405: l_version_label_rec_tab csi_diagnostics_pkg.version_label_rec_tab;
1406: l_party_rec_tab csi_diagnostics_pkg.party_rec_tab;

Line 3119: l_error_rec csi_datastructures_pub.transaction_error_rec;

3115: p_dequeue_flag IN varchar2 default 'N',
3116: p_release IN varchar2)
3117: IS
3118:
3119: l_error_rec csi_datastructures_pub.transaction_error_rec;
3120: l_error_id number;
3121: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
3122: l_msg_count number;
3123: l_msg_data varchar2(2000);

Line 3229: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

3225: l_object_name := l_schema_name||'.csi_xnp_msgs_temp';
3226:
3227: truncate_table(l_object_name);
3228:
3229: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
3230: csi_gen_utility_pvt.populate_install_param_rec;
3231: END IF;
3232:
3233: l_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;

Line 3233: l_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;

3229: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
3230: csi_gen_utility_pvt.populate_install_param_rec;
3231: END IF;
3232:
3233: l_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;
3234:
3235: FOR msg_rec in msg_cur(l_freeze_date)
3236: LOOP
3237:

Line 3434: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

3430: SELECT fnd_Profile.value('CSI_UPGRADING_FROM_RELEASE')
3431: INTO l_release
3432: FROM sys.dual;
3433: --
3434: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
3435: csi_gen_utility_pvt.populate_install_param_rec;
3436: END IF;
3437: --
3438: l_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;

Line 3438: l_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;

3434: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
3435: csi_gen_utility_pvt.populate_install_param_rec;
3436: END IF;
3437: --
3438: l_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;
3439: --
3440: FOR wip_txn_rec IN prior_cur(p_mtl_creation_date, p_wip_job_id, l_freeze_date)
3441: LOOP
3442:

Line 3718: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

3714: l_lot_code number;
3715:
3716: BEGIN
3717:
3718: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
3719: csi_gen_utility_pvt.populate_install_param_rec;
3720: END IF;
3721: --
3722: l_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;

Line 3722: l_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;

3718: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
3719: csi_gen_utility_pvt.populate_install_param_rec;
3720: END IF;
3721: --
3722: l_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;
3723: --
3724: OPEN all_srl_cur;
3725: LOOP
3726:

Line 3808: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

3804: BEGIN
3805:
3806: log(date_time_stamp||' begin pump_err_missing_txn');
3807:
3808: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
3809: csi_gen_utility_pvt.populate_install_param_rec;
3810: END IF;
3811: --
3812: l_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;

Line 3812: l_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;

3808: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
3809: csi_gen_utility_pvt.populate_install_param_rec;
3810: END IF;
3811: --
3812: l_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;
3813: --
3814: OPEN error_cur;
3815: LOOP
3816:

Line 4022: l_txn_rec csi_datastructures_pub.transaction_rec;

4018: l_process_flag varchar2(1);
4019: l_temp_message varchar2(540);
4020: l_source_type varchar2(30);
4021:
4022: l_txn_rec csi_datastructures_pub.transaction_rec;
4023: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4024: l_msg_count number;
4025: l_msg_data varchar2(2000);
4026:

Line 4061: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

4057: SELECT fnd_Profile.value('csi_upgrading_from_release')
4058: INTO l_release
4059: FROM sys.dual;
4060: --
4061: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
4062: csi_gen_utility_pvt.populate_install_param_rec;
4063: END IF;
4064: --
4065: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;

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

4061: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
4062: csi_gen_utility_pvt.populate_install_param_rec;
4063: END IF;
4064: --
4065: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
4066: l_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;
4067: --
4068: /* bulk fetch all the txn errors, 1000 records at a time */
4069: IF p_single_error_flag = 'Y' THEN

Line 4066: l_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;

4062: csi_gen_utility_pvt.populate_install_param_rec;
4063: END IF;
4064: --
4065: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
4066: l_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;
4067: --
4068: /* bulk fetch all the txn errors, 1000 records at a time */
4069: IF p_single_error_flag = 'Y' THEN
4070: OPEN single_error_cur(p_mtl_txn_id);

Line 5104: l_txn_rec csi_datastructures_pub.transaction_rec;

5100: skip_txn exception;
5101: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
5102: l_msg_data varchar2(2000);
5103: l_msg_count number;
5104: l_txn_rec csi_datastructures_pub.transaction_rec;
5105:
5106: BEGIN
5107:
5108: FOR m_rec IN m_cur -- read all the distinct inv txn records that are marked for update

Line 5747: p_instance_rec in csi_datastructures_pub.instance_rec)

5743:
5744: END spool_srldata;
5745:
5746: PROCEDURE dump_diff(
5747: p_instance_rec in csi_datastructures_pub.instance_rec)
5748: IS
5749:
5750: l_vld_organization_id number;
5751: l_inv_organization_id number;

Line 5802: p_instance_rec in csi_datastructures_pub.instance_rec)

5798:
5799: END dump_diff;
5800:
5801: FUNCTION not_the_same(
5802: p_instance_rec in csi_datastructures_pub.instance_rec)
5803: RETURN boolean
5804: IS
5805:
5806: l_not_the_same boolean := TRUE;

Line 5985: px_instance_rec in out nocopy csi_datastructures_pub.instance_rec,

5981:
5982: END not_the_same;
5983:
5984: PROCEDURE init_plsql_tables(
5985: px_instance_rec in out nocopy csi_datastructures_pub.instance_rec,
5986: px_parties_tbl in out nocopy csi_datastructures_pub.party_tbl,
5987: px_pty_accts_tbl in out nocopy csi_datastructures_pub.party_account_tbl,
5988: px_org_units_tbl in out nocopy csi_datastructures_pub.organization_units_tbl,
5989: px_ea_values_tbl in out nocopy csi_datastructures_pub.extend_attrib_values_tbl,

Line 5986: px_parties_tbl in out nocopy csi_datastructures_pub.party_tbl,

5982: END not_the_same;
5983:
5984: PROCEDURE init_plsql_tables(
5985: px_instance_rec in out nocopy csi_datastructures_pub.instance_rec,
5986: px_parties_tbl in out nocopy csi_datastructures_pub.party_tbl,
5987: px_pty_accts_tbl in out nocopy csi_datastructures_pub.party_account_tbl,
5988: px_org_units_tbl in out nocopy csi_datastructures_pub.organization_units_tbl,
5989: px_ea_values_tbl in out nocopy csi_datastructures_pub.extend_attrib_values_tbl,
5990: px_pricing_tbl in out nocopy csi_datastructures_pub.pricing_attribs_tbl,

Line 5987: px_pty_accts_tbl in out nocopy csi_datastructures_pub.party_account_tbl,

5983:
5984: PROCEDURE init_plsql_tables(
5985: px_instance_rec in out nocopy csi_datastructures_pub.instance_rec,
5986: px_parties_tbl in out nocopy csi_datastructures_pub.party_tbl,
5987: px_pty_accts_tbl in out nocopy csi_datastructures_pub.party_account_tbl,
5988: px_org_units_tbl in out nocopy csi_datastructures_pub.organization_units_tbl,
5989: px_ea_values_tbl in out nocopy csi_datastructures_pub.extend_attrib_values_tbl,
5990: px_pricing_tbl in out nocopy csi_datastructures_pub.pricing_attribs_tbl,
5991: px_assets_tbl in out nocopy csi_datastructures_pub.instance_asset_tbl)

Line 5988: px_org_units_tbl in out nocopy csi_datastructures_pub.organization_units_tbl,

5984: PROCEDURE init_plsql_tables(
5985: px_instance_rec in out nocopy csi_datastructures_pub.instance_rec,
5986: px_parties_tbl in out nocopy csi_datastructures_pub.party_tbl,
5987: px_pty_accts_tbl in out nocopy csi_datastructures_pub.party_account_tbl,
5988: px_org_units_tbl in out nocopy csi_datastructures_pub.organization_units_tbl,
5989: px_ea_values_tbl in out nocopy csi_datastructures_pub.extend_attrib_values_tbl,
5990: px_pricing_tbl in out nocopy csi_datastructures_pub.pricing_attribs_tbl,
5991: px_assets_tbl in out nocopy csi_datastructures_pub.instance_asset_tbl)
5992: is

Line 5989: px_ea_values_tbl in out nocopy csi_datastructures_pub.extend_attrib_values_tbl,

5985: px_instance_rec in out nocopy csi_datastructures_pub.instance_rec,
5986: px_parties_tbl in out nocopy csi_datastructures_pub.party_tbl,
5987: px_pty_accts_tbl in out nocopy csi_datastructures_pub.party_account_tbl,
5988: px_org_units_tbl in out nocopy csi_datastructures_pub.organization_units_tbl,
5989: px_ea_values_tbl in out nocopy csi_datastructures_pub.extend_attrib_values_tbl,
5990: px_pricing_tbl in out nocopy csi_datastructures_pub.pricing_attribs_tbl,
5991: px_assets_tbl in out nocopy csi_datastructures_pub.instance_asset_tbl)
5992: is
5993: l_instance_rec csi_datastructures_pub.instance_rec;

Line 5990: px_pricing_tbl in out nocopy csi_datastructures_pub.pricing_attribs_tbl,

5986: px_parties_tbl in out nocopy csi_datastructures_pub.party_tbl,
5987: px_pty_accts_tbl in out nocopy csi_datastructures_pub.party_account_tbl,
5988: px_org_units_tbl in out nocopy csi_datastructures_pub.organization_units_tbl,
5989: px_ea_values_tbl in out nocopy csi_datastructures_pub.extend_attrib_values_tbl,
5990: px_pricing_tbl in out nocopy csi_datastructures_pub.pricing_attribs_tbl,
5991: px_assets_tbl in out nocopy csi_datastructures_pub.instance_asset_tbl)
5992: is
5993: l_instance_rec csi_datastructures_pub.instance_rec;
5994:

Line 5991: px_assets_tbl in out nocopy csi_datastructures_pub.instance_asset_tbl)

5987: px_pty_accts_tbl in out nocopy csi_datastructures_pub.party_account_tbl,
5988: px_org_units_tbl in out nocopy csi_datastructures_pub.organization_units_tbl,
5989: px_ea_values_tbl in out nocopy csi_datastructures_pub.extend_attrib_values_tbl,
5990: px_pricing_tbl in out nocopy csi_datastructures_pub.pricing_attribs_tbl,
5991: px_assets_tbl in out nocopy csi_datastructures_pub.instance_asset_tbl)
5992: is
5993: l_instance_rec csi_datastructures_pub.instance_rec;
5994:
5995: BEGIN

Line 5993: l_instance_rec csi_datastructures_pub.instance_rec;

5989: px_ea_values_tbl in out nocopy csi_datastructures_pub.extend_attrib_values_tbl,
5990: px_pricing_tbl in out nocopy csi_datastructures_pub.pricing_attribs_tbl,
5991: px_assets_tbl in out nocopy csi_datastructures_pub.instance_asset_tbl)
5992: is
5993: l_instance_rec csi_datastructures_pub.instance_rec;
5994:
5995: BEGIN
5996: px_instance_rec := l_instance_rec;
5997: px_parties_tbl.delete;

Line 6013: l_txn_rec csi_datastructures_pub.transaction_rec;

6009: mtl_txn_date
6010: FROM csi_diagnostics_temp
6011: WHERE process_flag = 'X';
6012:
6013: l_txn_rec csi_datastructures_pub.transaction_rec;
6014: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
6015: l_msg_count number;
6016: l_msg_data varchar2(2000);
6017:

Line 6064: p_txn_rec IN csi_datastructures_pub.transaction_rec,

6060: END LOOP;
6061: END knock_the_rest;
6062:
6063: PROCEDURE create_instance(
6064: p_txn_rec IN csi_datastructures_pub.transaction_rec,
6065: p_instance_rec IN csi_datastructures_pub.instance_rec,
6066: p_parties_tbl IN csi_datastructures_pub.party_tbl,
6067: p_pty_accts_tbl IN csi_datastructures_pub.party_account_tbl,
6068: x_return_status OUT nocopy varchar2,

Line 6065: p_instance_rec IN csi_datastructures_pub.instance_rec,

6061: END knock_the_rest;
6062:
6063: PROCEDURE create_instance(
6064: p_txn_rec IN csi_datastructures_pub.transaction_rec,
6065: p_instance_rec IN csi_datastructures_pub.instance_rec,
6066: p_parties_tbl IN csi_datastructures_pub.party_tbl,
6067: p_pty_accts_tbl IN csi_datastructures_pub.party_account_tbl,
6068: x_return_status OUT nocopy varchar2,
6069: x_error_message OUT nocopy varchar2)

Line 6066: p_parties_tbl IN csi_datastructures_pub.party_tbl,

6062:
6063: PROCEDURE create_instance(
6064: p_txn_rec IN csi_datastructures_pub.transaction_rec,
6065: p_instance_rec IN csi_datastructures_pub.instance_rec,
6066: p_parties_tbl IN csi_datastructures_pub.party_tbl,
6067: p_pty_accts_tbl IN csi_datastructures_pub.party_account_tbl,
6068: x_return_status OUT nocopy varchar2,
6069: x_error_message OUT nocopy varchar2)
6070: IS

Line 6067: p_pty_accts_tbl IN csi_datastructures_pub.party_account_tbl,

6063: PROCEDURE create_instance(
6064: p_txn_rec IN csi_datastructures_pub.transaction_rec,
6065: p_instance_rec IN csi_datastructures_pub.instance_rec,
6066: p_parties_tbl IN csi_datastructures_pub.party_tbl,
6067: p_pty_accts_tbl IN csi_datastructures_pub.party_account_tbl,
6068: x_return_status OUT nocopy varchar2,
6069: x_error_message OUT nocopy varchar2)
6070: IS
6071:

Line 6072: l_instance_rec csi_datastructures_pub.instance_rec;

6068: x_return_status OUT nocopy varchar2,
6069: x_error_message OUT nocopy varchar2)
6070: IS
6071:
6072: l_instance_rec csi_datastructures_pub.instance_rec;
6073: l_parties_tbl csi_datastructures_pub.party_tbl;
6074: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
6075: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
6076: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 6073: l_parties_tbl csi_datastructures_pub.party_tbl;

6069: x_error_message OUT nocopy varchar2)
6070: IS
6071:
6072: l_instance_rec csi_datastructures_pub.instance_rec;
6073: l_parties_tbl csi_datastructures_pub.party_tbl;
6074: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
6075: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
6076: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
6077: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 6074: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

6070: IS
6071:
6072: l_instance_rec csi_datastructures_pub.instance_rec;
6073: l_parties_tbl csi_datastructures_pub.party_tbl;
6074: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
6075: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
6076: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
6077: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
6078: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;

Line 6075: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;

6071:
6072: l_instance_rec csi_datastructures_pub.instance_rec;
6073: l_parties_tbl csi_datastructures_pub.party_tbl;
6074: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
6075: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
6076: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
6077: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
6078: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
6079: l_instance_ids_list csi_datastructures_pub.id_tbl;

Line 6076: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

6072: l_instance_rec csi_datastructures_pub.instance_rec;
6073: l_parties_tbl csi_datastructures_pub.party_tbl;
6074: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
6075: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
6076: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
6077: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
6078: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
6079: l_instance_ids_list csi_datastructures_pub.id_tbl;
6080: l_txn_rec csi_datastructures_pub.transaction_rec;

Line 6077: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

6073: l_parties_tbl csi_datastructures_pub.party_tbl;
6074: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
6075: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
6076: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
6077: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
6078: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
6079: l_instance_ids_list csi_datastructures_pub.id_tbl;
6080: l_txn_rec csi_datastructures_pub.transaction_rec;
6081:

Line 6078: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;

6074: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
6075: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
6076: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
6077: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
6078: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
6079: l_instance_ids_list csi_datastructures_pub.id_tbl;
6080: l_txn_rec csi_datastructures_pub.transaction_rec;
6081:
6082: l_error_message varchar2(2000);

Line 6079: l_instance_ids_list csi_datastructures_pub.id_tbl;

6075: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
6076: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
6077: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
6078: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
6079: l_instance_ids_list csi_datastructures_pub.id_tbl;
6080: l_txn_rec csi_datastructures_pub.transaction_rec;
6081:
6082: l_error_message varchar2(2000);
6083: l_msg_data varchar2(2000);

Line 6080: l_txn_rec csi_datastructures_pub.transaction_rec;

6076: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
6077: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
6078: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
6079: l_instance_ids_list csi_datastructures_pub.id_tbl;
6080: l_txn_rec csi_datastructures_pub.transaction_rec;
6081:
6082: l_error_message varchar2(2000);
6083: l_msg_data varchar2(2000);
6084: l_msg_count number;

Line 6127: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

6123: WHERE mssi.organization_id = l_instance_rec.inv_organization_id
6124: AND mssi.secondary_inventory_name = l_instance_rec.inv_subinventory_name
6125: AND haou.organization_id = mssi.organization_id;
6126: ELSIF l_instance_rec.location_type_code = 'WIP' THEN
6127: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
6128: csi_gen_utility_pvt.populate_install_param_rec;
6129: END IF;
6130: --
6131: l_instance_rec.location_id := csi_datastructures_pub.g_install_param_rec.wip_location_id;

Line 6131: l_instance_rec.location_id := csi_datastructures_pub.g_install_param_rec.wip_location_id;

6127: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
6128: csi_gen_utility_pvt.populate_install_param_rec;
6129: END IF;
6130: --
6131: l_instance_rec.location_id := csi_datastructures_pub.g_install_param_rec.wip_location_id;
6132: END IF;
6133:
6134: SELECT primary_uom_code
6135: INTO l_instance_rec.unit_of_measure

Line 6182: p_txn_rec IN csi_datastructures_pub.transaction_rec,

6178: x_error_message := csi_t_gen_utility_pvt.dump_error_stack;
6179: END create_instance;
6180:
6181: PROCEDURE update_instance(
6182: p_txn_rec IN csi_datastructures_pub.transaction_rec,
6183: p_instance_rec IN csi_datastructures_pub.instance_rec,
6184: p_parties_tbl IN csi_datastructures_pub.party_tbl,
6185: p_pty_accts_tbl IN csi_datastructures_pub.party_account_tbl,
6186: x_return_status OUT nocopy varchar2,

Line 6183: p_instance_rec IN csi_datastructures_pub.instance_rec,

6179: END create_instance;
6180:
6181: PROCEDURE update_instance(
6182: p_txn_rec IN csi_datastructures_pub.transaction_rec,
6183: p_instance_rec IN csi_datastructures_pub.instance_rec,
6184: p_parties_tbl IN csi_datastructures_pub.party_tbl,
6185: p_pty_accts_tbl IN csi_datastructures_pub.party_account_tbl,
6186: x_return_status OUT nocopy varchar2,
6187: x_error_message OUT nocopy varchar2)

Line 6184: p_parties_tbl IN csi_datastructures_pub.party_tbl,

6180:
6181: PROCEDURE update_instance(
6182: p_txn_rec IN csi_datastructures_pub.transaction_rec,
6183: p_instance_rec IN csi_datastructures_pub.instance_rec,
6184: p_parties_tbl IN csi_datastructures_pub.party_tbl,
6185: p_pty_accts_tbl IN csi_datastructures_pub.party_account_tbl,
6186: x_return_status OUT nocopy varchar2,
6187: x_error_message OUT nocopy varchar2)
6188: IS

Line 6185: p_pty_accts_tbl IN csi_datastructures_pub.party_account_tbl,

6181: PROCEDURE update_instance(
6182: p_txn_rec IN csi_datastructures_pub.transaction_rec,
6183: p_instance_rec IN csi_datastructures_pub.instance_rec,
6184: p_parties_tbl IN csi_datastructures_pub.party_tbl,
6185: p_pty_accts_tbl IN csi_datastructures_pub.party_account_tbl,
6186: x_return_status OUT nocopy varchar2,
6187: x_error_message OUT nocopy varchar2)
6188: IS
6189:

Line 6192: l_instance_rec csi_datastructures_pub.instance_rec;

6188: IS
6189:
6190: l_not_the_same boolean := TRUE;
6191:
6192: l_instance_rec csi_datastructures_pub.instance_rec;
6193: l_parties_tbl csi_datastructures_pub.party_tbl;
6194: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
6195: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
6196: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 6193: l_parties_tbl csi_datastructures_pub.party_tbl;

6189:
6190: l_not_the_same boolean := TRUE;
6191:
6192: l_instance_rec csi_datastructures_pub.instance_rec;
6193: l_parties_tbl csi_datastructures_pub.party_tbl;
6194: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
6195: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
6196: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
6197: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 6194: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

6190: l_not_the_same boolean := TRUE;
6191:
6192: l_instance_rec csi_datastructures_pub.instance_rec;
6193: l_parties_tbl csi_datastructures_pub.party_tbl;
6194: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
6195: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
6196: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
6197: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
6198: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;

Line 6195: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;

6191:
6192: l_instance_rec csi_datastructures_pub.instance_rec;
6193: l_parties_tbl csi_datastructures_pub.party_tbl;
6194: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
6195: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
6196: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
6197: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
6198: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
6199: l_instance_ids_list csi_datastructures_pub.id_tbl;

Line 6196: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

6192: l_instance_rec csi_datastructures_pub.instance_rec;
6193: l_parties_tbl csi_datastructures_pub.party_tbl;
6194: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
6195: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
6196: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
6197: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
6198: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
6199: l_instance_ids_list csi_datastructures_pub.id_tbl;
6200: l_txn_rec csi_datastructures_pub.transaction_rec;

Line 6197: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

6193: l_parties_tbl csi_datastructures_pub.party_tbl;
6194: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
6195: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
6196: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
6197: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
6198: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
6199: l_instance_ids_list csi_datastructures_pub.id_tbl;
6200: l_txn_rec csi_datastructures_pub.transaction_rec;
6201:

Line 6198: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;

6194: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
6195: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
6196: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
6197: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
6198: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
6199: l_instance_ids_list csi_datastructures_pub.id_tbl;
6200: l_txn_rec csi_datastructures_pub.transaction_rec;
6201:
6202: l_error_message varchar2(2000);

Line 6199: l_instance_ids_list csi_datastructures_pub.id_tbl;

6195: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
6196: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
6197: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
6198: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
6199: l_instance_ids_list csi_datastructures_pub.id_tbl;
6200: l_txn_rec csi_datastructures_pub.transaction_rec;
6201:
6202: l_error_message varchar2(2000);
6203: l_msg_data varchar2(2000);

Line 6200: l_txn_rec csi_datastructures_pub.transaction_rec;

6196: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
6197: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
6198: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
6199: l_instance_ids_list csi_datastructures_pub.id_tbl;
6200: l_txn_rec csi_datastructures_pub.transaction_rec;
6201:
6202: l_error_message varchar2(2000);
6203: l_msg_data varchar2(2000);
6204: l_msg_count number;

Line 6232: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

6228:
6229: END IF;
6230:
6231: IF l_instance_rec.location_type_code = 'WIP' THEN
6232: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
6233: csi_gen_utility_pvt.populate_install_param_rec;
6234: END IF;
6235: --
6236: l_instance_rec.location_id := csi_datastructures_pub.g_install_param_rec.wip_location_id;

Line 6236: l_instance_rec.location_id := csi_datastructures_pub.g_install_param_rec.wip_location_id;

6232: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
6233: csi_gen_utility_pvt.populate_install_param_rec;
6234: END IF;
6235: --
6236: l_instance_rec.location_id := csi_datastructures_pub.g_install_param_rec.wip_location_id;
6237: END IF;
6238:
6239: savepoint update_instance;
6240:

Line 6359: p_txn_rec IN csi_datastructures_pub.transaction_rec,

6355: END update_instance;
6356:
6357: PROCEDURE fix_soiship(
6358: p_diag_txn_rec IN diag_txn_rec,
6359: p_txn_rec IN csi_datastructures_pub.transaction_rec,
6360: x_return_status OUT nocopy varchar2,
6361: x_error_message OUT nocopy varchar2)
6362: IS
6363:

Line 6364: l_txn_rec csi_datastructures_pub.transaction_rec;

6360: x_return_status OUT nocopy varchar2,
6361: x_error_message OUT nocopy varchar2)
6362: IS
6363:
6364: l_txn_rec csi_datastructures_pub.transaction_rec;
6365:
6366: l_instance_rec csi_datastructures_pub.instance_rec;
6367: l_parties_tbl csi_datastructures_pub.party_tbl;
6368: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

Line 6366: l_instance_rec csi_datastructures_pub.instance_rec;

6362: IS
6363:
6364: l_txn_rec csi_datastructures_pub.transaction_rec;
6365:
6366: l_instance_rec csi_datastructures_pub.instance_rec;
6367: l_parties_tbl csi_datastructures_pub.party_tbl;
6368: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
6369:
6370: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 6367: l_parties_tbl csi_datastructures_pub.party_tbl;

6363:
6364: l_txn_rec csi_datastructures_pub.transaction_rec;
6365:
6366: l_instance_rec csi_datastructures_pub.instance_rec;
6367: l_parties_tbl csi_datastructures_pub.party_tbl;
6368: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
6369:
6370: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
6371: l_error_message varchar2(2000);

Line 6368: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

6364: l_txn_rec csi_datastructures_pub.transaction_rec;
6365:
6366: l_instance_rec csi_datastructures_pub.instance_rec;
6367: l_parties_tbl csi_datastructures_pub.party_tbl;
6368: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
6369:
6370: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
6371: l_error_message varchar2(2000);
6372:

Line 6514: l_instance_rec csi_datastructures_pub.instance_rec;

6510: l_quantity number;
6511: l_object_version_number number;
6512:
6513: l_internal_party_id number;
6514: l_instance_rec csi_datastructures_pub.instance_rec;
6515: l_parties_tbl csi_datastructures_pub.party_tbl;
6516: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
6517: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
6518: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 6515: l_parties_tbl csi_datastructures_pub.party_tbl;

6511: l_object_version_number number;
6512:
6513: l_internal_party_id number;
6514: l_instance_rec csi_datastructures_pub.instance_rec;
6515: l_parties_tbl csi_datastructures_pub.party_tbl;
6516: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
6517: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
6518: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
6519: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 6516: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

6512:
6513: l_internal_party_id number;
6514: l_instance_rec csi_datastructures_pub.instance_rec;
6515: l_parties_tbl csi_datastructures_pub.party_tbl;
6516: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
6517: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
6518: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
6519: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
6520: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;

Line 6517: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;

6513: l_internal_party_id number;
6514: l_instance_rec csi_datastructures_pub.instance_rec;
6515: l_parties_tbl csi_datastructures_pub.party_tbl;
6516: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
6517: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
6518: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
6519: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
6520: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
6521: l_instance_ids_list csi_datastructures_pub.id_tbl;

Line 6518: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

6514: l_instance_rec csi_datastructures_pub.instance_rec;
6515: l_parties_tbl csi_datastructures_pub.party_tbl;
6516: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
6517: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
6518: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
6519: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
6520: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
6521: l_instance_ids_list csi_datastructures_pub.id_tbl;
6522: l_txn_rec csi_datastructures_pub.transaction_rec;

Line 6519: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

6515: l_parties_tbl csi_datastructures_pub.party_tbl;
6516: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
6517: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
6518: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
6519: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
6520: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
6521: l_instance_ids_list csi_datastructures_pub.id_tbl;
6522: l_txn_rec csi_datastructures_pub.transaction_rec;
6523: l_diag_txn_rec diag_txn_rec;

Line 6520: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;

6516: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
6517: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
6518: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
6519: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
6520: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
6521: l_instance_ids_list csi_datastructures_pub.id_tbl;
6522: l_txn_rec csi_datastructures_pub.transaction_rec;
6523: l_diag_txn_rec diag_txn_rec;
6524:

Line 6521: l_instance_ids_list csi_datastructures_pub.id_tbl;

6517: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
6518: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
6519: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
6520: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
6521: l_instance_ids_list csi_datastructures_pub.id_tbl;
6522: l_txn_rec csi_datastructures_pub.transaction_rec;
6523: l_diag_txn_rec diag_txn_rec;
6524:
6525: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 6522: l_txn_rec csi_datastructures_pub.transaction_rec;

6518: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
6519: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
6520: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
6521: l_instance_ids_list csi_datastructures_pub.id_tbl;
6522: l_txn_rec csi_datastructures_pub.transaction_rec;
6523: l_diag_txn_rec diag_txn_rec;
6524:
6525: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
6526: l_msg_count number;

Line 6780: l_txn_rec csi_datastructures_pub.transaction_rec;

6776: x_return_status OUT nocopy varchar2,
6777: x_error_message OUT nocopy varchar2)
6778: IS
6779:
6780: l_txn_rec csi_datastructures_pub.transaction_rec;
6781:
6782: l_instance_rec csi_datastructures_pub.instance_rec;
6783: l_parties_tbl csi_datastructures_pub.party_tbl;
6784: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

Line 6782: l_instance_rec csi_datastructures_pub.instance_rec;

6778: IS
6779:
6780: l_txn_rec csi_datastructures_pub.transaction_rec;
6781:
6782: l_instance_rec csi_datastructures_pub.instance_rec;
6783: l_parties_tbl csi_datastructures_pub.party_tbl;
6784: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
6785:
6786: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 6783: l_parties_tbl csi_datastructures_pub.party_tbl;

6779:
6780: l_txn_rec csi_datastructures_pub.transaction_rec;
6781:
6782: l_instance_rec csi_datastructures_pub.instance_rec;
6783: l_parties_tbl csi_datastructures_pub.party_tbl;
6784: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
6785:
6786: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
6787: l_error_message varchar2(2000);

Line 6784: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

6780: l_txn_rec csi_datastructures_pub.transaction_rec;
6781:
6782: l_instance_rec csi_datastructures_pub.instance_rec;
6783: l_parties_tbl csi_datastructures_pub.party_tbl;
6784: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
6785:
6786: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
6787: l_error_message varchar2(2000);
6788:

Line 6867: l_txn_rec csi_datastructures_pub.transaction_rec;

6863:
6864: l_location_type_code varchar2(30);
6865: l_intransit_location_id number;
6866:
6867: l_txn_rec csi_datastructures_pub.transaction_rec;
6868:
6869: l_instance_rec csi_datastructures_pub.instance_rec;
6870: l_parties_tbl csi_datastructures_pub.party_tbl;
6871: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

Line 6869: l_instance_rec csi_datastructures_pub.instance_rec;

6865: l_intransit_location_id number;
6866:
6867: l_txn_rec csi_datastructures_pub.transaction_rec;
6868:
6869: l_instance_rec csi_datastructures_pub.instance_rec;
6870: l_parties_tbl csi_datastructures_pub.party_tbl;
6871: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
6872:
6873: CURSOR prev_txn_cur(

Line 6870: l_parties_tbl csi_datastructures_pub.party_tbl;

6866:
6867: l_txn_rec csi_datastructures_pub.transaction_rec;
6868:
6869: l_instance_rec csi_datastructures_pub.instance_rec;
6870: l_parties_tbl csi_datastructures_pub.party_tbl;
6871: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
6872:
6873: CURSOR prev_txn_cur(
6874: p_item_id IN number,

Line 6871: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

6867: l_txn_rec csi_datastructures_pub.transaction_rec;
6868:
6869: l_instance_rec csi_datastructures_pub.instance_rec;
6870: l_parties_tbl csi_datastructures_pub.party_tbl;
6871: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
6872:
6873: CURSOR prev_txn_cur(
6874: p_item_id IN number,
6875: p_serial_number IN varchar2,

Line 6897: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

6893:
6894: x_return_status := fnd_api.g_ret_sts_success;
6895:
6896: IF p_diag_txn_rec.inst_id is not null THEN
6897: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
6898: csi_gen_utility_pvt.populate_install_param_rec;
6899: END IF;
6900: --
6901: l_intransit_location_id := csi_datastructures_pub.g_install_param_rec.in_transit_location_id;

Line 6901: l_intransit_location_id := csi_datastructures_pub.g_install_param_rec.in_transit_location_id;

6897: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
6898: csi_gen_utility_pvt.populate_install_param_rec;
6899: END IF;
6900: --
6901: l_intransit_location_id := csi_datastructures_pub.g_install_param_rec.in_transit_location_id;
6902: --
6903:
6904: FOR prev_txn_rec IN prev_txn_cur(
6905: p_item_id => p_diag_txn_rec.item_id,

Line 7024: l_txn_rec csi_datastructures_pub.transaction_rec;

7020: x_return_status OUT nocopy varchar2,
7021: x_error_message OUT nocopy varchar2)
7022: IS
7023:
7024: l_txn_rec csi_datastructures_pub.transaction_rec;
7025:
7026: l_instance_rec csi_datastructures_pub.instance_rec;
7027: l_parties_tbl csi_datastructures_pub.party_tbl;
7028: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

Line 7026: l_instance_rec csi_datastructures_pub.instance_rec;

7022: IS
7023:
7024: l_txn_rec csi_datastructures_pub.transaction_rec;
7025:
7026: l_instance_rec csi_datastructures_pub.instance_rec;
7027: l_parties_tbl csi_datastructures_pub.party_tbl;
7028: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
7029:
7030: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 7027: l_parties_tbl csi_datastructures_pub.party_tbl;

7023:
7024: l_txn_rec csi_datastructures_pub.transaction_rec;
7025:
7026: l_instance_rec csi_datastructures_pub.instance_rec;
7027: l_parties_tbl csi_datastructures_pub.party_tbl;
7028: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
7029:
7030: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
7031: l_error_message varchar2(2000);

Line 7028: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

7024: l_txn_rec csi_datastructures_pub.transaction_rec;
7025:
7026: l_instance_rec csi_datastructures_pub.instance_rec;
7027: l_parties_tbl csi_datastructures_pub.party_tbl;
7028: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
7029:
7030: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
7031: l_error_message varchar2(2000);
7032:

Line 7108: l_txn_rec csi_datastructures_pub.transaction_rec;

7104: x_return_status OUT nocopy varchar2,
7105: x_error_message OUT nocopy varchar2)
7106: IS
7107:
7108: l_txn_rec csi_datastructures_pub.transaction_rec;
7109:
7110: l_instance_rec csi_datastructures_pub.instance_rec;
7111: l_parties_tbl csi_datastructures_pub.party_tbl;
7112: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

Line 7110: l_instance_rec csi_datastructures_pub.instance_rec;

7106: IS
7107:
7108: l_txn_rec csi_datastructures_pub.transaction_rec;
7109:
7110: l_instance_rec csi_datastructures_pub.instance_rec;
7111: l_parties_tbl csi_datastructures_pub.party_tbl;
7112: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
7113:
7114: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 7111: l_parties_tbl csi_datastructures_pub.party_tbl;

7107:
7108: l_txn_rec csi_datastructures_pub.transaction_rec;
7109:
7110: l_instance_rec csi_datastructures_pub.instance_rec;
7111: l_parties_tbl csi_datastructures_pub.party_tbl;
7112: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
7113:
7114: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
7115: l_error_message varchar2(2000);

Line 7112: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

7108: l_txn_rec csi_datastructures_pub.transaction_rec;
7109:
7110: l_instance_rec csi_datastructures_pub.instance_rec;
7111: l_parties_tbl csi_datastructures_pub.party_tbl;
7112: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
7113:
7114: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
7115: l_error_message varchar2(2000);
7116:

Line 7177: l_txn_rec csi_datastructures_pub.transaction_rec;

7173: x_return_status OUT nocopy varchar2,
7174: x_error_message OUT nocopy varchar2)
7175: IS
7176:
7177: l_txn_rec csi_datastructures_pub.transaction_rec;
7178:
7179: l_instance_rec csi_datastructures_pub.instance_rec;
7180: l_parties_tbl csi_datastructures_pub.party_tbl;
7181: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

Line 7179: l_instance_rec csi_datastructures_pub.instance_rec;

7175: IS
7176:
7177: l_txn_rec csi_datastructures_pub.transaction_rec;
7178:
7179: l_instance_rec csi_datastructures_pub.instance_rec;
7180: l_parties_tbl csi_datastructures_pub.party_tbl;
7181: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
7182:
7183: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 7180: l_parties_tbl csi_datastructures_pub.party_tbl;

7176:
7177: l_txn_rec csi_datastructures_pub.transaction_rec;
7178:
7179: l_instance_rec csi_datastructures_pub.instance_rec;
7180: l_parties_tbl csi_datastructures_pub.party_tbl;
7181: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
7182:
7183: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
7184: l_error_message varchar2(2000);

Line 7181: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

7177: l_txn_rec csi_datastructures_pub.transaction_rec;
7178:
7179: l_instance_rec csi_datastructures_pub.instance_rec;
7180: l_parties_tbl csi_datastructures_pub.party_tbl;
7181: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
7182:
7183: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
7184: l_error_message varchar2(2000);
7185:

Line 7246: l_txn_rec csi_datastructures_pub.transaction_rec;

7242: x_return_status OUT nocopy varchar2,
7243: x_error_message OUT nocopy varchar2)
7244: IS
7245:
7246: l_txn_rec csi_datastructures_pub.transaction_rec;
7247:
7248: l_instance_rec csi_datastructures_pub.instance_rec;
7249: l_parties_tbl csi_datastructures_pub.party_tbl;
7250: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

Line 7248: l_instance_rec csi_datastructures_pub.instance_rec;

7244: IS
7245:
7246: l_txn_rec csi_datastructures_pub.transaction_rec;
7247:
7248: l_instance_rec csi_datastructures_pub.instance_rec;
7249: l_parties_tbl csi_datastructures_pub.party_tbl;
7250: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
7251:
7252: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 7249: l_parties_tbl csi_datastructures_pub.party_tbl;

7245:
7246: l_txn_rec csi_datastructures_pub.transaction_rec;
7247:
7248: l_instance_rec csi_datastructures_pub.instance_rec;
7249: l_parties_tbl csi_datastructures_pub.party_tbl;
7250: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
7251:
7252: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
7253: l_error_message varchar2(2000);

Line 7250: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

7246: l_txn_rec csi_datastructures_pub.transaction_rec;
7247:
7248: l_instance_rec csi_datastructures_pub.instance_rec;
7249: l_parties_tbl csi_datastructures_pub.party_tbl;
7250: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
7251:
7252: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
7253: l_error_message varchar2(2000);
7254:

Line 7330: l_txn_rec csi_datastructures_pub.transaction_rec;

7326: x_return_status OUT nocopy varchar2,
7327: x_error_message OUT nocopy varchar2)
7328: IS
7329:
7330: l_txn_rec csi_datastructures_pub.transaction_rec;
7331:
7332: l_instance_rec csi_datastructures_pub.instance_rec;
7333: l_parties_tbl csi_datastructures_pub.party_tbl;
7334: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

Line 7332: l_instance_rec csi_datastructures_pub.instance_rec;

7328: IS
7329:
7330: l_txn_rec csi_datastructures_pub.transaction_rec;
7331:
7332: l_instance_rec csi_datastructures_pub.instance_rec;
7333: l_parties_tbl csi_datastructures_pub.party_tbl;
7334: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
7335:
7336: l_location_type_code varchar2(30);

Line 7333: l_parties_tbl csi_datastructures_pub.party_tbl;

7329:
7330: l_txn_rec csi_datastructures_pub.transaction_rec;
7331:
7332: l_instance_rec csi_datastructures_pub.instance_rec;
7333: l_parties_tbl csi_datastructures_pub.party_tbl;
7334: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
7335:
7336: l_location_type_code varchar2(30);
7337:

Line 7334: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

7330: l_txn_rec csi_datastructures_pub.transaction_rec;
7331:
7332: l_instance_rec csi_datastructures_pub.instance_rec;
7333: l_parties_tbl csi_datastructures_pub.party_tbl;
7334: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
7335:
7336: l_location_type_code varchar2(30);
7337:
7338: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 7409: l_txn_rec csi_datastructures_pub.transaction_rec;

7405: x_error_message OUT nocopy varchar2)
7406: IS
7407:
7408: l_mtl_xfer_txn_id number;
7409: l_txn_rec csi_datastructures_pub.transaction_rec;
7410:
7411: l_instance_rec csi_datastructures_pub.instance_rec;
7412: l_parties_tbl csi_datastructures_pub.party_tbl;
7413: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

Line 7411: l_instance_rec csi_datastructures_pub.instance_rec;

7407:
7408: l_mtl_xfer_txn_id number;
7409: l_txn_rec csi_datastructures_pub.transaction_rec;
7410:
7411: l_instance_rec csi_datastructures_pub.instance_rec;
7412: l_parties_tbl csi_datastructures_pub.party_tbl;
7413: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
7414:
7415: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 7412: l_parties_tbl csi_datastructures_pub.party_tbl;

7408: l_mtl_xfer_txn_id number;
7409: l_txn_rec csi_datastructures_pub.transaction_rec;
7410:
7411: l_instance_rec csi_datastructures_pub.instance_rec;
7412: l_parties_tbl csi_datastructures_pub.party_tbl;
7413: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
7414:
7415: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
7416: l_error_message varchar2(2000);

Line 7413: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

7409: l_txn_rec csi_datastructures_pub.transaction_rec;
7410:
7411: l_instance_rec csi_datastructures_pub.instance_rec;
7412: l_parties_tbl csi_datastructures_pub.party_tbl;
7413: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
7414:
7415: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
7416: l_error_message varchar2(2000);
7417:

Line 7500: l_txn_rec csi_datastructures_pub.transaction_rec;

7496: x_return_status OUT nocopy varchar2,
7497: x_error_message OUT nocopy varchar2)
7498: IS
7499:
7500: l_txn_rec csi_datastructures_pub.transaction_rec;
7501:
7502: l_instance_rec csi_datastructures_pub.instance_rec;
7503: l_parties_tbl csi_datastructures_pub.party_tbl;
7504: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

Line 7502: l_instance_rec csi_datastructures_pub.instance_rec;

7498: IS
7499:
7500: l_txn_rec csi_datastructures_pub.transaction_rec;
7501:
7502: l_instance_rec csi_datastructures_pub.instance_rec;
7503: l_parties_tbl csi_datastructures_pub.party_tbl;
7504: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
7505:
7506: l_project_location_id number;

Line 7503: l_parties_tbl csi_datastructures_pub.party_tbl;

7499:
7500: l_txn_rec csi_datastructures_pub.transaction_rec;
7501:
7502: l_instance_rec csi_datastructures_pub.instance_rec;
7503: l_parties_tbl csi_datastructures_pub.party_tbl;
7504: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
7505:
7506: l_project_location_id number;
7507:

Line 7504: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

7500: l_txn_rec csi_datastructures_pub.transaction_rec;
7501:
7502: l_instance_rec csi_datastructures_pub.instance_rec;
7503: l_parties_tbl csi_datastructures_pub.party_tbl;
7504: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
7505:
7506: l_project_location_id number;
7507:
7508: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 7515: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

7511: BEGIN
7512:
7513: x_return_status := fnd_api.g_ret_sts_success;
7514:
7515: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
7516: csi_gen_utility_pvt.populate_install_param_rec;
7517: END IF;
7518: --
7519: l_project_location_id := csi_datastructures_pub.g_install_param_rec.project_location_id;

Line 7519: l_project_location_id := csi_datastructures_pub.g_install_param_rec.project_location_id;

7515: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
7516: csi_gen_utility_pvt.populate_install_param_rec;
7517: END IF;
7518: --
7519: l_project_location_id := csi_datastructures_pub.g_install_param_rec.project_location_id;
7520: --
7521:
7522: FOR inv_rec IN inv_cur (p_diag_txn_rec.mtl_txn_id)
7523: LOOP

Line 7594: l_txn_rec csi_datastructures_pub.transaction_rec;

7590: x_return_status OUT nocopy varchar2,
7591: x_error_message OUT nocopy varchar2)
7592: IS
7593:
7594: l_txn_rec csi_datastructures_pub.transaction_rec;
7595:
7596: l_internal_party_id number;
7597: l_src_serial_code number;
7598: l_lot_number varchar2(80);

Line 7602: l_instance_rec_tmp csi_datastructures_pub.instance_rec;

7598: l_lot_number varchar2(80);
7599: l_inv_location_id number;
7600:
7601: l_instance_quantity number;
7602: l_instance_rec_tmp csi_datastructures_pub.instance_rec;
7603: l_instance_rec csi_datastructures_pub.instance_rec;
7604: l_parties_tbl csi_datastructures_pub.party_tbl;
7605: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
7606: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;

Line 7603: l_instance_rec csi_datastructures_pub.instance_rec;

7599: l_inv_location_id number;
7600:
7601: l_instance_quantity number;
7602: l_instance_rec_tmp csi_datastructures_pub.instance_rec;
7603: l_instance_rec csi_datastructures_pub.instance_rec;
7604: l_parties_tbl csi_datastructures_pub.party_tbl;
7605: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
7606: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
7607: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 7604: l_parties_tbl csi_datastructures_pub.party_tbl;

7600:
7601: l_instance_quantity number;
7602: l_instance_rec_tmp csi_datastructures_pub.instance_rec;
7603: l_instance_rec csi_datastructures_pub.instance_rec;
7604: l_parties_tbl csi_datastructures_pub.party_tbl;
7605: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
7606: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
7607: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
7608: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 7605: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

7601: l_instance_quantity number;
7602: l_instance_rec_tmp csi_datastructures_pub.instance_rec;
7603: l_instance_rec csi_datastructures_pub.instance_rec;
7604: l_parties_tbl csi_datastructures_pub.party_tbl;
7605: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
7606: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
7607: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
7608: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
7609: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;

Line 7606: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;

7602: l_instance_rec_tmp csi_datastructures_pub.instance_rec;
7603: l_instance_rec csi_datastructures_pub.instance_rec;
7604: l_parties_tbl csi_datastructures_pub.party_tbl;
7605: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
7606: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
7607: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
7608: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
7609: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
7610: l_instance_ids_list csi_datastructures_pub.id_tbl;

Line 7607: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

7603: l_instance_rec csi_datastructures_pub.instance_rec;
7604: l_parties_tbl csi_datastructures_pub.party_tbl;
7605: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
7606: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
7607: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
7608: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
7609: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
7610: l_instance_ids_list csi_datastructures_pub.id_tbl;
7611:

Line 7608: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

7604: l_parties_tbl csi_datastructures_pub.party_tbl;
7605: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
7606: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
7607: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
7608: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
7609: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
7610: l_instance_ids_list csi_datastructures_pub.id_tbl;
7611:
7612: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

Line 7609: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;

7605: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
7606: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
7607: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
7608: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
7609: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
7610: l_instance_ids_list csi_datastructures_pub.id_tbl;
7611:
7612: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
7613: l_msg_data varchar2(2000);

Line 7610: l_instance_ids_list csi_datastructures_pub.id_tbl;

7606: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
7607: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
7608: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
7609: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
7610: l_instance_ids_list csi_datastructures_pub.id_tbl;
7611:
7612: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
7613: l_msg_data varchar2(2000);
7614: l_msg_count number;

Line 7623: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

7619: BEGIN
7620:
7621: x_return_status := fnd_api.g_ret_sts_success;
7622:
7623: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
7624: csi_gen_utility_pvt.populate_install_param_rec;
7625: END IF;
7626: --
7627: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;

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

7623: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
7624: csi_gen_utility_pvt.populate_install_param_rec;
7625: END IF;
7626: --
7627: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
7628: --
7629: FOR inv_rec IN inv_cur (p_diag_txn_rec.mtl_txn_id)
7630: LOOP
7631:

Line 7876: l_txn_rec csi_datastructures_pub.transaction_rec;

7872: x_return_status OUT nocopy varchar2,
7873: x_error_message OUT nocopy varchar2)
7874: IS
7875:
7876: l_txn_rec csi_datastructures_pub.transaction_rec;
7877:
7878: l_instance_rec csi_datastructures_pub.instance_rec;
7879: l_parties_tbl csi_datastructures_pub.party_tbl;
7880: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

Line 7878: l_instance_rec csi_datastructures_pub.instance_rec;

7874: IS
7875:
7876: l_txn_rec csi_datastructures_pub.transaction_rec;
7877:
7878: l_instance_rec csi_datastructures_pub.instance_rec;
7879: l_parties_tbl csi_datastructures_pub.party_tbl;
7880: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
7881: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
7882: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 7879: l_parties_tbl csi_datastructures_pub.party_tbl;

7875:
7876: l_txn_rec csi_datastructures_pub.transaction_rec;
7877:
7878: l_instance_rec csi_datastructures_pub.instance_rec;
7879: l_parties_tbl csi_datastructures_pub.party_tbl;
7880: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
7881: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
7882: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
7883: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 7880: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

7876: l_txn_rec csi_datastructures_pub.transaction_rec;
7877:
7878: l_instance_rec csi_datastructures_pub.instance_rec;
7879: l_parties_tbl csi_datastructures_pub.party_tbl;
7880: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
7881: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
7882: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
7883: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
7884: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;

Line 7881: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;

7877:
7878: l_instance_rec csi_datastructures_pub.instance_rec;
7879: l_parties_tbl csi_datastructures_pub.party_tbl;
7880: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
7881: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
7882: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
7883: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
7884: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
7885: l_instance_ids_list csi_datastructures_pub.id_tbl;

Line 7882: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

7878: l_instance_rec csi_datastructures_pub.instance_rec;
7879: l_parties_tbl csi_datastructures_pub.party_tbl;
7880: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
7881: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
7882: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
7883: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
7884: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
7885: l_instance_ids_list csi_datastructures_pub.id_tbl;
7886:

Line 7883: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

7879: l_parties_tbl csi_datastructures_pub.party_tbl;
7880: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
7881: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
7882: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
7883: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
7884: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
7885: l_instance_ids_list csi_datastructures_pub.id_tbl;
7886:
7887: l_src_serial_code number;

Line 7884: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;

7880: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
7881: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
7882: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
7883: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
7884: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
7885: l_instance_ids_list csi_datastructures_pub.id_tbl;
7886:
7887: l_src_serial_code number;
7888: l_dest_serial_code number;

Line 7885: l_instance_ids_list csi_datastructures_pub.id_tbl;

7881: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
7882: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
7883: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
7884: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
7885: l_instance_ids_list csi_datastructures_pub.id_tbl;
7886:
7887: l_src_serial_code number;
7888: l_dest_serial_code number;
7889:

Line 7905: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

7901: BEGIN
7902:
7903: x_return_status := fnd_api.g_ret_sts_success;
7904:
7905: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
7906: csi_gen_utility_pvt.populate_install_param_rec;
7907: END IF;
7908: --
7909: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;

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

7905: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
7906: csi_gen_utility_pvt.populate_install_param_rec;
7907: END IF;
7908: --
7909: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
7910: l_intransit_location_id := csi_datastructures_pub.g_install_param_rec.in_transit_location_id;
7911: --
7912: FOR inv_rec IN inv_cur (p_diag_txn_rec.mtl_txn_id)
7913: LOOP

Line 7910: l_intransit_location_id := csi_datastructures_pub.g_install_param_rec.in_transit_location_id;

7906: csi_gen_utility_pvt.populate_install_param_rec;
7907: END IF;
7908: --
7909: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
7910: l_intransit_location_id := csi_datastructures_pub.g_install_param_rec.in_transit_location_id;
7911: --
7912: FOR inv_rec IN inv_cur (p_diag_txn_rec.mtl_txn_id)
7913: LOOP
7914:

Line 8166: l_txn_rec csi_datastructures_pub.transaction_rec;

8162: WHERE mmt.transaction_id = p_mtl_txn_id
8163: AND mtln.transaction_id = mmt.transaction_id
8164: AND p_lot_code <> 1;
8165:
8166: l_txn_rec csi_datastructures_pub.transaction_rec;
8167:
8168: l_instance_rec csi_datastructures_pub.instance_rec;
8169: l_parties_tbl csi_datastructures_pub.party_tbl;
8170: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

Line 8168: l_instance_rec csi_datastructures_pub.instance_rec;

8164: AND p_lot_code <> 1;
8165:
8166: l_txn_rec csi_datastructures_pub.transaction_rec;
8167:
8168: l_instance_rec csi_datastructures_pub.instance_rec;
8169: l_parties_tbl csi_datastructures_pub.party_tbl;
8170: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
8171: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
8172: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 8169: l_parties_tbl csi_datastructures_pub.party_tbl;

8165:
8166: l_txn_rec csi_datastructures_pub.transaction_rec;
8167:
8168: l_instance_rec csi_datastructures_pub.instance_rec;
8169: l_parties_tbl csi_datastructures_pub.party_tbl;
8170: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
8171: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
8172: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
8173: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 8170: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

8166: l_txn_rec csi_datastructures_pub.transaction_rec;
8167:
8168: l_instance_rec csi_datastructures_pub.instance_rec;
8169: l_parties_tbl csi_datastructures_pub.party_tbl;
8170: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
8171: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
8172: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
8173: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
8174: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;

Line 8171: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;

8167:
8168: l_instance_rec csi_datastructures_pub.instance_rec;
8169: l_parties_tbl csi_datastructures_pub.party_tbl;
8170: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
8171: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
8172: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
8173: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
8174: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
8175: l_instance_ids_list csi_datastructures_pub.id_tbl;

Line 8172: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

8168: l_instance_rec csi_datastructures_pub.instance_rec;
8169: l_parties_tbl csi_datastructures_pub.party_tbl;
8170: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
8171: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
8172: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
8173: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
8174: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
8175: l_instance_ids_list csi_datastructures_pub.id_tbl;
8176:

Line 8173: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

8169: l_parties_tbl csi_datastructures_pub.party_tbl;
8170: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
8171: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
8172: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
8173: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
8174: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
8175: l_instance_ids_list csi_datastructures_pub.id_tbl;
8176:
8177: l_internal_party_id number;

Line 8174: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;

8170: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
8171: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
8172: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
8173: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
8174: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
8175: l_instance_ids_list csi_datastructures_pub.id_tbl;
8176:
8177: l_internal_party_id number;
8178: l_intransit_location_id number;

Line 8175: l_instance_ids_list csi_datastructures_pub.id_tbl;

8171: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
8172: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
8173: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
8174: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
8175: l_instance_ids_list csi_datastructures_pub.id_tbl;
8176:
8177: l_internal_party_id number;
8178: l_intransit_location_id number;
8179:

Line 8200: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

8196: BEGIN
8197:
8198: x_return_status := fnd_api.g_ret_sts_success;
8199:
8200: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
8201: csi_gen_utility_pvt.populate_install_param_rec;
8202: END IF;
8203: --
8204: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;

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

8200: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
8201: csi_gen_utility_pvt.populate_install_param_rec;
8202: END IF;
8203: --
8204: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
8205: l_intransit_location_id := csi_datastructures_pub.g_install_param_rec.in_transit_location_id;
8206: --
8207: FOR inv_rec IN inv_cur (p_diag_txn_rec.mtl_txn_id)
8208: LOOP

Line 8205: l_intransit_location_id := csi_datastructures_pub.g_install_param_rec.in_transit_location_id;

8201: csi_gen_utility_pvt.populate_install_param_rec;
8202: END IF;
8203: --
8204: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
8205: l_intransit_location_id := csi_datastructures_pub.g_install_param_rec.in_transit_location_id;
8206: --
8207: FOR inv_rec IN inv_cur (p_diag_txn_rec.mtl_txn_id)
8208: LOOP
8209:

Line 8769: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

8765: FROM csi_txn_sub_types
8766: WHERE transaction_type_id = 53
8767: AND default_flag = 'Y';
8768: --
8769: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
8770: csi_gen_utility_pvt.populate_install_param_rec;
8771: END IF;
8772: --
8773: l_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;

Line 8773: l_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;

8769: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
8770: csi_gen_utility_pvt.populate_install_param_rec;
8771: END IF;
8772: --
8773: l_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;
8774:
8775: l_change_owner_flag := 'Y';
8776: l_rma_line_id := null;
8777: l_sub_type_id := null;

Line 8881: l_instance_rec csi_datastructures_pub.instance_rec;

8877: l_instance varchar2(30);
8878: l_instance_found boolean := TRUE;
8879: l_not_the_same boolean := TRUE;
8880:
8881: l_instance_rec csi_datastructures_pub.instance_rec;
8882: l_parties_tbl csi_datastructures_pub.party_tbl;
8883: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
8884: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
8885: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

Line 8882: l_parties_tbl csi_datastructures_pub.party_tbl;

8878: l_instance_found boolean := TRUE;
8879: l_not_the_same boolean := TRUE;
8880:
8881: l_instance_rec csi_datastructures_pub.instance_rec;
8882: l_parties_tbl csi_datastructures_pub.party_tbl;
8883: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
8884: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
8885: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
8886: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

Line 8883: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

8879: l_not_the_same boolean := TRUE;
8880:
8881: l_instance_rec csi_datastructures_pub.instance_rec;
8882: l_parties_tbl csi_datastructures_pub.party_tbl;
8883: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
8884: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
8885: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
8886: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
8887: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;

Line 8884: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;

8880:
8881: l_instance_rec csi_datastructures_pub.instance_rec;
8882: l_parties_tbl csi_datastructures_pub.party_tbl;
8883: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
8884: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
8885: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
8886: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
8887: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
8888: l_instance_ids_list csi_datastructures_pub.id_tbl;

Line 8885: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;

8881: l_instance_rec csi_datastructures_pub.instance_rec;
8882: l_parties_tbl csi_datastructures_pub.party_tbl;
8883: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
8884: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
8885: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
8886: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
8887: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
8888: l_instance_ids_list csi_datastructures_pub.id_tbl;
8889: l_txn_rec csi_datastructures_pub.transaction_rec;

Line 8886: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;

8882: l_parties_tbl csi_datastructures_pub.party_tbl;
8883: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
8884: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
8885: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
8886: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
8887: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
8888: l_instance_ids_list csi_datastructures_pub.id_tbl;
8889: l_txn_rec csi_datastructures_pub.transaction_rec;
8890: l_freeze_date date;

Line 8887: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;

8883: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
8884: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
8885: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
8886: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
8887: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
8888: l_instance_ids_list csi_datastructures_pub.id_tbl;
8889: l_txn_rec csi_datastructures_pub.transaction_rec;
8890: l_freeze_date date;
8891: l_latest_txn boolean := TRUE;

Line 8888: l_instance_ids_list csi_datastructures_pub.id_tbl;

8884: l_org_units_tbl csi_datastructures_pub.organization_units_tbl;
8885: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
8886: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
8887: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
8888: l_instance_ids_list csi_datastructures_pub.id_tbl;
8889: l_txn_rec csi_datastructures_pub.transaction_rec;
8890: l_freeze_date date;
8891: l_latest_txn boolean := TRUE;
8892: l_pending_msg_found varchar2(1);

Line 8889: l_txn_rec csi_datastructures_pub.transaction_rec;

8885: l_ea_values_tbl csi_datastructures_pub.extend_attrib_values_tbl;
8886: l_pricing_tbl csi_datastructures_pub.pricing_attribs_tbl;
8887: l_assets_tbl csi_datastructures_pub.instance_asset_tbl;
8888: l_instance_ids_list csi_datastructures_pub.id_tbl;
8889: l_txn_rec csi_datastructures_pub.transaction_rec;
8890: l_freeze_date date;
8891: l_latest_txn boolean := TRUE;
8892: l_pending_msg_found varchar2(1);
8893: l_pending_err_found varchar2(1);

Line 8918: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

8914: SELECT fnd_Profile.value('csi_upgrading_from_release')
8915: INTO l_release
8916: FROM sys.dual;
8917: --
8918: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
8919: csi_gen_utility_pvt.populate_install_param_rec;
8920: END IF;
8921: --
8922: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;

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

8918: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
8919: csi_gen_utility_pvt.populate_install_param_rec;
8920: END IF;
8921: --
8922: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
8923: l_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;
8924:
8925: FOR srl_rec IN inv_srl_cur
8926: LOOP

Line 8923: l_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;

8919: csi_gen_utility_pvt.populate_install_param_rec;
8920: END IF;
8921: --
8922: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
8923: l_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;
8924:
8925: FOR srl_rec IN inv_srl_cur
8926: LOOP
8927:

Line 9286: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl

9282: END sync_inv_serials;
9283: --
9284: PROCEDURE Get_Next_Level
9285: (p_object_id IN NUMBER,
9286: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl
9287: ) IS
9288: --
9289: l_rel_type_code VARCHAR2(30) := 'COMPONENT-OF';
9290: --

Line 9869: l_instance_rec csi_datastructures_pub.instance_rec;

9865: WHERE location_type_code = 'INVENTORY'
9866: AND inv_organization_id is not null
9867: AND nvl(last_vld_organization_id,-999) <> inv_organization_id;
9868: --
9869: l_instance_rec csi_datastructures_pub.instance_rec;
9870: l_temp_instance_rec csi_datastructures_pub.instance_rec;
9871: l_txn_rec csi_datastructures_pub.transaction_rec;
9872: l_return_value BOOLEAN;
9873: --

Line 9870: l_temp_instance_rec csi_datastructures_pub.instance_rec;

9866: AND inv_organization_id is not null
9867: AND nvl(last_vld_organization_id,-999) <> inv_organization_id;
9868: --
9869: l_instance_rec csi_datastructures_pub.instance_rec;
9870: l_temp_instance_rec csi_datastructures_pub.instance_rec;
9871: l_txn_rec csi_datastructures_pub.transaction_rec;
9872: l_return_value BOOLEAN;
9873: --
9874: Type NumTabType is VARRAY(10000) of NUMBER;

Line 9871: l_txn_rec csi_datastructures_pub.transaction_rec;

9867: AND nvl(last_vld_organization_id,-999) <> inv_organization_id;
9868: --
9869: l_instance_rec csi_datastructures_pub.instance_rec;
9870: l_temp_instance_rec csi_datastructures_pub.instance_rec;
9871: l_txn_rec csi_datastructures_pub.transaction_rec;
9872: l_return_value BOOLEAN;
9873: --
9874: Type NumTabType is VARRAY(10000) of NUMBER;
9875: instance_id_mig NumTabType;

Line 10260: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

10256: raise_application_error(-20000,'Too many definition for Expired Instance Status');
10257: return;
10258: end;
10259: --
10260: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
10261: csi_gen_utility_pvt.populate_install_param_rec;
10262: END IF;
10263: --
10264: v_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;

Line 10264: v_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;

10260: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
10261: csi_gen_utility_pvt.populate_install_param_rec;
10262: END IF;
10263: --
10264: v_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;
10265: --
10266: for i in c1
10267: loop
10268: v_inv_instance_id := null;

Line 10765: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

10761: ,-1
10762: ,1
10763: );
10764: --
10765: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
10766: csi_gen_utility_pvt.populate_install_param_rec;
10767: END IF;
10768: --
10769: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;

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

10765: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
10766: csi_gen_utility_pvt.populate_install_param_rec;
10767: END IF;
10768: --
10769: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
10770: --
10771: FOR party_rec in PARTY_HIST_CUR LOOP
10772: Update CSI_I_PARTIES
10773: set relationship_type_code = party_rec.old_rel_type,

Line 10966: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl

10962: END Update_Master_Organization_ID;
10963: --
10964: PROCEDURE Get_Children
10965: (p_object_id IN NUMBER,
10966: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl
10967: ) IS
10968: --
10969: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
10970: l_rel_tbl_next_lvl csi_datastructures_pub.ii_relationship_tbl;

Line 10969: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;

10965: (p_object_id IN NUMBER,
10966: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl
10967: ) IS
10968: --
10969: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
10970: l_rel_tbl_next_lvl csi_datastructures_pub.ii_relationship_tbl;
10971: l_rel_tbl_temp csi_datastructures_pub.ii_relationship_tbl;
10972: l_rel_tbl_final csi_datastructures_pub.ii_relationship_tbl;
10973: l_next_ind NUMBER := 0;

Line 10970: l_rel_tbl_next_lvl csi_datastructures_pub.ii_relationship_tbl;

10966: p_rel_tbl OUT NOCOPY csi_datastructures_pub.ii_relationship_tbl
10967: ) IS
10968: --
10969: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
10970: l_rel_tbl_next_lvl csi_datastructures_pub.ii_relationship_tbl;
10971: l_rel_tbl_temp csi_datastructures_pub.ii_relationship_tbl;
10972: l_rel_tbl_final csi_datastructures_pub.ii_relationship_tbl;
10973: l_next_ind NUMBER := 0;
10974: l_final_ind NUMBER := 0;

Line 10971: l_rel_tbl_temp csi_datastructures_pub.ii_relationship_tbl;

10967: ) IS
10968: --
10969: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
10970: l_rel_tbl_next_lvl csi_datastructures_pub.ii_relationship_tbl;
10971: l_rel_tbl_temp csi_datastructures_pub.ii_relationship_tbl;
10972: l_rel_tbl_final csi_datastructures_pub.ii_relationship_tbl;
10973: l_next_ind NUMBER := 0;
10974: l_final_ind NUMBER := 0;
10975: l_ctr NUMBER := 0;

Line 10972: l_rel_tbl_final csi_datastructures_pub.ii_relationship_tbl;

10968: --
10969: l_rel_tbl csi_datastructures_pub.ii_relationship_tbl;
10970: l_rel_tbl_next_lvl csi_datastructures_pub.ii_relationship_tbl;
10971: l_rel_tbl_temp csi_datastructures_pub.ii_relationship_tbl;
10972: l_rel_tbl_final csi_datastructures_pub.ii_relationship_tbl;
10973: l_next_ind NUMBER := 0;
10974: l_final_ind NUMBER := 0;
10975: l_ctr NUMBER := 0;
10976: l_found NUMBER;

Line 11284: l_child_tbl csi_datastructures_pub.ii_relationship_tbl;

11280: l_inst_hist_tbl NUMLIST;
11281: l_req_count NUMBER := 0;
11282: l_req_tbl NUMLIST;
11283: v_request_id NUMBER;
11284: l_child_tbl csi_datastructures_pub.ii_relationship_tbl;
11285: l_contracts_status VARCHAR2(3);
11286: l_ins_flag VARCHAR2(1) := 'N';
11287: --
11288: Type NumTabType is VARRAY(10000) of NUMBER;

Line 12229: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

12225: --
12226: Comp_error EXCEPTION;
12227: Process_next EXCEPTION;
12228: BEGIN
12229: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
12230: csi_gen_utility_pvt.populate_install_param_rec;
12231: END IF;
12232: --
12233: v_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;

Line 12233: v_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;

12229: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
12230: csi_gen_utility_pvt.populate_install_param_rec;
12231: END IF;
12232: --
12233: v_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;
12234: --
12235: -- Get the Transaction Type ID for Txn Type MIGRATED
12236: Begin
12237: select transaction_type_id

Line 12268: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

12264: v_err_msg := 'Error in getting the Status ID in CSI for Latest Status';
12265: Raise comp_error;
12266: End;
12267: -- Get the Internal Party ID
12268: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
12269: csi_gen_utility_pvt.populate_install_param_rec;
12270: END IF;
12271: --
12272: v_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;

Line 12272: v_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;

12268: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
12269: csi_gen_utility_pvt.populate_install_param_rec;
12270: END IF;
12271: --
12272: v_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
12273: --
12274: if v_party_id is null then
12275: v_err_msg := 'Internal Party ID not found in CSI_INSTALL_PARAMETERS';
12276: Raise comp_error;

Line 13375: l_txn_rec csi_datastructures_pub.transaction_rec;

13371: l_owner_party_id number;
13372: l_owner_account_id number;
13373: l_internal_party_id number;
13374:
13375: l_txn_rec csi_datastructures_pub.transaction_rec;
13376: l_instance_rec csi_datastructures_pub.instance_rec;
13377: l_parties_tbl csi_datastructures_pub.party_tbl;
13378: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
13379:

Line 13376: l_instance_rec csi_datastructures_pub.instance_rec;

13372: l_owner_account_id number;
13373: l_internal_party_id number;
13374:
13375: l_txn_rec csi_datastructures_pub.transaction_rec;
13376: l_instance_rec csi_datastructures_pub.instance_rec;
13377: l_parties_tbl csi_datastructures_pub.party_tbl;
13378: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
13379:
13380: l_error_message varchar2(2000);

Line 13377: l_parties_tbl csi_datastructures_pub.party_tbl;

13373: l_internal_party_id number;
13374:
13375: l_txn_rec csi_datastructures_pub.transaction_rec;
13376: l_instance_rec csi_datastructures_pub.instance_rec;
13377: l_parties_tbl csi_datastructures_pub.party_tbl;
13378: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
13379:
13380: l_error_message varchar2(2000);
13381:

Line 13378: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;

13374:
13375: l_txn_rec csi_datastructures_pub.transaction_rec;
13376: l_instance_rec csi_datastructures_pub.instance_rec;
13377: l_parties_tbl csi_datastructures_pub.party_tbl;
13378: l_pty_accts_tbl csi_datastructures_pub.party_account_tbl;
13379:
13380: l_error_message varchar2(2000);
13381:
13382: l_msg_count number;

Line 13401: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

13397: AND nvl(msi.comms_nl_trackable_flag, 'N') = 'Y';
13398:
13399: BEGIN
13400:
13401: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
13402: csi_gen_utility_pvt.populate_install_param_rec;
13403: END IF;
13404: --
13405: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;

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

13401: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
13402: csi_gen_utility_pvt.populate_install_param_rec;
13403: END IF;
13404: --
13405: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
13406: --
13407: l_txn_rec.transaction_id := fnd_api.g_miss_num;
13408: l_txn_rec.transaction_type_id := correction_txn_type_id;
13409: l_txn_rec.source_header_ref := 'DATAFIX';

Line 13657: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

13653: csi_t_gen_utility_pvt.build_file_name(
13654: p_file_segment1 => 'csinonsy',
13655: p_file_segment2 => to_char(sysdate, 'hh24miss'));
13656: --
13657: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
13658: csi_gen_utility_pvt.populate_install_param_rec;
13659: END IF;
13660: --
13661: v_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;

Line 13661: v_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;

13657: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
13658: csi_gen_utility_pvt.populate_install_param_rec;
13659: END IF;
13660: --
13661: v_freeze_date := csi_datastructures_pub.g_install_param_rec.freeze_date;
13662: --
13663: -- Get the Transaction Type ID for Txn Type MIGRATED
13664: Begin
13665: select transaction_type_id

Line 13696: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

13692: v_err_msg := 'Error in getting the Status ID in CSI for Latest Status';
13693: Raise comp_error;
13694: End;
13695: -- Get the Internal Party ID
13696: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
13697: csi_gen_utility_pvt.populate_install_param_rec;
13698: END IF;
13699: --
13700: v_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;

Line 13700: v_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;

13696: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
13697: csi_gen_utility_pvt.populate_install_param_rec;
13698: END IF;
13699: --
13700: v_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
13701: --
13702: if v_party_id is null then
13703: v_err_msg := 'Internal Party ID not found in CSI_INSTALL_PARAMETERS';
13704: Raise comp_error;

Line 14902: p_instance_tbl csi_datastructures_pub.instance_tbl;

14898: AND a.inv_organization_id = c.organization_id
14899: AND a.serial_number is null
14900: AND c.serial_number_control_code IN (1,6);
14901:
14902: p_instance_tbl csi_datastructures_pub.instance_tbl;
14903: l_count NUMBER;
14904: m NUMBER;
14905: temp_quantity NUMBER;
14906: l_status_id NUMBER;

Line 15125: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

15121:
15122: out(l_message);
15123:
15124: --
15125: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
15126: csi_gen_utility_pvt.populate_install_param_rec;
15127: END IF;
15128: --
15129: l_ownership_override := csi_datastructures_pub.g_install_param_rec.ownership_override_at_txn;

Line 15129: l_ownership_override := csi_datastructures_pub.g_install_param_rec.ownership_override_at_txn;

15125: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
15126: csi_gen_utility_pvt.populate_install_param_rec;
15127: END IF;
15128: --
15129: l_ownership_override := csi_datastructures_pub.g_install_param_rec.ownership_override_at_txn;
15130: --
15131: FOR csi_rec IN csi_error
15132: LOOP
15133:

Line 15450: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

15446: FROM csi_txn_sub_types
15447: WHERE transaction_type_id = 53
15448: AND default_flag = 'Y';
15449:
15450: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
15451: csi_gen_utility_pvt.populate_install_param_rec;
15452: END IF;
15453: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
15454:

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

15449:
15450: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
15451: csi_gen_utility_pvt.populate_install_param_rec;
15452: END IF;
15453: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
15454:
15455: --Changed to use the BULK COLLECT for cursor for bug5248037--
15456: OPEN rma_cur;
15457: LOOP

Line 16485: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

16481: log(date_time_stamp||'start ib_sync ');
16482: log(' parameter - Show Instances :'||p_show_instances);
16483: log(' parameter - Mode of execution :'||p_mode);
16484: --
16485: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
16486: csi_gen_utility_pvt.populate_install_param_rec;
16487: END IF;
16488: --
16489: IF csi_datastructures_pub.g_install_param_rec.fetch_flag = 'N' OR

Line 16489: IF csi_datastructures_pub.g_install_param_rec.fetch_flag = 'N' OR

16485: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
16486: csi_gen_utility_pvt.populate_install_param_rec;
16487: END IF;
16488: --
16489: IF csi_datastructures_pub.g_install_param_rec.fetch_flag = 'N' OR
16490: csi_datastructures_pub.g_install_param_rec.freeze_flag = 'N' THEN
16491: log('Install Parameters no set. Process terminating...');
16492: errbuf := 'CSI Install Parameters not set...';
16493: retcode := 1;

Line 16490: csi_datastructures_pub.g_install_param_rec.freeze_flag = 'N' THEN

16486: csi_gen_utility_pvt.populate_install_param_rec;
16487: END IF;
16488: --
16489: IF csi_datastructures_pub.g_install_param_rec.fetch_flag = 'N' OR
16490: csi_datastructures_pub.g_install_param_rec.freeze_flag = 'N' THEN
16491: log('Install Parameters no set. Process terminating...');
16492: errbuf := 'CSI Install Parameters not set...';
16493: retcode := 1;
16494: RAISE comp_error;