APPS.CSP_SHIP_TO_ADDRESS_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 661: s_site_use_id hz_cust_site_uses_all.site_use_id%TYPE := NULL;

657: l_language VARCHAR2(4);
658: EXCP_USER_DEFINED EXCEPTION;
659:
660: s_location_id hr_locations.location_id%TYPE := p_location_id;
661: s_site_use_id hz_cust_site_uses_all.site_use_id%TYPE := NULL;
662: b_site_use_id hz_cust_site_uses_all.site_use_id%TYPE := NULL;
663: s_primary_flag hz_cust_site_uses_all.primary_flag%TYPE := NULL;
664: s_status hz_cust_site_uses_all.status%TYPE := NULL;
665:

Line 662: b_site_use_id hz_cust_site_uses_all.site_use_id%TYPE := NULL;

658: EXCP_USER_DEFINED EXCEPTION;
659:
660: s_location_id hr_locations.location_id%TYPE := p_location_id;
661: s_site_use_id hz_cust_site_uses_all.site_use_id%TYPE := NULL;
662: b_site_use_id hz_cust_site_uses_all.site_use_id%TYPE := NULL;
663: s_primary_flag hz_cust_site_uses_all.primary_flag%TYPE := NULL;
664: s_status hz_cust_site_uses_all.status%TYPE := NULL;
665:
666: CURSOR l_primary_party_site_use_csr IS

Line 663: s_primary_flag hz_cust_site_uses_all.primary_flag%TYPE := NULL;

659:
660: s_location_id hr_locations.location_id%TYPE := p_location_id;
661: s_site_use_id hz_cust_site_uses_all.site_use_id%TYPE := NULL;
662: b_site_use_id hz_cust_site_uses_all.site_use_id%TYPE := NULL;
663: s_primary_flag hz_cust_site_uses_all.primary_flag%TYPE := NULL;
664: s_status hz_cust_site_uses_all.status%TYPE := NULL;
665:
666: CURSOR l_primary_party_site_use_csr IS
667: select primary_per_type

Line 664: s_status hz_cust_site_uses_all.status%TYPE := NULL;

660: s_location_id hr_locations.location_id%TYPE := p_location_id;
661: s_site_use_id hz_cust_site_uses_all.site_use_id%TYPE := NULL;
662: b_site_use_id hz_cust_site_uses_all.site_use_id%TYPE := NULL;
663: s_primary_flag hz_cust_site_uses_all.primary_flag%TYPE := NULL;
664: s_status hz_cust_site_uses_all.status%TYPE := NULL;
665:
666: CURSOR l_primary_party_site_use_csr IS
667: select primary_per_type
668: from hz_party_site_uses

Line 1012: l_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;

1008: l_api_name CONSTANT VARCHAR2(30) := 'do_update_site_use';
1009: l_language VARCHAR2(4);
1010: EXCP_USER_DEFINED EXCEPTION;
1011:
1012: l_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;
1013: s_cust_acct_site_id hz_cust_site_uses_all.cust_acct_site_id%TYPE;
1014: s_creation_date hz_cust_site_uses_all.creation_date%TYPE;
1015: s_created_by hz_cust_site_uses_all.created_by%TYPE;
1016: s_site_use_code hz_cust_site_uses_all.site_use_code%TYPE;

Line 1013: s_cust_acct_site_id hz_cust_site_uses_all.cust_acct_site_id%TYPE;

1009: l_language VARCHAR2(4);
1010: EXCP_USER_DEFINED EXCEPTION;
1011:
1012: l_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;
1013: s_cust_acct_site_id hz_cust_site_uses_all.cust_acct_site_id%TYPE;
1014: s_creation_date hz_cust_site_uses_all.creation_date%TYPE;
1015: s_created_by hz_cust_site_uses_all.created_by%TYPE;
1016: s_site_use_code hz_cust_site_uses_all.site_use_code%TYPE;
1017: s_primary_flag hz_cust_site_uses_all.primary_flag%TYPE;

Line 1014: s_creation_date hz_cust_site_uses_all.creation_date%TYPE;

1010: EXCP_USER_DEFINED EXCEPTION;
1011:
1012: l_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;
1013: s_cust_acct_site_id hz_cust_site_uses_all.cust_acct_site_id%TYPE;
1014: s_creation_date hz_cust_site_uses_all.creation_date%TYPE;
1015: s_created_by hz_cust_site_uses_all.created_by%TYPE;
1016: s_site_use_code hz_cust_site_uses_all.site_use_code%TYPE;
1017: s_primary_flag hz_cust_site_uses_all.primary_flag%TYPE;
1018: s_status hz_cust_site_uses_all.status%TYPE;

Line 1015: s_created_by hz_cust_site_uses_all.created_by%TYPE;

1011:
1012: l_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;
1013: s_cust_acct_site_id hz_cust_site_uses_all.cust_acct_site_id%TYPE;
1014: s_creation_date hz_cust_site_uses_all.creation_date%TYPE;
1015: s_created_by hz_cust_site_uses_all.created_by%TYPE;
1016: s_site_use_code hz_cust_site_uses_all.site_use_code%TYPE;
1017: s_primary_flag hz_cust_site_uses_all.primary_flag%TYPE;
1018: s_status hz_cust_site_uses_all.status%TYPE;
1019: s_location hz_cust_site_uses_all.location%TYPE;

Line 1016: s_site_use_code hz_cust_site_uses_all.site_use_code%TYPE;

1012: l_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;
1013: s_cust_acct_site_id hz_cust_site_uses_all.cust_acct_site_id%TYPE;
1014: s_creation_date hz_cust_site_uses_all.creation_date%TYPE;
1015: s_created_by hz_cust_site_uses_all.created_by%TYPE;
1016: s_site_use_code hz_cust_site_uses_all.site_use_code%TYPE;
1017: s_primary_flag hz_cust_site_uses_all.primary_flag%TYPE;
1018: s_status hz_cust_site_uses_all.status%TYPE;
1019: s_location hz_cust_site_uses_all.location%TYPE;
1020: s_last_update_login hz_cust_site_uses_all.last_update_login%TYPE;

Line 1017: s_primary_flag hz_cust_site_uses_all.primary_flag%TYPE;

1013: s_cust_acct_site_id hz_cust_site_uses_all.cust_acct_site_id%TYPE;
1014: s_creation_date hz_cust_site_uses_all.creation_date%TYPE;
1015: s_created_by hz_cust_site_uses_all.created_by%TYPE;
1016: s_site_use_code hz_cust_site_uses_all.site_use_code%TYPE;
1017: s_primary_flag hz_cust_site_uses_all.primary_flag%TYPE;
1018: s_status hz_cust_site_uses_all.status%TYPE;
1019: s_location hz_cust_site_uses_all.location%TYPE;
1020: s_last_update_login hz_cust_site_uses_all.last_update_login%TYPE;
1021: s_contact_id hz_cust_site_uses_all.contact_id%TYPE;

Line 1018: s_status hz_cust_site_uses_all.status%TYPE;

1014: s_creation_date hz_cust_site_uses_all.creation_date%TYPE;
1015: s_created_by hz_cust_site_uses_all.created_by%TYPE;
1016: s_site_use_code hz_cust_site_uses_all.site_use_code%TYPE;
1017: s_primary_flag hz_cust_site_uses_all.primary_flag%TYPE;
1018: s_status hz_cust_site_uses_all.status%TYPE;
1019: s_location hz_cust_site_uses_all.location%TYPE;
1020: s_last_update_login hz_cust_site_uses_all.last_update_login%TYPE;
1021: s_contact_id hz_cust_site_uses_all.contact_id%TYPE;
1022: s_bill_to_site_use_id hz_cust_site_uses_all.bill_to_site_use_id%TYPE;

Line 1019: s_location hz_cust_site_uses_all.location%TYPE;

1015: s_created_by hz_cust_site_uses_all.created_by%TYPE;
1016: s_site_use_code hz_cust_site_uses_all.site_use_code%TYPE;
1017: s_primary_flag hz_cust_site_uses_all.primary_flag%TYPE;
1018: s_status hz_cust_site_uses_all.status%TYPE;
1019: s_location hz_cust_site_uses_all.location%TYPE;
1020: s_last_update_login hz_cust_site_uses_all.last_update_login%TYPE;
1021: s_contact_id hz_cust_site_uses_all.contact_id%TYPE;
1022: s_bill_to_site_use_id hz_cust_site_uses_all.bill_to_site_use_id%TYPE;
1023: s_orig_system_reference hz_cust_site_uses_all.orig_system_reference%TYPE;

Line 1020: s_last_update_login hz_cust_site_uses_all.last_update_login%TYPE;

1016: s_site_use_code hz_cust_site_uses_all.site_use_code%TYPE;
1017: s_primary_flag hz_cust_site_uses_all.primary_flag%TYPE;
1018: s_status hz_cust_site_uses_all.status%TYPE;
1019: s_location hz_cust_site_uses_all.location%TYPE;
1020: s_last_update_login hz_cust_site_uses_all.last_update_login%TYPE;
1021: s_contact_id hz_cust_site_uses_all.contact_id%TYPE;
1022: s_bill_to_site_use_id hz_cust_site_uses_all.bill_to_site_use_id%TYPE;
1023: s_orig_system_reference hz_cust_site_uses_all.orig_system_reference%TYPE;
1024: s_sic_code hz_cust_site_uses_all.sic_code%TYPE;

Line 1021: s_contact_id hz_cust_site_uses_all.contact_id%TYPE;

1017: s_primary_flag hz_cust_site_uses_all.primary_flag%TYPE;
1018: s_status hz_cust_site_uses_all.status%TYPE;
1019: s_location hz_cust_site_uses_all.location%TYPE;
1020: s_last_update_login hz_cust_site_uses_all.last_update_login%TYPE;
1021: s_contact_id hz_cust_site_uses_all.contact_id%TYPE;
1022: s_bill_to_site_use_id hz_cust_site_uses_all.bill_to_site_use_id%TYPE;
1023: s_orig_system_reference hz_cust_site_uses_all.orig_system_reference%TYPE;
1024: s_sic_code hz_cust_site_uses_all.sic_code%TYPE;
1025: s_payment_term_id hz_cust_site_uses_all.payment_term_id%TYPE;

Line 1022: s_bill_to_site_use_id hz_cust_site_uses_all.bill_to_site_use_id%TYPE;

1018: s_status hz_cust_site_uses_all.status%TYPE;
1019: s_location hz_cust_site_uses_all.location%TYPE;
1020: s_last_update_login hz_cust_site_uses_all.last_update_login%TYPE;
1021: s_contact_id hz_cust_site_uses_all.contact_id%TYPE;
1022: s_bill_to_site_use_id hz_cust_site_uses_all.bill_to_site_use_id%TYPE;
1023: s_orig_system_reference hz_cust_site_uses_all.orig_system_reference%TYPE;
1024: s_sic_code hz_cust_site_uses_all.sic_code%TYPE;
1025: s_payment_term_id hz_cust_site_uses_all.payment_term_id%TYPE;
1026: s_gsa_indicator hz_cust_site_uses_all.gsa_indicator%TYPE;

Line 1023: s_orig_system_reference hz_cust_site_uses_all.orig_system_reference%TYPE;

1019: s_location hz_cust_site_uses_all.location%TYPE;
1020: s_last_update_login hz_cust_site_uses_all.last_update_login%TYPE;
1021: s_contact_id hz_cust_site_uses_all.contact_id%TYPE;
1022: s_bill_to_site_use_id hz_cust_site_uses_all.bill_to_site_use_id%TYPE;
1023: s_orig_system_reference hz_cust_site_uses_all.orig_system_reference%TYPE;
1024: s_sic_code hz_cust_site_uses_all.sic_code%TYPE;
1025: s_payment_term_id hz_cust_site_uses_all.payment_term_id%TYPE;
1026: s_gsa_indicator hz_cust_site_uses_all.gsa_indicator%TYPE;
1027: s_ship_partial hz_cust_site_uses_all.ship_partial%TYPE;

Line 1024: s_sic_code hz_cust_site_uses_all.sic_code%TYPE;

1020: s_last_update_login hz_cust_site_uses_all.last_update_login%TYPE;
1021: s_contact_id hz_cust_site_uses_all.contact_id%TYPE;
1022: s_bill_to_site_use_id hz_cust_site_uses_all.bill_to_site_use_id%TYPE;
1023: s_orig_system_reference hz_cust_site_uses_all.orig_system_reference%TYPE;
1024: s_sic_code hz_cust_site_uses_all.sic_code%TYPE;
1025: s_payment_term_id hz_cust_site_uses_all.payment_term_id%TYPE;
1026: s_gsa_indicator hz_cust_site_uses_all.gsa_indicator%TYPE;
1027: s_ship_partial hz_cust_site_uses_all.ship_partial%TYPE;
1028: s_ship_via hz_cust_site_uses_all.ship_via%TYPE;

Line 1025: s_payment_term_id hz_cust_site_uses_all.payment_term_id%TYPE;

1021: s_contact_id hz_cust_site_uses_all.contact_id%TYPE;
1022: s_bill_to_site_use_id hz_cust_site_uses_all.bill_to_site_use_id%TYPE;
1023: s_orig_system_reference hz_cust_site_uses_all.orig_system_reference%TYPE;
1024: s_sic_code hz_cust_site_uses_all.sic_code%TYPE;
1025: s_payment_term_id hz_cust_site_uses_all.payment_term_id%TYPE;
1026: s_gsa_indicator hz_cust_site_uses_all.gsa_indicator%TYPE;
1027: s_ship_partial hz_cust_site_uses_all.ship_partial%TYPE;
1028: s_ship_via hz_cust_site_uses_all.ship_via%TYPE;
1029: s_fob_point hz_cust_site_uses_all.fob_point%TYPE;

Line 1026: s_gsa_indicator hz_cust_site_uses_all.gsa_indicator%TYPE;

1022: s_bill_to_site_use_id hz_cust_site_uses_all.bill_to_site_use_id%TYPE;
1023: s_orig_system_reference hz_cust_site_uses_all.orig_system_reference%TYPE;
1024: s_sic_code hz_cust_site_uses_all.sic_code%TYPE;
1025: s_payment_term_id hz_cust_site_uses_all.payment_term_id%TYPE;
1026: s_gsa_indicator hz_cust_site_uses_all.gsa_indicator%TYPE;
1027: s_ship_partial hz_cust_site_uses_all.ship_partial%TYPE;
1028: s_ship_via hz_cust_site_uses_all.ship_via%TYPE;
1029: s_fob_point hz_cust_site_uses_all.fob_point%TYPE;
1030: s_order_type_id hz_cust_site_uses_all.order_type_id%TYPE;

Line 1027: s_ship_partial hz_cust_site_uses_all.ship_partial%TYPE;

1023: s_orig_system_reference hz_cust_site_uses_all.orig_system_reference%TYPE;
1024: s_sic_code hz_cust_site_uses_all.sic_code%TYPE;
1025: s_payment_term_id hz_cust_site_uses_all.payment_term_id%TYPE;
1026: s_gsa_indicator hz_cust_site_uses_all.gsa_indicator%TYPE;
1027: s_ship_partial hz_cust_site_uses_all.ship_partial%TYPE;
1028: s_ship_via hz_cust_site_uses_all.ship_via%TYPE;
1029: s_fob_point hz_cust_site_uses_all.fob_point%TYPE;
1030: s_order_type_id hz_cust_site_uses_all.order_type_id%TYPE;
1031: s_price_list_id hz_cust_site_uses_all.price_list_id%TYPE;

Line 1028: s_ship_via hz_cust_site_uses_all.ship_via%TYPE;

1024: s_sic_code hz_cust_site_uses_all.sic_code%TYPE;
1025: s_payment_term_id hz_cust_site_uses_all.payment_term_id%TYPE;
1026: s_gsa_indicator hz_cust_site_uses_all.gsa_indicator%TYPE;
1027: s_ship_partial hz_cust_site_uses_all.ship_partial%TYPE;
1028: s_ship_via hz_cust_site_uses_all.ship_via%TYPE;
1029: s_fob_point hz_cust_site_uses_all.fob_point%TYPE;
1030: s_order_type_id hz_cust_site_uses_all.order_type_id%TYPE;
1031: s_price_list_id hz_cust_site_uses_all.price_list_id%TYPE;
1032: s_freight_term hz_cust_site_uses_all.freight_term%TYPE;

Line 1029: s_fob_point hz_cust_site_uses_all.fob_point%TYPE;

1025: s_payment_term_id hz_cust_site_uses_all.payment_term_id%TYPE;
1026: s_gsa_indicator hz_cust_site_uses_all.gsa_indicator%TYPE;
1027: s_ship_partial hz_cust_site_uses_all.ship_partial%TYPE;
1028: s_ship_via hz_cust_site_uses_all.ship_via%TYPE;
1029: s_fob_point hz_cust_site_uses_all.fob_point%TYPE;
1030: s_order_type_id hz_cust_site_uses_all.order_type_id%TYPE;
1031: s_price_list_id hz_cust_site_uses_all.price_list_id%TYPE;
1032: s_freight_term hz_cust_site_uses_all.freight_term%TYPE;
1033: s_warehouse_id hz_cust_site_uses_all.warehouse_id%TYPE;

Line 1030: s_order_type_id hz_cust_site_uses_all.order_type_id%TYPE;

1026: s_gsa_indicator hz_cust_site_uses_all.gsa_indicator%TYPE;
1027: s_ship_partial hz_cust_site_uses_all.ship_partial%TYPE;
1028: s_ship_via hz_cust_site_uses_all.ship_via%TYPE;
1029: s_fob_point hz_cust_site_uses_all.fob_point%TYPE;
1030: s_order_type_id hz_cust_site_uses_all.order_type_id%TYPE;
1031: s_price_list_id hz_cust_site_uses_all.price_list_id%TYPE;
1032: s_freight_term hz_cust_site_uses_all.freight_term%TYPE;
1033: s_warehouse_id hz_cust_site_uses_all.warehouse_id%TYPE;
1034: s_territory_id hz_cust_site_uses_all.territory_id%TYPE;

Line 1031: s_price_list_id hz_cust_site_uses_all.price_list_id%TYPE;

1027: s_ship_partial hz_cust_site_uses_all.ship_partial%TYPE;
1028: s_ship_via hz_cust_site_uses_all.ship_via%TYPE;
1029: s_fob_point hz_cust_site_uses_all.fob_point%TYPE;
1030: s_order_type_id hz_cust_site_uses_all.order_type_id%TYPE;
1031: s_price_list_id hz_cust_site_uses_all.price_list_id%TYPE;
1032: s_freight_term hz_cust_site_uses_all.freight_term%TYPE;
1033: s_warehouse_id hz_cust_site_uses_all.warehouse_id%TYPE;
1034: s_territory_id hz_cust_site_uses_all.territory_id%TYPE;
1035: s_attribute_category hz_cust_site_uses_all.attribute_category%TYPE;

Line 1032: s_freight_term hz_cust_site_uses_all.freight_term%TYPE;

1028: s_ship_via hz_cust_site_uses_all.ship_via%TYPE;
1029: s_fob_point hz_cust_site_uses_all.fob_point%TYPE;
1030: s_order_type_id hz_cust_site_uses_all.order_type_id%TYPE;
1031: s_price_list_id hz_cust_site_uses_all.price_list_id%TYPE;
1032: s_freight_term hz_cust_site_uses_all.freight_term%TYPE;
1033: s_warehouse_id hz_cust_site_uses_all.warehouse_id%TYPE;
1034: s_territory_id hz_cust_site_uses_all.territory_id%TYPE;
1035: s_attribute_category hz_cust_site_uses_all.attribute_category%TYPE;
1036: s_attribute1 hz_cust_site_uses_all.attribute1%TYPE;

Line 1033: s_warehouse_id hz_cust_site_uses_all.warehouse_id%TYPE;

1029: s_fob_point hz_cust_site_uses_all.fob_point%TYPE;
1030: s_order_type_id hz_cust_site_uses_all.order_type_id%TYPE;
1031: s_price_list_id hz_cust_site_uses_all.price_list_id%TYPE;
1032: s_freight_term hz_cust_site_uses_all.freight_term%TYPE;
1033: s_warehouse_id hz_cust_site_uses_all.warehouse_id%TYPE;
1034: s_territory_id hz_cust_site_uses_all.territory_id%TYPE;
1035: s_attribute_category hz_cust_site_uses_all.attribute_category%TYPE;
1036: s_attribute1 hz_cust_site_uses_all.attribute1%TYPE;
1037: s_attribute2 hz_cust_site_uses_all.attribute2%TYPE;

Line 1034: s_territory_id hz_cust_site_uses_all.territory_id%TYPE;

1030: s_order_type_id hz_cust_site_uses_all.order_type_id%TYPE;
1031: s_price_list_id hz_cust_site_uses_all.price_list_id%TYPE;
1032: s_freight_term hz_cust_site_uses_all.freight_term%TYPE;
1033: s_warehouse_id hz_cust_site_uses_all.warehouse_id%TYPE;
1034: s_territory_id hz_cust_site_uses_all.territory_id%TYPE;
1035: s_attribute_category hz_cust_site_uses_all.attribute_category%TYPE;
1036: s_attribute1 hz_cust_site_uses_all.attribute1%TYPE;
1037: s_attribute2 hz_cust_site_uses_all.attribute2%TYPE;
1038: s_attribute3 hz_cust_site_uses_all.attribute3%TYPE;

Line 1035: s_attribute_category hz_cust_site_uses_all.attribute_category%TYPE;

1031: s_price_list_id hz_cust_site_uses_all.price_list_id%TYPE;
1032: s_freight_term hz_cust_site_uses_all.freight_term%TYPE;
1033: s_warehouse_id hz_cust_site_uses_all.warehouse_id%TYPE;
1034: s_territory_id hz_cust_site_uses_all.territory_id%TYPE;
1035: s_attribute_category hz_cust_site_uses_all.attribute_category%TYPE;
1036: s_attribute1 hz_cust_site_uses_all.attribute1%TYPE;
1037: s_attribute2 hz_cust_site_uses_all.attribute2%TYPE;
1038: s_attribute3 hz_cust_site_uses_all.attribute3%TYPE;
1039: s_attribute4 hz_cust_site_uses_all.attribute4%TYPE;

Line 1036: s_attribute1 hz_cust_site_uses_all.attribute1%TYPE;

1032: s_freight_term hz_cust_site_uses_all.freight_term%TYPE;
1033: s_warehouse_id hz_cust_site_uses_all.warehouse_id%TYPE;
1034: s_territory_id hz_cust_site_uses_all.territory_id%TYPE;
1035: s_attribute_category hz_cust_site_uses_all.attribute_category%TYPE;
1036: s_attribute1 hz_cust_site_uses_all.attribute1%TYPE;
1037: s_attribute2 hz_cust_site_uses_all.attribute2%TYPE;
1038: s_attribute3 hz_cust_site_uses_all.attribute3%TYPE;
1039: s_attribute4 hz_cust_site_uses_all.attribute4%TYPE;
1040: s_attribute5 hz_cust_site_uses_all.attribute5%TYPE;

Line 1037: s_attribute2 hz_cust_site_uses_all.attribute2%TYPE;

1033: s_warehouse_id hz_cust_site_uses_all.warehouse_id%TYPE;
1034: s_territory_id hz_cust_site_uses_all.territory_id%TYPE;
1035: s_attribute_category hz_cust_site_uses_all.attribute_category%TYPE;
1036: s_attribute1 hz_cust_site_uses_all.attribute1%TYPE;
1037: s_attribute2 hz_cust_site_uses_all.attribute2%TYPE;
1038: s_attribute3 hz_cust_site_uses_all.attribute3%TYPE;
1039: s_attribute4 hz_cust_site_uses_all.attribute4%TYPE;
1040: s_attribute5 hz_cust_site_uses_all.attribute5%TYPE;
1041: s_attribute6 hz_cust_site_uses_all.attribute6%TYPE;

Line 1038: s_attribute3 hz_cust_site_uses_all.attribute3%TYPE;

1034: s_territory_id hz_cust_site_uses_all.territory_id%TYPE;
1035: s_attribute_category hz_cust_site_uses_all.attribute_category%TYPE;
1036: s_attribute1 hz_cust_site_uses_all.attribute1%TYPE;
1037: s_attribute2 hz_cust_site_uses_all.attribute2%TYPE;
1038: s_attribute3 hz_cust_site_uses_all.attribute3%TYPE;
1039: s_attribute4 hz_cust_site_uses_all.attribute4%TYPE;
1040: s_attribute5 hz_cust_site_uses_all.attribute5%TYPE;
1041: s_attribute6 hz_cust_site_uses_all.attribute6%TYPE;
1042: s_attribute7 hz_cust_site_uses_all.attribute7%TYPE;

Line 1039: s_attribute4 hz_cust_site_uses_all.attribute4%TYPE;

1035: s_attribute_category hz_cust_site_uses_all.attribute_category%TYPE;
1036: s_attribute1 hz_cust_site_uses_all.attribute1%TYPE;
1037: s_attribute2 hz_cust_site_uses_all.attribute2%TYPE;
1038: s_attribute3 hz_cust_site_uses_all.attribute3%TYPE;
1039: s_attribute4 hz_cust_site_uses_all.attribute4%TYPE;
1040: s_attribute5 hz_cust_site_uses_all.attribute5%TYPE;
1041: s_attribute6 hz_cust_site_uses_all.attribute6%TYPE;
1042: s_attribute7 hz_cust_site_uses_all.attribute7%TYPE;
1043: s_attribute8 hz_cust_site_uses_all.attribute8%TYPE;

Line 1040: s_attribute5 hz_cust_site_uses_all.attribute5%TYPE;

1036: s_attribute1 hz_cust_site_uses_all.attribute1%TYPE;
1037: s_attribute2 hz_cust_site_uses_all.attribute2%TYPE;
1038: s_attribute3 hz_cust_site_uses_all.attribute3%TYPE;
1039: s_attribute4 hz_cust_site_uses_all.attribute4%TYPE;
1040: s_attribute5 hz_cust_site_uses_all.attribute5%TYPE;
1041: s_attribute6 hz_cust_site_uses_all.attribute6%TYPE;
1042: s_attribute7 hz_cust_site_uses_all.attribute7%TYPE;
1043: s_attribute8 hz_cust_site_uses_all.attribute8%TYPE;
1044: s_attribute9 hz_cust_site_uses_all.attribute9%TYPE;

Line 1041: s_attribute6 hz_cust_site_uses_all.attribute6%TYPE;

1037: s_attribute2 hz_cust_site_uses_all.attribute2%TYPE;
1038: s_attribute3 hz_cust_site_uses_all.attribute3%TYPE;
1039: s_attribute4 hz_cust_site_uses_all.attribute4%TYPE;
1040: s_attribute5 hz_cust_site_uses_all.attribute5%TYPE;
1041: s_attribute6 hz_cust_site_uses_all.attribute6%TYPE;
1042: s_attribute7 hz_cust_site_uses_all.attribute7%TYPE;
1043: s_attribute8 hz_cust_site_uses_all.attribute8%TYPE;
1044: s_attribute9 hz_cust_site_uses_all.attribute9%TYPE;
1045: s_attribute10 hz_cust_site_uses_all.attribute10%TYPE;

Line 1042: s_attribute7 hz_cust_site_uses_all.attribute7%TYPE;

1038: s_attribute3 hz_cust_site_uses_all.attribute3%TYPE;
1039: s_attribute4 hz_cust_site_uses_all.attribute4%TYPE;
1040: s_attribute5 hz_cust_site_uses_all.attribute5%TYPE;
1041: s_attribute6 hz_cust_site_uses_all.attribute6%TYPE;
1042: s_attribute7 hz_cust_site_uses_all.attribute7%TYPE;
1043: s_attribute8 hz_cust_site_uses_all.attribute8%TYPE;
1044: s_attribute9 hz_cust_site_uses_all.attribute9%TYPE;
1045: s_attribute10 hz_cust_site_uses_all.attribute10%TYPE;
1046: s_request_id hz_cust_site_uses_all.request_id%TYPE;

Line 1043: s_attribute8 hz_cust_site_uses_all.attribute8%TYPE;

1039: s_attribute4 hz_cust_site_uses_all.attribute4%TYPE;
1040: s_attribute5 hz_cust_site_uses_all.attribute5%TYPE;
1041: s_attribute6 hz_cust_site_uses_all.attribute6%TYPE;
1042: s_attribute7 hz_cust_site_uses_all.attribute7%TYPE;
1043: s_attribute8 hz_cust_site_uses_all.attribute8%TYPE;
1044: s_attribute9 hz_cust_site_uses_all.attribute9%TYPE;
1045: s_attribute10 hz_cust_site_uses_all.attribute10%TYPE;
1046: s_request_id hz_cust_site_uses_all.request_id%TYPE;
1047: s_program_application_id hz_cust_site_uses_all.program_application_id%TYPE;

Line 1044: s_attribute9 hz_cust_site_uses_all.attribute9%TYPE;

1040: s_attribute5 hz_cust_site_uses_all.attribute5%TYPE;
1041: s_attribute6 hz_cust_site_uses_all.attribute6%TYPE;
1042: s_attribute7 hz_cust_site_uses_all.attribute7%TYPE;
1043: s_attribute8 hz_cust_site_uses_all.attribute8%TYPE;
1044: s_attribute9 hz_cust_site_uses_all.attribute9%TYPE;
1045: s_attribute10 hz_cust_site_uses_all.attribute10%TYPE;
1046: s_request_id hz_cust_site_uses_all.request_id%TYPE;
1047: s_program_application_id hz_cust_site_uses_all.program_application_id%TYPE;
1048: s_program_id hz_cust_site_uses_all.program_id%TYPE;

Line 1045: s_attribute10 hz_cust_site_uses_all.attribute10%TYPE;

1041: s_attribute6 hz_cust_site_uses_all.attribute6%TYPE;
1042: s_attribute7 hz_cust_site_uses_all.attribute7%TYPE;
1043: s_attribute8 hz_cust_site_uses_all.attribute8%TYPE;
1044: s_attribute9 hz_cust_site_uses_all.attribute9%TYPE;
1045: s_attribute10 hz_cust_site_uses_all.attribute10%TYPE;
1046: s_request_id hz_cust_site_uses_all.request_id%TYPE;
1047: s_program_application_id hz_cust_site_uses_all.program_application_id%TYPE;
1048: s_program_id hz_cust_site_uses_all.program_id%TYPE;
1049: s_program_update_date hz_cust_site_uses_all.program_update_date%TYPE;

Line 1046: s_request_id hz_cust_site_uses_all.request_id%TYPE;

1042: s_attribute7 hz_cust_site_uses_all.attribute7%TYPE;
1043: s_attribute8 hz_cust_site_uses_all.attribute8%TYPE;
1044: s_attribute9 hz_cust_site_uses_all.attribute9%TYPE;
1045: s_attribute10 hz_cust_site_uses_all.attribute10%TYPE;
1046: s_request_id hz_cust_site_uses_all.request_id%TYPE;
1047: s_program_application_id hz_cust_site_uses_all.program_application_id%TYPE;
1048: s_program_id hz_cust_site_uses_all.program_id%TYPE;
1049: s_program_update_date hz_cust_site_uses_all.program_update_date%TYPE;
1050: s_tax_reference hz_cust_site_uses_all.tax_reference%TYPE;

Line 1047: s_program_application_id hz_cust_site_uses_all.program_application_id%TYPE;

1043: s_attribute8 hz_cust_site_uses_all.attribute8%TYPE;
1044: s_attribute9 hz_cust_site_uses_all.attribute9%TYPE;
1045: s_attribute10 hz_cust_site_uses_all.attribute10%TYPE;
1046: s_request_id hz_cust_site_uses_all.request_id%TYPE;
1047: s_program_application_id hz_cust_site_uses_all.program_application_id%TYPE;
1048: s_program_id hz_cust_site_uses_all.program_id%TYPE;
1049: s_program_update_date hz_cust_site_uses_all.program_update_date%TYPE;
1050: s_tax_reference hz_cust_site_uses_all.tax_reference%TYPE;
1051: s_sort_priority hz_cust_site_uses_all.sort_priority%TYPE;

Line 1048: s_program_id hz_cust_site_uses_all.program_id%TYPE;

1044: s_attribute9 hz_cust_site_uses_all.attribute9%TYPE;
1045: s_attribute10 hz_cust_site_uses_all.attribute10%TYPE;
1046: s_request_id hz_cust_site_uses_all.request_id%TYPE;
1047: s_program_application_id hz_cust_site_uses_all.program_application_id%TYPE;
1048: s_program_id hz_cust_site_uses_all.program_id%TYPE;
1049: s_program_update_date hz_cust_site_uses_all.program_update_date%TYPE;
1050: s_tax_reference hz_cust_site_uses_all.tax_reference%TYPE;
1051: s_sort_priority hz_cust_site_uses_all.sort_priority%TYPE;
1052: s_tax_code hz_cust_site_uses_all.tax_code%TYPE;

Line 1049: s_program_update_date hz_cust_site_uses_all.program_update_date%TYPE;

1045: s_attribute10 hz_cust_site_uses_all.attribute10%TYPE;
1046: s_request_id hz_cust_site_uses_all.request_id%TYPE;
1047: s_program_application_id hz_cust_site_uses_all.program_application_id%TYPE;
1048: s_program_id hz_cust_site_uses_all.program_id%TYPE;
1049: s_program_update_date hz_cust_site_uses_all.program_update_date%TYPE;
1050: s_tax_reference hz_cust_site_uses_all.tax_reference%TYPE;
1051: s_sort_priority hz_cust_site_uses_all.sort_priority%TYPE;
1052: s_tax_code hz_cust_site_uses_all.tax_code%TYPE;
1053: s_attribute11 hz_cust_site_uses_all.attribute11%TYPE;

Line 1050: s_tax_reference hz_cust_site_uses_all.tax_reference%TYPE;

1046: s_request_id hz_cust_site_uses_all.request_id%TYPE;
1047: s_program_application_id hz_cust_site_uses_all.program_application_id%TYPE;
1048: s_program_id hz_cust_site_uses_all.program_id%TYPE;
1049: s_program_update_date hz_cust_site_uses_all.program_update_date%TYPE;
1050: s_tax_reference hz_cust_site_uses_all.tax_reference%TYPE;
1051: s_sort_priority hz_cust_site_uses_all.sort_priority%TYPE;
1052: s_tax_code hz_cust_site_uses_all.tax_code%TYPE;
1053: s_attribute11 hz_cust_site_uses_all.attribute11%TYPE;
1054: s_attribute12 hz_cust_site_uses_all.attribute12%TYPE;

Line 1051: s_sort_priority hz_cust_site_uses_all.sort_priority%TYPE;

1047: s_program_application_id hz_cust_site_uses_all.program_application_id%TYPE;
1048: s_program_id hz_cust_site_uses_all.program_id%TYPE;
1049: s_program_update_date hz_cust_site_uses_all.program_update_date%TYPE;
1050: s_tax_reference hz_cust_site_uses_all.tax_reference%TYPE;
1051: s_sort_priority hz_cust_site_uses_all.sort_priority%TYPE;
1052: s_tax_code hz_cust_site_uses_all.tax_code%TYPE;
1053: s_attribute11 hz_cust_site_uses_all.attribute11%TYPE;
1054: s_attribute12 hz_cust_site_uses_all.attribute12%TYPE;
1055: s_attribute13 hz_cust_site_uses_all.attribute13%TYPE;

Line 1052: s_tax_code hz_cust_site_uses_all.tax_code%TYPE;

1048: s_program_id hz_cust_site_uses_all.program_id%TYPE;
1049: s_program_update_date hz_cust_site_uses_all.program_update_date%TYPE;
1050: s_tax_reference hz_cust_site_uses_all.tax_reference%TYPE;
1051: s_sort_priority hz_cust_site_uses_all.sort_priority%TYPE;
1052: s_tax_code hz_cust_site_uses_all.tax_code%TYPE;
1053: s_attribute11 hz_cust_site_uses_all.attribute11%TYPE;
1054: s_attribute12 hz_cust_site_uses_all.attribute12%TYPE;
1055: s_attribute13 hz_cust_site_uses_all.attribute13%TYPE;
1056: s_attribute14 hz_cust_site_uses_all.attribute14%TYPE;

Line 1053: s_attribute11 hz_cust_site_uses_all.attribute11%TYPE;

1049: s_program_update_date hz_cust_site_uses_all.program_update_date%TYPE;
1050: s_tax_reference hz_cust_site_uses_all.tax_reference%TYPE;
1051: s_sort_priority hz_cust_site_uses_all.sort_priority%TYPE;
1052: s_tax_code hz_cust_site_uses_all.tax_code%TYPE;
1053: s_attribute11 hz_cust_site_uses_all.attribute11%TYPE;
1054: s_attribute12 hz_cust_site_uses_all.attribute12%TYPE;
1055: s_attribute13 hz_cust_site_uses_all.attribute13%TYPE;
1056: s_attribute14 hz_cust_site_uses_all.attribute14%TYPE;
1057: s_attribute15 hz_cust_site_uses_all.attribute15%TYPE;

Line 1054: s_attribute12 hz_cust_site_uses_all.attribute12%TYPE;

1050: s_tax_reference hz_cust_site_uses_all.tax_reference%TYPE;
1051: s_sort_priority hz_cust_site_uses_all.sort_priority%TYPE;
1052: s_tax_code hz_cust_site_uses_all.tax_code%TYPE;
1053: s_attribute11 hz_cust_site_uses_all.attribute11%TYPE;
1054: s_attribute12 hz_cust_site_uses_all.attribute12%TYPE;
1055: s_attribute13 hz_cust_site_uses_all.attribute13%TYPE;
1056: s_attribute14 hz_cust_site_uses_all.attribute14%TYPE;
1057: s_attribute15 hz_cust_site_uses_all.attribute15%TYPE;
1058: s_attribute16 hz_cust_site_uses_all.attribute16%TYPE;

Line 1055: s_attribute13 hz_cust_site_uses_all.attribute13%TYPE;

1051: s_sort_priority hz_cust_site_uses_all.sort_priority%TYPE;
1052: s_tax_code hz_cust_site_uses_all.tax_code%TYPE;
1053: s_attribute11 hz_cust_site_uses_all.attribute11%TYPE;
1054: s_attribute12 hz_cust_site_uses_all.attribute12%TYPE;
1055: s_attribute13 hz_cust_site_uses_all.attribute13%TYPE;
1056: s_attribute14 hz_cust_site_uses_all.attribute14%TYPE;
1057: s_attribute15 hz_cust_site_uses_all.attribute15%TYPE;
1058: s_attribute16 hz_cust_site_uses_all.attribute16%TYPE;
1059: s_attribute17 hz_cust_site_uses_all.attribute17%TYPE;

Line 1056: s_attribute14 hz_cust_site_uses_all.attribute14%TYPE;

1052: s_tax_code hz_cust_site_uses_all.tax_code%TYPE;
1053: s_attribute11 hz_cust_site_uses_all.attribute11%TYPE;
1054: s_attribute12 hz_cust_site_uses_all.attribute12%TYPE;
1055: s_attribute13 hz_cust_site_uses_all.attribute13%TYPE;
1056: s_attribute14 hz_cust_site_uses_all.attribute14%TYPE;
1057: s_attribute15 hz_cust_site_uses_all.attribute15%TYPE;
1058: s_attribute16 hz_cust_site_uses_all.attribute16%TYPE;
1059: s_attribute17 hz_cust_site_uses_all.attribute17%TYPE;
1060: s_attribute18 hz_cust_site_uses_all.attribute18%TYPE;

Line 1057: s_attribute15 hz_cust_site_uses_all.attribute15%TYPE;

1053: s_attribute11 hz_cust_site_uses_all.attribute11%TYPE;
1054: s_attribute12 hz_cust_site_uses_all.attribute12%TYPE;
1055: s_attribute13 hz_cust_site_uses_all.attribute13%TYPE;
1056: s_attribute14 hz_cust_site_uses_all.attribute14%TYPE;
1057: s_attribute15 hz_cust_site_uses_all.attribute15%TYPE;
1058: s_attribute16 hz_cust_site_uses_all.attribute16%TYPE;
1059: s_attribute17 hz_cust_site_uses_all.attribute17%TYPE;
1060: s_attribute18 hz_cust_site_uses_all.attribute18%TYPE;
1061: s_attribute19 hz_cust_site_uses_all.attribute19%TYPE;

Line 1058: s_attribute16 hz_cust_site_uses_all.attribute16%TYPE;

1054: s_attribute12 hz_cust_site_uses_all.attribute12%TYPE;
1055: s_attribute13 hz_cust_site_uses_all.attribute13%TYPE;
1056: s_attribute14 hz_cust_site_uses_all.attribute14%TYPE;
1057: s_attribute15 hz_cust_site_uses_all.attribute15%TYPE;
1058: s_attribute16 hz_cust_site_uses_all.attribute16%TYPE;
1059: s_attribute17 hz_cust_site_uses_all.attribute17%TYPE;
1060: s_attribute18 hz_cust_site_uses_all.attribute18%TYPE;
1061: s_attribute19 hz_cust_site_uses_all.attribute19%TYPE;
1062: s_attribute20 hz_cust_site_uses_all.attribute20%TYPE;

Line 1059: s_attribute17 hz_cust_site_uses_all.attribute17%TYPE;

1055: s_attribute13 hz_cust_site_uses_all.attribute13%TYPE;
1056: s_attribute14 hz_cust_site_uses_all.attribute14%TYPE;
1057: s_attribute15 hz_cust_site_uses_all.attribute15%TYPE;
1058: s_attribute16 hz_cust_site_uses_all.attribute16%TYPE;
1059: s_attribute17 hz_cust_site_uses_all.attribute17%TYPE;
1060: s_attribute18 hz_cust_site_uses_all.attribute18%TYPE;
1061: s_attribute19 hz_cust_site_uses_all.attribute19%TYPE;
1062: s_attribute20 hz_cust_site_uses_all.attribute20%TYPE;
1063: s_attribute21 hz_cust_site_uses_all.attribute21%TYPE;

Line 1060: s_attribute18 hz_cust_site_uses_all.attribute18%TYPE;

1056: s_attribute14 hz_cust_site_uses_all.attribute14%TYPE;
1057: s_attribute15 hz_cust_site_uses_all.attribute15%TYPE;
1058: s_attribute16 hz_cust_site_uses_all.attribute16%TYPE;
1059: s_attribute17 hz_cust_site_uses_all.attribute17%TYPE;
1060: s_attribute18 hz_cust_site_uses_all.attribute18%TYPE;
1061: s_attribute19 hz_cust_site_uses_all.attribute19%TYPE;
1062: s_attribute20 hz_cust_site_uses_all.attribute20%TYPE;
1063: s_attribute21 hz_cust_site_uses_all.attribute21%TYPE;
1064: s_attribute22 hz_cust_site_uses_all.attribute22%TYPE;

Line 1061: s_attribute19 hz_cust_site_uses_all.attribute19%TYPE;

1057: s_attribute15 hz_cust_site_uses_all.attribute15%TYPE;
1058: s_attribute16 hz_cust_site_uses_all.attribute16%TYPE;
1059: s_attribute17 hz_cust_site_uses_all.attribute17%TYPE;
1060: s_attribute18 hz_cust_site_uses_all.attribute18%TYPE;
1061: s_attribute19 hz_cust_site_uses_all.attribute19%TYPE;
1062: s_attribute20 hz_cust_site_uses_all.attribute20%TYPE;
1063: s_attribute21 hz_cust_site_uses_all.attribute21%TYPE;
1064: s_attribute22 hz_cust_site_uses_all.attribute22%TYPE;
1065: s_attribute23 hz_cust_site_uses_all.attribute23%TYPE;

Line 1062: s_attribute20 hz_cust_site_uses_all.attribute20%TYPE;

1058: s_attribute16 hz_cust_site_uses_all.attribute16%TYPE;
1059: s_attribute17 hz_cust_site_uses_all.attribute17%TYPE;
1060: s_attribute18 hz_cust_site_uses_all.attribute18%TYPE;
1061: s_attribute19 hz_cust_site_uses_all.attribute19%TYPE;
1062: s_attribute20 hz_cust_site_uses_all.attribute20%TYPE;
1063: s_attribute21 hz_cust_site_uses_all.attribute21%TYPE;
1064: s_attribute22 hz_cust_site_uses_all.attribute22%TYPE;
1065: s_attribute23 hz_cust_site_uses_all.attribute23%TYPE;
1066: s_attribute24 hz_cust_site_uses_all.attribute24%TYPE;

Line 1063: s_attribute21 hz_cust_site_uses_all.attribute21%TYPE;

1059: s_attribute17 hz_cust_site_uses_all.attribute17%TYPE;
1060: s_attribute18 hz_cust_site_uses_all.attribute18%TYPE;
1061: s_attribute19 hz_cust_site_uses_all.attribute19%TYPE;
1062: s_attribute20 hz_cust_site_uses_all.attribute20%TYPE;
1063: s_attribute21 hz_cust_site_uses_all.attribute21%TYPE;
1064: s_attribute22 hz_cust_site_uses_all.attribute22%TYPE;
1065: s_attribute23 hz_cust_site_uses_all.attribute23%TYPE;
1066: s_attribute24 hz_cust_site_uses_all.attribute24%TYPE;
1067: s_attribute25 hz_cust_site_uses_all.attribute25%TYPE;

Line 1064: s_attribute22 hz_cust_site_uses_all.attribute22%TYPE;

1060: s_attribute18 hz_cust_site_uses_all.attribute18%TYPE;
1061: s_attribute19 hz_cust_site_uses_all.attribute19%TYPE;
1062: s_attribute20 hz_cust_site_uses_all.attribute20%TYPE;
1063: s_attribute21 hz_cust_site_uses_all.attribute21%TYPE;
1064: s_attribute22 hz_cust_site_uses_all.attribute22%TYPE;
1065: s_attribute23 hz_cust_site_uses_all.attribute23%TYPE;
1066: s_attribute24 hz_cust_site_uses_all.attribute24%TYPE;
1067: s_attribute25 hz_cust_site_uses_all.attribute25%TYPE;
1068: s_last_accrue_charge_date DATE;

Line 1065: s_attribute23 hz_cust_site_uses_all.attribute23%TYPE;

1061: s_attribute19 hz_cust_site_uses_all.attribute19%TYPE;
1062: s_attribute20 hz_cust_site_uses_all.attribute20%TYPE;
1063: s_attribute21 hz_cust_site_uses_all.attribute21%TYPE;
1064: s_attribute22 hz_cust_site_uses_all.attribute22%TYPE;
1065: s_attribute23 hz_cust_site_uses_all.attribute23%TYPE;
1066: s_attribute24 hz_cust_site_uses_all.attribute24%TYPE;
1067: s_attribute25 hz_cust_site_uses_all.attribute25%TYPE;
1068: s_last_accrue_charge_date DATE;
1069: s_snd_last_accrue_charge_date DATE;

Line 1066: s_attribute24 hz_cust_site_uses_all.attribute24%TYPE;

1062: s_attribute20 hz_cust_site_uses_all.attribute20%TYPE;
1063: s_attribute21 hz_cust_site_uses_all.attribute21%TYPE;
1064: s_attribute22 hz_cust_site_uses_all.attribute22%TYPE;
1065: s_attribute23 hz_cust_site_uses_all.attribute23%TYPE;
1066: s_attribute24 hz_cust_site_uses_all.attribute24%TYPE;
1067: s_attribute25 hz_cust_site_uses_all.attribute25%TYPE;
1068: s_last_accrue_charge_date DATE;
1069: s_snd_last_accrue_charge_date DATE;
1070: s_last_unaccrue_charge_date DATE;

Line 1067: s_attribute25 hz_cust_site_uses_all.attribute25%TYPE;

1063: s_attribute21 hz_cust_site_uses_all.attribute21%TYPE;
1064: s_attribute22 hz_cust_site_uses_all.attribute22%TYPE;
1065: s_attribute23 hz_cust_site_uses_all.attribute23%TYPE;
1066: s_attribute24 hz_cust_site_uses_all.attribute24%TYPE;
1067: s_attribute25 hz_cust_site_uses_all.attribute25%TYPE;
1068: s_last_accrue_charge_date DATE;
1069: s_snd_last_accrue_charge_date DATE;
1070: s_last_unaccrue_charge_date DATE;
1071: s_snd_last_unaccrue_chrg_date DATE;

Line 1072: s_demand_class_code hz_cust_site_uses_all.demand_class_code%TYPE;

1068: s_last_accrue_charge_date DATE;
1069: s_snd_last_accrue_charge_date DATE;
1070: s_last_unaccrue_charge_date DATE;
1071: s_snd_last_unaccrue_chrg_date DATE;
1072: s_demand_class_code hz_cust_site_uses_all.demand_class_code%TYPE;
1073: s_org_id hz_cust_site_uses_all.org_id%TYPE;
1074: s_tax_header_level_flag hz_cust_site_uses_all.tax_header_level_flag%TYPE;
1075: s_tax_rounding_rule hz_cust_site_uses_all.tax_rounding_rule%TYPE;
1076: s_wh_update_date hz_cust_site_uses_all.wh_update_date%TYPE;

Line 1073: s_org_id hz_cust_site_uses_all.org_id%TYPE;

1069: s_snd_last_accrue_charge_date DATE;
1070: s_last_unaccrue_charge_date DATE;
1071: s_snd_last_unaccrue_chrg_date DATE;
1072: s_demand_class_code hz_cust_site_uses_all.demand_class_code%TYPE;
1073: s_org_id hz_cust_site_uses_all.org_id%TYPE;
1074: s_tax_header_level_flag hz_cust_site_uses_all.tax_header_level_flag%TYPE;
1075: s_tax_rounding_rule hz_cust_site_uses_all.tax_rounding_rule%TYPE;
1076: s_wh_update_date hz_cust_site_uses_all.wh_update_date%TYPE;
1077: s_global_attribute1 hz_cust_site_uses_all.global_attribute1%TYPE;

Line 1074: s_tax_header_level_flag hz_cust_site_uses_all.tax_header_level_flag%TYPE;

1070: s_last_unaccrue_charge_date DATE;
1071: s_snd_last_unaccrue_chrg_date DATE;
1072: s_demand_class_code hz_cust_site_uses_all.demand_class_code%TYPE;
1073: s_org_id hz_cust_site_uses_all.org_id%TYPE;
1074: s_tax_header_level_flag hz_cust_site_uses_all.tax_header_level_flag%TYPE;
1075: s_tax_rounding_rule hz_cust_site_uses_all.tax_rounding_rule%TYPE;
1076: s_wh_update_date hz_cust_site_uses_all.wh_update_date%TYPE;
1077: s_global_attribute1 hz_cust_site_uses_all.global_attribute1%TYPE;
1078: s_global_attribute2 hz_cust_site_uses_all.global_attribute2%TYPE;

Line 1075: s_tax_rounding_rule hz_cust_site_uses_all.tax_rounding_rule%TYPE;

1071: s_snd_last_unaccrue_chrg_date DATE;
1072: s_demand_class_code hz_cust_site_uses_all.demand_class_code%TYPE;
1073: s_org_id hz_cust_site_uses_all.org_id%TYPE;
1074: s_tax_header_level_flag hz_cust_site_uses_all.tax_header_level_flag%TYPE;
1075: s_tax_rounding_rule hz_cust_site_uses_all.tax_rounding_rule%TYPE;
1076: s_wh_update_date hz_cust_site_uses_all.wh_update_date%TYPE;
1077: s_global_attribute1 hz_cust_site_uses_all.global_attribute1%TYPE;
1078: s_global_attribute2 hz_cust_site_uses_all.global_attribute2%TYPE;
1079: s_global_attribute3 hz_cust_site_uses_all.global_attribute3%TYPE;

Line 1076: s_wh_update_date hz_cust_site_uses_all.wh_update_date%TYPE;

1072: s_demand_class_code hz_cust_site_uses_all.demand_class_code%TYPE;
1073: s_org_id hz_cust_site_uses_all.org_id%TYPE;
1074: s_tax_header_level_flag hz_cust_site_uses_all.tax_header_level_flag%TYPE;
1075: s_tax_rounding_rule hz_cust_site_uses_all.tax_rounding_rule%TYPE;
1076: s_wh_update_date hz_cust_site_uses_all.wh_update_date%TYPE;
1077: s_global_attribute1 hz_cust_site_uses_all.global_attribute1%TYPE;
1078: s_global_attribute2 hz_cust_site_uses_all.global_attribute2%TYPE;
1079: s_global_attribute3 hz_cust_site_uses_all.global_attribute3%TYPE;
1080: s_global_attribute4 hz_cust_site_uses_all.global_attribute4%TYPE;

Line 1077: s_global_attribute1 hz_cust_site_uses_all.global_attribute1%TYPE;

1073: s_org_id hz_cust_site_uses_all.org_id%TYPE;
1074: s_tax_header_level_flag hz_cust_site_uses_all.tax_header_level_flag%TYPE;
1075: s_tax_rounding_rule hz_cust_site_uses_all.tax_rounding_rule%TYPE;
1076: s_wh_update_date hz_cust_site_uses_all.wh_update_date%TYPE;
1077: s_global_attribute1 hz_cust_site_uses_all.global_attribute1%TYPE;
1078: s_global_attribute2 hz_cust_site_uses_all.global_attribute2%TYPE;
1079: s_global_attribute3 hz_cust_site_uses_all.global_attribute3%TYPE;
1080: s_global_attribute4 hz_cust_site_uses_all.global_attribute4%TYPE;
1081: s_global_attribute5 hz_cust_site_uses_all.global_attribute5%TYPE;

Line 1078: s_global_attribute2 hz_cust_site_uses_all.global_attribute2%TYPE;

1074: s_tax_header_level_flag hz_cust_site_uses_all.tax_header_level_flag%TYPE;
1075: s_tax_rounding_rule hz_cust_site_uses_all.tax_rounding_rule%TYPE;
1076: s_wh_update_date hz_cust_site_uses_all.wh_update_date%TYPE;
1077: s_global_attribute1 hz_cust_site_uses_all.global_attribute1%TYPE;
1078: s_global_attribute2 hz_cust_site_uses_all.global_attribute2%TYPE;
1079: s_global_attribute3 hz_cust_site_uses_all.global_attribute3%TYPE;
1080: s_global_attribute4 hz_cust_site_uses_all.global_attribute4%TYPE;
1081: s_global_attribute5 hz_cust_site_uses_all.global_attribute5%TYPE;
1082: s_global_attribute6 hz_cust_site_uses_all.global_attribute6%TYPE;

Line 1079: s_global_attribute3 hz_cust_site_uses_all.global_attribute3%TYPE;

1075: s_tax_rounding_rule hz_cust_site_uses_all.tax_rounding_rule%TYPE;
1076: s_wh_update_date hz_cust_site_uses_all.wh_update_date%TYPE;
1077: s_global_attribute1 hz_cust_site_uses_all.global_attribute1%TYPE;
1078: s_global_attribute2 hz_cust_site_uses_all.global_attribute2%TYPE;
1079: s_global_attribute3 hz_cust_site_uses_all.global_attribute3%TYPE;
1080: s_global_attribute4 hz_cust_site_uses_all.global_attribute4%TYPE;
1081: s_global_attribute5 hz_cust_site_uses_all.global_attribute5%TYPE;
1082: s_global_attribute6 hz_cust_site_uses_all.global_attribute6%TYPE;
1083: s_global_attribute7 hz_cust_site_uses_all.global_attribute7%TYPE;

Line 1080: s_global_attribute4 hz_cust_site_uses_all.global_attribute4%TYPE;

1076: s_wh_update_date hz_cust_site_uses_all.wh_update_date%TYPE;
1077: s_global_attribute1 hz_cust_site_uses_all.global_attribute1%TYPE;
1078: s_global_attribute2 hz_cust_site_uses_all.global_attribute2%TYPE;
1079: s_global_attribute3 hz_cust_site_uses_all.global_attribute3%TYPE;
1080: s_global_attribute4 hz_cust_site_uses_all.global_attribute4%TYPE;
1081: s_global_attribute5 hz_cust_site_uses_all.global_attribute5%TYPE;
1082: s_global_attribute6 hz_cust_site_uses_all.global_attribute6%TYPE;
1083: s_global_attribute7 hz_cust_site_uses_all.global_attribute7%TYPE;
1084: s_global_attribute8 hz_cust_site_uses_all.global_attribute8%TYPE;

Line 1081: s_global_attribute5 hz_cust_site_uses_all.global_attribute5%TYPE;

1077: s_global_attribute1 hz_cust_site_uses_all.global_attribute1%TYPE;
1078: s_global_attribute2 hz_cust_site_uses_all.global_attribute2%TYPE;
1079: s_global_attribute3 hz_cust_site_uses_all.global_attribute3%TYPE;
1080: s_global_attribute4 hz_cust_site_uses_all.global_attribute4%TYPE;
1081: s_global_attribute5 hz_cust_site_uses_all.global_attribute5%TYPE;
1082: s_global_attribute6 hz_cust_site_uses_all.global_attribute6%TYPE;
1083: s_global_attribute7 hz_cust_site_uses_all.global_attribute7%TYPE;
1084: s_global_attribute8 hz_cust_site_uses_all.global_attribute8%TYPE;
1085: s_global_attribute9 hz_cust_site_uses_all.global_attribute9%TYPE;

Line 1082: s_global_attribute6 hz_cust_site_uses_all.global_attribute6%TYPE;

1078: s_global_attribute2 hz_cust_site_uses_all.global_attribute2%TYPE;
1079: s_global_attribute3 hz_cust_site_uses_all.global_attribute3%TYPE;
1080: s_global_attribute4 hz_cust_site_uses_all.global_attribute4%TYPE;
1081: s_global_attribute5 hz_cust_site_uses_all.global_attribute5%TYPE;
1082: s_global_attribute6 hz_cust_site_uses_all.global_attribute6%TYPE;
1083: s_global_attribute7 hz_cust_site_uses_all.global_attribute7%TYPE;
1084: s_global_attribute8 hz_cust_site_uses_all.global_attribute8%TYPE;
1085: s_global_attribute9 hz_cust_site_uses_all.global_attribute9%TYPE;
1086: s_global_attribute10 hz_cust_site_uses_all.global_attribute10%TYPE;

Line 1083: s_global_attribute7 hz_cust_site_uses_all.global_attribute7%TYPE;

1079: s_global_attribute3 hz_cust_site_uses_all.global_attribute3%TYPE;
1080: s_global_attribute4 hz_cust_site_uses_all.global_attribute4%TYPE;
1081: s_global_attribute5 hz_cust_site_uses_all.global_attribute5%TYPE;
1082: s_global_attribute6 hz_cust_site_uses_all.global_attribute6%TYPE;
1083: s_global_attribute7 hz_cust_site_uses_all.global_attribute7%TYPE;
1084: s_global_attribute8 hz_cust_site_uses_all.global_attribute8%TYPE;
1085: s_global_attribute9 hz_cust_site_uses_all.global_attribute9%TYPE;
1086: s_global_attribute10 hz_cust_site_uses_all.global_attribute10%TYPE;
1087: s_global_attribute11 hz_cust_site_uses_all.global_attribute11%TYPE;

Line 1084: s_global_attribute8 hz_cust_site_uses_all.global_attribute8%TYPE;

1080: s_global_attribute4 hz_cust_site_uses_all.global_attribute4%TYPE;
1081: s_global_attribute5 hz_cust_site_uses_all.global_attribute5%TYPE;
1082: s_global_attribute6 hz_cust_site_uses_all.global_attribute6%TYPE;
1083: s_global_attribute7 hz_cust_site_uses_all.global_attribute7%TYPE;
1084: s_global_attribute8 hz_cust_site_uses_all.global_attribute8%TYPE;
1085: s_global_attribute9 hz_cust_site_uses_all.global_attribute9%TYPE;
1086: s_global_attribute10 hz_cust_site_uses_all.global_attribute10%TYPE;
1087: s_global_attribute11 hz_cust_site_uses_all.global_attribute11%TYPE;
1088: s_global_attribute12 hz_cust_site_uses_all.global_attribute12%TYPE;

Line 1085: s_global_attribute9 hz_cust_site_uses_all.global_attribute9%TYPE;

1081: s_global_attribute5 hz_cust_site_uses_all.global_attribute5%TYPE;
1082: s_global_attribute6 hz_cust_site_uses_all.global_attribute6%TYPE;
1083: s_global_attribute7 hz_cust_site_uses_all.global_attribute7%TYPE;
1084: s_global_attribute8 hz_cust_site_uses_all.global_attribute8%TYPE;
1085: s_global_attribute9 hz_cust_site_uses_all.global_attribute9%TYPE;
1086: s_global_attribute10 hz_cust_site_uses_all.global_attribute10%TYPE;
1087: s_global_attribute11 hz_cust_site_uses_all.global_attribute11%TYPE;
1088: s_global_attribute12 hz_cust_site_uses_all.global_attribute12%TYPE;
1089: s_global_attribute13 hz_cust_site_uses_all.global_attribute13%TYPE;

Line 1086: s_global_attribute10 hz_cust_site_uses_all.global_attribute10%TYPE;

1082: s_global_attribute6 hz_cust_site_uses_all.global_attribute6%TYPE;
1083: s_global_attribute7 hz_cust_site_uses_all.global_attribute7%TYPE;
1084: s_global_attribute8 hz_cust_site_uses_all.global_attribute8%TYPE;
1085: s_global_attribute9 hz_cust_site_uses_all.global_attribute9%TYPE;
1086: s_global_attribute10 hz_cust_site_uses_all.global_attribute10%TYPE;
1087: s_global_attribute11 hz_cust_site_uses_all.global_attribute11%TYPE;
1088: s_global_attribute12 hz_cust_site_uses_all.global_attribute12%TYPE;
1089: s_global_attribute13 hz_cust_site_uses_all.global_attribute13%TYPE;
1090: s_global_attribute14 hz_cust_site_uses_all.global_attribute14%TYPE;

Line 1087: s_global_attribute11 hz_cust_site_uses_all.global_attribute11%TYPE;

1083: s_global_attribute7 hz_cust_site_uses_all.global_attribute7%TYPE;
1084: s_global_attribute8 hz_cust_site_uses_all.global_attribute8%TYPE;
1085: s_global_attribute9 hz_cust_site_uses_all.global_attribute9%TYPE;
1086: s_global_attribute10 hz_cust_site_uses_all.global_attribute10%TYPE;
1087: s_global_attribute11 hz_cust_site_uses_all.global_attribute11%TYPE;
1088: s_global_attribute12 hz_cust_site_uses_all.global_attribute12%TYPE;
1089: s_global_attribute13 hz_cust_site_uses_all.global_attribute13%TYPE;
1090: s_global_attribute14 hz_cust_site_uses_all.global_attribute14%TYPE;
1091: s_global_attribute15 hz_cust_site_uses_all.global_attribute15%TYPE;

Line 1088: s_global_attribute12 hz_cust_site_uses_all.global_attribute12%TYPE;

1084: s_global_attribute8 hz_cust_site_uses_all.global_attribute8%TYPE;
1085: s_global_attribute9 hz_cust_site_uses_all.global_attribute9%TYPE;
1086: s_global_attribute10 hz_cust_site_uses_all.global_attribute10%TYPE;
1087: s_global_attribute11 hz_cust_site_uses_all.global_attribute11%TYPE;
1088: s_global_attribute12 hz_cust_site_uses_all.global_attribute12%TYPE;
1089: s_global_attribute13 hz_cust_site_uses_all.global_attribute13%TYPE;
1090: s_global_attribute14 hz_cust_site_uses_all.global_attribute14%TYPE;
1091: s_global_attribute15 hz_cust_site_uses_all.global_attribute15%TYPE;
1092: s_global_attribute16 hz_cust_site_uses_all.global_attribute16%TYPE;

Line 1089: s_global_attribute13 hz_cust_site_uses_all.global_attribute13%TYPE;

1085: s_global_attribute9 hz_cust_site_uses_all.global_attribute9%TYPE;
1086: s_global_attribute10 hz_cust_site_uses_all.global_attribute10%TYPE;
1087: s_global_attribute11 hz_cust_site_uses_all.global_attribute11%TYPE;
1088: s_global_attribute12 hz_cust_site_uses_all.global_attribute12%TYPE;
1089: s_global_attribute13 hz_cust_site_uses_all.global_attribute13%TYPE;
1090: s_global_attribute14 hz_cust_site_uses_all.global_attribute14%TYPE;
1091: s_global_attribute15 hz_cust_site_uses_all.global_attribute15%TYPE;
1092: s_global_attribute16 hz_cust_site_uses_all.global_attribute16%TYPE;
1093: s_global_attribute17 hz_cust_site_uses_all.global_attribute17%TYPE;

Line 1090: s_global_attribute14 hz_cust_site_uses_all.global_attribute14%TYPE;

1086: s_global_attribute10 hz_cust_site_uses_all.global_attribute10%TYPE;
1087: s_global_attribute11 hz_cust_site_uses_all.global_attribute11%TYPE;
1088: s_global_attribute12 hz_cust_site_uses_all.global_attribute12%TYPE;
1089: s_global_attribute13 hz_cust_site_uses_all.global_attribute13%TYPE;
1090: s_global_attribute14 hz_cust_site_uses_all.global_attribute14%TYPE;
1091: s_global_attribute15 hz_cust_site_uses_all.global_attribute15%TYPE;
1092: s_global_attribute16 hz_cust_site_uses_all.global_attribute16%TYPE;
1093: s_global_attribute17 hz_cust_site_uses_all.global_attribute17%TYPE;
1094: s_global_attribute18 hz_cust_site_uses_all.global_attribute18%TYPE;

Line 1091: s_global_attribute15 hz_cust_site_uses_all.global_attribute15%TYPE;

1087: s_global_attribute11 hz_cust_site_uses_all.global_attribute11%TYPE;
1088: s_global_attribute12 hz_cust_site_uses_all.global_attribute12%TYPE;
1089: s_global_attribute13 hz_cust_site_uses_all.global_attribute13%TYPE;
1090: s_global_attribute14 hz_cust_site_uses_all.global_attribute14%TYPE;
1091: s_global_attribute15 hz_cust_site_uses_all.global_attribute15%TYPE;
1092: s_global_attribute16 hz_cust_site_uses_all.global_attribute16%TYPE;
1093: s_global_attribute17 hz_cust_site_uses_all.global_attribute17%TYPE;
1094: s_global_attribute18 hz_cust_site_uses_all.global_attribute18%TYPE;
1095: s_global_attribute19 hz_cust_site_uses_all.global_attribute19%TYPE;

Line 1092: s_global_attribute16 hz_cust_site_uses_all.global_attribute16%TYPE;

1088: s_global_attribute12 hz_cust_site_uses_all.global_attribute12%TYPE;
1089: s_global_attribute13 hz_cust_site_uses_all.global_attribute13%TYPE;
1090: s_global_attribute14 hz_cust_site_uses_all.global_attribute14%TYPE;
1091: s_global_attribute15 hz_cust_site_uses_all.global_attribute15%TYPE;
1092: s_global_attribute16 hz_cust_site_uses_all.global_attribute16%TYPE;
1093: s_global_attribute17 hz_cust_site_uses_all.global_attribute17%TYPE;
1094: s_global_attribute18 hz_cust_site_uses_all.global_attribute18%TYPE;
1095: s_global_attribute19 hz_cust_site_uses_all.global_attribute19%TYPE;
1096: s_global_attribute20 hz_cust_site_uses_all.global_attribute20%TYPE;

Line 1093: s_global_attribute17 hz_cust_site_uses_all.global_attribute17%TYPE;

1089: s_global_attribute13 hz_cust_site_uses_all.global_attribute13%TYPE;
1090: s_global_attribute14 hz_cust_site_uses_all.global_attribute14%TYPE;
1091: s_global_attribute15 hz_cust_site_uses_all.global_attribute15%TYPE;
1092: s_global_attribute16 hz_cust_site_uses_all.global_attribute16%TYPE;
1093: s_global_attribute17 hz_cust_site_uses_all.global_attribute17%TYPE;
1094: s_global_attribute18 hz_cust_site_uses_all.global_attribute18%TYPE;
1095: s_global_attribute19 hz_cust_site_uses_all.global_attribute19%TYPE;
1096: s_global_attribute20 hz_cust_site_uses_all.global_attribute20%TYPE;
1097: s_global_attribute_category hz_cust_site_uses_all.global_attribute_category%TYPE;

Line 1094: s_global_attribute18 hz_cust_site_uses_all.global_attribute18%TYPE;

1090: s_global_attribute14 hz_cust_site_uses_all.global_attribute14%TYPE;
1091: s_global_attribute15 hz_cust_site_uses_all.global_attribute15%TYPE;
1092: s_global_attribute16 hz_cust_site_uses_all.global_attribute16%TYPE;
1093: s_global_attribute17 hz_cust_site_uses_all.global_attribute17%TYPE;
1094: s_global_attribute18 hz_cust_site_uses_all.global_attribute18%TYPE;
1095: s_global_attribute19 hz_cust_site_uses_all.global_attribute19%TYPE;
1096: s_global_attribute20 hz_cust_site_uses_all.global_attribute20%TYPE;
1097: s_global_attribute_category hz_cust_site_uses_all.global_attribute_category%TYPE;
1098: s_primary_salesrep_id hz_cust_site_uses_all.primary_salesrep_id%TYPE;

Line 1095: s_global_attribute19 hz_cust_site_uses_all.global_attribute19%TYPE;

1091: s_global_attribute15 hz_cust_site_uses_all.global_attribute15%TYPE;
1092: s_global_attribute16 hz_cust_site_uses_all.global_attribute16%TYPE;
1093: s_global_attribute17 hz_cust_site_uses_all.global_attribute17%TYPE;
1094: s_global_attribute18 hz_cust_site_uses_all.global_attribute18%TYPE;
1095: s_global_attribute19 hz_cust_site_uses_all.global_attribute19%TYPE;
1096: s_global_attribute20 hz_cust_site_uses_all.global_attribute20%TYPE;
1097: s_global_attribute_category hz_cust_site_uses_all.global_attribute_category%TYPE;
1098: s_primary_salesrep_id hz_cust_site_uses_all.primary_salesrep_id%TYPE;
1099: s_finchrg_receivables_trx_id hz_cust_site_uses_all.finchrg_receivables_trx_id%TYPE;

Line 1096: s_global_attribute20 hz_cust_site_uses_all.global_attribute20%TYPE;

1092: s_global_attribute16 hz_cust_site_uses_all.global_attribute16%TYPE;
1093: s_global_attribute17 hz_cust_site_uses_all.global_attribute17%TYPE;
1094: s_global_attribute18 hz_cust_site_uses_all.global_attribute18%TYPE;
1095: s_global_attribute19 hz_cust_site_uses_all.global_attribute19%TYPE;
1096: s_global_attribute20 hz_cust_site_uses_all.global_attribute20%TYPE;
1097: s_global_attribute_category hz_cust_site_uses_all.global_attribute_category%TYPE;
1098: s_primary_salesrep_id hz_cust_site_uses_all.primary_salesrep_id%TYPE;
1099: s_finchrg_receivables_trx_id hz_cust_site_uses_all.finchrg_receivables_trx_id%TYPE;
1100: s_dates_negative_tolerance hz_cust_site_uses_all.dates_negative_tolerance%TYPE;

Line 1097: s_global_attribute_category hz_cust_site_uses_all.global_attribute_category%TYPE;

1093: s_global_attribute17 hz_cust_site_uses_all.global_attribute17%TYPE;
1094: s_global_attribute18 hz_cust_site_uses_all.global_attribute18%TYPE;
1095: s_global_attribute19 hz_cust_site_uses_all.global_attribute19%TYPE;
1096: s_global_attribute20 hz_cust_site_uses_all.global_attribute20%TYPE;
1097: s_global_attribute_category hz_cust_site_uses_all.global_attribute_category%TYPE;
1098: s_primary_salesrep_id hz_cust_site_uses_all.primary_salesrep_id%TYPE;
1099: s_finchrg_receivables_trx_id hz_cust_site_uses_all.finchrg_receivables_trx_id%TYPE;
1100: s_dates_negative_tolerance hz_cust_site_uses_all.dates_negative_tolerance%TYPE;
1101: s_dates_positive_tolerance hz_cust_site_uses_all.dates_positive_tolerance%TYPE;

Line 1098: s_primary_salesrep_id hz_cust_site_uses_all.primary_salesrep_id%TYPE;

1094: s_global_attribute18 hz_cust_site_uses_all.global_attribute18%TYPE;
1095: s_global_attribute19 hz_cust_site_uses_all.global_attribute19%TYPE;
1096: s_global_attribute20 hz_cust_site_uses_all.global_attribute20%TYPE;
1097: s_global_attribute_category hz_cust_site_uses_all.global_attribute_category%TYPE;
1098: s_primary_salesrep_id hz_cust_site_uses_all.primary_salesrep_id%TYPE;
1099: s_finchrg_receivables_trx_id hz_cust_site_uses_all.finchrg_receivables_trx_id%TYPE;
1100: s_dates_negative_tolerance hz_cust_site_uses_all.dates_negative_tolerance%TYPE;
1101: s_dates_positive_tolerance hz_cust_site_uses_all.dates_positive_tolerance%TYPE;
1102: s_date_type_preference hz_cust_site_uses_all.date_type_preference%TYPE;

Line 1099: s_finchrg_receivables_trx_id hz_cust_site_uses_all.finchrg_receivables_trx_id%TYPE;

1095: s_global_attribute19 hz_cust_site_uses_all.global_attribute19%TYPE;
1096: s_global_attribute20 hz_cust_site_uses_all.global_attribute20%TYPE;
1097: s_global_attribute_category hz_cust_site_uses_all.global_attribute_category%TYPE;
1098: s_primary_salesrep_id hz_cust_site_uses_all.primary_salesrep_id%TYPE;
1099: s_finchrg_receivables_trx_id hz_cust_site_uses_all.finchrg_receivables_trx_id%TYPE;
1100: s_dates_negative_tolerance hz_cust_site_uses_all.dates_negative_tolerance%TYPE;
1101: s_dates_positive_tolerance hz_cust_site_uses_all.dates_positive_tolerance%TYPE;
1102: s_date_type_preference hz_cust_site_uses_all.date_type_preference%TYPE;
1103: s_over_shipment_tolerance hz_cust_site_uses_all.over_shipment_tolerance%TYPE;

Line 1100: s_dates_negative_tolerance hz_cust_site_uses_all.dates_negative_tolerance%TYPE;

1096: s_global_attribute20 hz_cust_site_uses_all.global_attribute20%TYPE;
1097: s_global_attribute_category hz_cust_site_uses_all.global_attribute_category%TYPE;
1098: s_primary_salesrep_id hz_cust_site_uses_all.primary_salesrep_id%TYPE;
1099: s_finchrg_receivables_trx_id hz_cust_site_uses_all.finchrg_receivables_trx_id%TYPE;
1100: s_dates_negative_tolerance hz_cust_site_uses_all.dates_negative_tolerance%TYPE;
1101: s_dates_positive_tolerance hz_cust_site_uses_all.dates_positive_tolerance%TYPE;
1102: s_date_type_preference hz_cust_site_uses_all.date_type_preference%TYPE;
1103: s_over_shipment_tolerance hz_cust_site_uses_all.over_shipment_tolerance%TYPE;
1104: s_under_shipment_tolerance hz_cust_site_uses_all.under_shipment_tolerance%TYPE;

Line 1101: s_dates_positive_tolerance hz_cust_site_uses_all.dates_positive_tolerance%TYPE;

1097: s_global_attribute_category hz_cust_site_uses_all.global_attribute_category%TYPE;
1098: s_primary_salesrep_id hz_cust_site_uses_all.primary_salesrep_id%TYPE;
1099: s_finchrg_receivables_trx_id hz_cust_site_uses_all.finchrg_receivables_trx_id%TYPE;
1100: s_dates_negative_tolerance hz_cust_site_uses_all.dates_negative_tolerance%TYPE;
1101: s_dates_positive_tolerance hz_cust_site_uses_all.dates_positive_tolerance%TYPE;
1102: s_date_type_preference hz_cust_site_uses_all.date_type_preference%TYPE;
1103: s_over_shipment_tolerance hz_cust_site_uses_all.over_shipment_tolerance%TYPE;
1104: s_under_shipment_tolerance hz_cust_site_uses_all.under_shipment_tolerance%TYPE;
1105: s_item_cross_ref_pref hz_cust_site_uses_all.item_cross_ref_pref%TYPE;

Line 1102: s_date_type_preference hz_cust_site_uses_all.date_type_preference%TYPE;

1098: s_primary_salesrep_id hz_cust_site_uses_all.primary_salesrep_id%TYPE;
1099: s_finchrg_receivables_trx_id hz_cust_site_uses_all.finchrg_receivables_trx_id%TYPE;
1100: s_dates_negative_tolerance hz_cust_site_uses_all.dates_negative_tolerance%TYPE;
1101: s_dates_positive_tolerance hz_cust_site_uses_all.dates_positive_tolerance%TYPE;
1102: s_date_type_preference hz_cust_site_uses_all.date_type_preference%TYPE;
1103: s_over_shipment_tolerance hz_cust_site_uses_all.over_shipment_tolerance%TYPE;
1104: s_under_shipment_tolerance hz_cust_site_uses_all.under_shipment_tolerance%TYPE;
1105: s_item_cross_ref_pref hz_cust_site_uses_all.item_cross_ref_pref%TYPE;
1106: s_over_return_tolerance hz_cust_site_uses_all.over_return_tolerance%TYPE;

Line 1103: s_over_shipment_tolerance hz_cust_site_uses_all.over_shipment_tolerance%TYPE;

1099: s_finchrg_receivables_trx_id hz_cust_site_uses_all.finchrg_receivables_trx_id%TYPE;
1100: s_dates_negative_tolerance hz_cust_site_uses_all.dates_negative_tolerance%TYPE;
1101: s_dates_positive_tolerance hz_cust_site_uses_all.dates_positive_tolerance%TYPE;
1102: s_date_type_preference hz_cust_site_uses_all.date_type_preference%TYPE;
1103: s_over_shipment_tolerance hz_cust_site_uses_all.over_shipment_tolerance%TYPE;
1104: s_under_shipment_tolerance hz_cust_site_uses_all.under_shipment_tolerance%TYPE;
1105: s_item_cross_ref_pref hz_cust_site_uses_all.item_cross_ref_pref%TYPE;
1106: s_over_return_tolerance hz_cust_site_uses_all.over_return_tolerance%TYPE;
1107: s_under_return_tolerance hz_cust_site_uses_all.under_return_tolerance%TYPE;

Line 1104: s_under_shipment_tolerance hz_cust_site_uses_all.under_shipment_tolerance%TYPE;

1100: s_dates_negative_tolerance hz_cust_site_uses_all.dates_negative_tolerance%TYPE;
1101: s_dates_positive_tolerance hz_cust_site_uses_all.dates_positive_tolerance%TYPE;
1102: s_date_type_preference hz_cust_site_uses_all.date_type_preference%TYPE;
1103: s_over_shipment_tolerance hz_cust_site_uses_all.over_shipment_tolerance%TYPE;
1104: s_under_shipment_tolerance hz_cust_site_uses_all.under_shipment_tolerance%TYPE;
1105: s_item_cross_ref_pref hz_cust_site_uses_all.item_cross_ref_pref%TYPE;
1106: s_over_return_tolerance hz_cust_site_uses_all.over_return_tolerance%TYPE;
1107: s_under_return_tolerance hz_cust_site_uses_all.under_return_tolerance%TYPE;
1108: s_ship_sets_include_lines_flag hz_cust_site_uses_all.ship_sets_include_lines_flag%TYPE;

Line 1105: s_item_cross_ref_pref hz_cust_site_uses_all.item_cross_ref_pref%TYPE;

1101: s_dates_positive_tolerance hz_cust_site_uses_all.dates_positive_tolerance%TYPE;
1102: s_date_type_preference hz_cust_site_uses_all.date_type_preference%TYPE;
1103: s_over_shipment_tolerance hz_cust_site_uses_all.over_shipment_tolerance%TYPE;
1104: s_under_shipment_tolerance hz_cust_site_uses_all.under_shipment_tolerance%TYPE;
1105: s_item_cross_ref_pref hz_cust_site_uses_all.item_cross_ref_pref%TYPE;
1106: s_over_return_tolerance hz_cust_site_uses_all.over_return_tolerance%TYPE;
1107: s_under_return_tolerance hz_cust_site_uses_all.under_return_tolerance%TYPE;
1108: s_ship_sets_include_lines_flag hz_cust_site_uses_all.ship_sets_include_lines_flag%TYPE;
1109: s_arv_include_lines_flag hz_cust_site_uses_all.arrivalsets_include_lines_flag%TYPE;

Line 1106: s_over_return_tolerance hz_cust_site_uses_all.over_return_tolerance%TYPE;

1102: s_date_type_preference hz_cust_site_uses_all.date_type_preference%TYPE;
1103: s_over_shipment_tolerance hz_cust_site_uses_all.over_shipment_tolerance%TYPE;
1104: s_under_shipment_tolerance hz_cust_site_uses_all.under_shipment_tolerance%TYPE;
1105: s_item_cross_ref_pref hz_cust_site_uses_all.item_cross_ref_pref%TYPE;
1106: s_over_return_tolerance hz_cust_site_uses_all.over_return_tolerance%TYPE;
1107: s_under_return_tolerance hz_cust_site_uses_all.under_return_tolerance%TYPE;
1108: s_ship_sets_include_lines_flag hz_cust_site_uses_all.ship_sets_include_lines_flag%TYPE;
1109: s_arv_include_lines_flag hz_cust_site_uses_all.arrivalsets_include_lines_flag%TYPE;
1110: s_sched_date_push_flag hz_cust_site_uses_all.sched_date_push_flag%TYPE;

Line 1107: s_under_return_tolerance hz_cust_site_uses_all.under_return_tolerance%TYPE;

1103: s_over_shipment_tolerance hz_cust_site_uses_all.over_shipment_tolerance%TYPE;
1104: s_under_shipment_tolerance hz_cust_site_uses_all.under_shipment_tolerance%TYPE;
1105: s_item_cross_ref_pref hz_cust_site_uses_all.item_cross_ref_pref%TYPE;
1106: s_over_return_tolerance hz_cust_site_uses_all.over_return_tolerance%TYPE;
1107: s_under_return_tolerance hz_cust_site_uses_all.under_return_tolerance%TYPE;
1108: s_ship_sets_include_lines_flag hz_cust_site_uses_all.ship_sets_include_lines_flag%TYPE;
1109: s_arv_include_lines_flag hz_cust_site_uses_all.arrivalsets_include_lines_flag%TYPE;
1110: s_sched_date_push_flag hz_cust_site_uses_all.sched_date_push_flag%TYPE;
1111: s_invoice_quantity_rule hz_cust_site_uses_all.invoice_quantity_rule%TYPE;

Line 1108: s_ship_sets_include_lines_flag hz_cust_site_uses_all.ship_sets_include_lines_flag%TYPE;

1104: s_under_shipment_tolerance hz_cust_site_uses_all.under_shipment_tolerance%TYPE;
1105: s_item_cross_ref_pref hz_cust_site_uses_all.item_cross_ref_pref%TYPE;
1106: s_over_return_tolerance hz_cust_site_uses_all.over_return_tolerance%TYPE;
1107: s_under_return_tolerance hz_cust_site_uses_all.under_return_tolerance%TYPE;
1108: s_ship_sets_include_lines_flag hz_cust_site_uses_all.ship_sets_include_lines_flag%TYPE;
1109: s_arv_include_lines_flag hz_cust_site_uses_all.arrivalsets_include_lines_flag%TYPE;
1110: s_sched_date_push_flag hz_cust_site_uses_all.sched_date_push_flag%TYPE;
1111: s_invoice_quantity_rule hz_cust_site_uses_all.invoice_quantity_rule%TYPE;
1112: s_pricing_event hz_cust_site_uses_all.pricing_event%TYPE;

Line 1109: s_arv_include_lines_flag hz_cust_site_uses_all.arrivalsets_include_lines_flag%TYPE;

1105: s_item_cross_ref_pref hz_cust_site_uses_all.item_cross_ref_pref%TYPE;
1106: s_over_return_tolerance hz_cust_site_uses_all.over_return_tolerance%TYPE;
1107: s_under_return_tolerance hz_cust_site_uses_all.under_return_tolerance%TYPE;
1108: s_ship_sets_include_lines_flag hz_cust_site_uses_all.ship_sets_include_lines_flag%TYPE;
1109: s_arv_include_lines_flag hz_cust_site_uses_all.arrivalsets_include_lines_flag%TYPE;
1110: s_sched_date_push_flag hz_cust_site_uses_all.sched_date_push_flag%TYPE;
1111: s_invoice_quantity_rule hz_cust_site_uses_all.invoice_quantity_rule%TYPE;
1112: s_pricing_event hz_cust_site_uses_all.pricing_event%TYPE;
1113: s_gl_id_rec hz_cust_site_uses_all.gl_id_rec%TYPE;

Line 1110: s_sched_date_push_flag hz_cust_site_uses_all.sched_date_push_flag%TYPE;

1106: s_over_return_tolerance hz_cust_site_uses_all.over_return_tolerance%TYPE;
1107: s_under_return_tolerance hz_cust_site_uses_all.under_return_tolerance%TYPE;
1108: s_ship_sets_include_lines_flag hz_cust_site_uses_all.ship_sets_include_lines_flag%TYPE;
1109: s_arv_include_lines_flag hz_cust_site_uses_all.arrivalsets_include_lines_flag%TYPE;
1110: s_sched_date_push_flag hz_cust_site_uses_all.sched_date_push_flag%TYPE;
1111: s_invoice_quantity_rule hz_cust_site_uses_all.invoice_quantity_rule%TYPE;
1112: s_pricing_event hz_cust_site_uses_all.pricing_event%TYPE;
1113: s_gl_id_rec hz_cust_site_uses_all.gl_id_rec%TYPE;
1114: s_gl_id_rev hz_cust_site_uses_all.gl_id_rev%TYPE;

Line 1111: s_invoice_quantity_rule hz_cust_site_uses_all.invoice_quantity_rule%TYPE;

1107: s_under_return_tolerance hz_cust_site_uses_all.under_return_tolerance%TYPE;
1108: s_ship_sets_include_lines_flag hz_cust_site_uses_all.ship_sets_include_lines_flag%TYPE;
1109: s_arv_include_lines_flag hz_cust_site_uses_all.arrivalsets_include_lines_flag%TYPE;
1110: s_sched_date_push_flag hz_cust_site_uses_all.sched_date_push_flag%TYPE;
1111: s_invoice_quantity_rule hz_cust_site_uses_all.invoice_quantity_rule%TYPE;
1112: s_pricing_event hz_cust_site_uses_all.pricing_event%TYPE;
1113: s_gl_id_rec hz_cust_site_uses_all.gl_id_rec%TYPE;
1114: s_gl_id_rev hz_cust_site_uses_all.gl_id_rev%TYPE;
1115: s_gl_id_tax hz_cust_site_uses_all.gl_id_tax%TYPE;

Line 1112: s_pricing_event hz_cust_site_uses_all.pricing_event%TYPE;

1108: s_ship_sets_include_lines_flag hz_cust_site_uses_all.ship_sets_include_lines_flag%TYPE;
1109: s_arv_include_lines_flag hz_cust_site_uses_all.arrivalsets_include_lines_flag%TYPE;
1110: s_sched_date_push_flag hz_cust_site_uses_all.sched_date_push_flag%TYPE;
1111: s_invoice_quantity_rule hz_cust_site_uses_all.invoice_quantity_rule%TYPE;
1112: s_pricing_event hz_cust_site_uses_all.pricing_event%TYPE;
1113: s_gl_id_rec hz_cust_site_uses_all.gl_id_rec%TYPE;
1114: s_gl_id_rev hz_cust_site_uses_all.gl_id_rev%TYPE;
1115: s_gl_id_tax hz_cust_site_uses_all.gl_id_tax%TYPE;
1116: s_gl_id_freight hz_cust_site_uses_all.gl_id_freight%TYPE;

Line 1113: s_gl_id_rec hz_cust_site_uses_all.gl_id_rec%TYPE;

1109: s_arv_include_lines_flag hz_cust_site_uses_all.arrivalsets_include_lines_flag%TYPE;
1110: s_sched_date_push_flag hz_cust_site_uses_all.sched_date_push_flag%TYPE;
1111: s_invoice_quantity_rule hz_cust_site_uses_all.invoice_quantity_rule%TYPE;
1112: s_pricing_event hz_cust_site_uses_all.pricing_event%TYPE;
1113: s_gl_id_rec hz_cust_site_uses_all.gl_id_rec%TYPE;
1114: s_gl_id_rev hz_cust_site_uses_all.gl_id_rev%TYPE;
1115: s_gl_id_tax hz_cust_site_uses_all.gl_id_tax%TYPE;
1116: s_gl_id_freight hz_cust_site_uses_all.gl_id_freight%TYPE;
1117: s_gl_id_clearing hz_cust_site_uses_all.gl_id_clearing%TYPE;

Line 1114: s_gl_id_rev hz_cust_site_uses_all.gl_id_rev%TYPE;

1110: s_sched_date_push_flag hz_cust_site_uses_all.sched_date_push_flag%TYPE;
1111: s_invoice_quantity_rule hz_cust_site_uses_all.invoice_quantity_rule%TYPE;
1112: s_pricing_event hz_cust_site_uses_all.pricing_event%TYPE;
1113: s_gl_id_rec hz_cust_site_uses_all.gl_id_rec%TYPE;
1114: s_gl_id_rev hz_cust_site_uses_all.gl_id_rev%TYPE;
1115: s_gl_id_tax hz_cust_site_uses_all.gl_id_tax%TYPE;
1116: s_gl_id_freight hz_cust_site_uses_all.gl_id_freight%TYPE;
1117: s_gl_id_clearing hz_cust_site_uses_all.gl_id_clearing%TYPE;
1118: s_gl_id_unbilled hz_cust_site_uses_all.gl_id_unbilled%TYPE;

Line 1115: s_gl_id_tax hz_cust_site_uses_all.gl_id_tax%TYPE;

1111: s_invoice_quantity_rule hz_cust_site_uses_all.invoice_quantity_rule%TYPE;
1112: s_pricing_event hz_cust_site_uses_all.pricing_event%TYPE;
1113: s_gl_id_rec hz_cust_site_uses_all.gl_id_rec%TYPE;
1114: s_gl_id_rev hz_cust_site_uses_all.gl_id_rev%TYPE;
1115: s_gl_id_tax hz_cust_site_uses_all.gl_id_tax%TYPE;
1116: s_gl_id_freight hz_cust_site_uses_all.gl_id_freight%TYPE;
1117: s_gl_id_clearing hz_cust_site_uses_all.gl_id_clearing%TYPE;
1118: s_gl_id_unbilled hz_cust_site_uses_all.gl_id_unbilled%TYPE;
1119: s_gl_id_unearned hz_cust_site_uses_all.gl_id_unearned%TYPE;

Line 1116: s_gl_id_freight hz_cust_site_uses_all.gl_id_freight%TYPE;

1112: s_pricing_event hz_cust_site_uses_all.pricing_event%TYPE;
1113: s_gl_id_rec hz_cust_site_uses_all.gl_id_rec%TYPE;
1114: s_gl_id_rev hz_cust_site_uses_all.gl_id_rev%TYPE;
1115: s_gl_id_tax hz_cust_site_uses_all.gl_id_tax%TYPE;
1116: s_gl_id_freight hz_cust_site_uses_all.gl_id_freight%TYPE;
1117: s_gl_id_clearing hz_cust_site_uses_all.gl_id_clearing%TYPE;
1118: s_gl_id_unbilled hz_cust_site_uses_all.gl_id_unbilled%TYPE;
1119: s_gl_id_unearned hz_cust_site_uses_all.gl_id_unearned%TYPE;
1120: s_gl_id_unpaid_rec hz_cust_site_uses_all.gl_id_unpaid_rec%TYPE;

Line 1117: s_gl_id_clearing hz_cust_site_uses_all.gl_id_clearing%TYPE;

1113: s_gl_id_rec hz_cust_site_uses_all.gl_id_rec%TYPE;
1114: s_gl_id_rev hz_cust_site_uses_all.gl_id_rev%TYPE;
1115: s_gl_id_tax hz_cust_site_uses_all.gl_id_tax%TYPE;
1116: s_gl_id_freight hz_cust_site_uses_all.gl_id_freight%TYPE;
1117: s_gl_id_clearing hz_cust_site_uses_all.gl_id_clearing%TYPE;
1118: s_gl_id_unbilled hz_cust_site_uses_all.gl_id_unbilled%TYPE;
1119: s_gl_id_unearned hz_cust_site_uses_all.gl_id_unearned%TYPE;
1120: s_gl_id_unpaid_rec hz_cust_site_uses_all.gl_id_unpaid_rec%TYPE;
1121: s_gl_id_remittance hz_cust_site_uses_all.gl_id_remittance%TYPE;

Line 1118: s_gl_id_unbilled hz_cust_site_uses_all.gl_id_unbilled%TYPE;

1114: s_gl_id_rev hz_cust_site_uses_all.gl_id_rev%TYPE;
1115: s_gl_id_tax hz_cust_site_uses_all.gl_id_tax%TYPE;
1116: s_gl_id_freight hz_cust_site_uses_all.gl_id_freight%TYPE;
1117: s_gl_id_clearing hz_cust_site_uses_all.gl_id_clearing%TYPE;
1118: s_gl_id_unbilled hz_cust_site_uses_all.gl_id_unbilled%TYPE;
1119: s_gl_id_unearned hz_cust_site_uses_all.gl_id_unearned%TYPE;
1120: s_gl_id_unpaid_rec hz_cust_site_uses_all.gl_id_unpaid_rec%TYPE;
1121: s_gl_id_remittance hz_cust_site_uses_all.gl_id_remittance%TYPE;
1122: s_gl_id_factor hz_cust_site_uses_all.gl_id_factor%TYPE;

Line 1119: s_gl_id_unearned hz_cust_site_uses_all.gl_id_unearned%TYPE;

1115: s_gl_id_tax hz_cust_site_uses_all.gl_id_tax%TYPE;
1116: s_gl_id_freight hz_cust_site_uses_all.gl_id_freight%TYPE;
1117: s_gl_id_clearing hz_cust_site_uses_all.gl_id_clearing%TYPE;
1118: s_gl_id_unbilled hz_cust_site_uses_all.gl_id_unbilled%TYPE;
1119: s_gl_id_unearned hz_cust_site_uses_all.gl_id_unearned%TYPE;
1120: s_gl_id_unpaid_rec hz_cust_site_uses_all.gl_id_unpaid_rec%TYPE;
1121: s_gl_id_remittance hz_cust_site_uses_all.gl_id_remittance%TYPE;
1122: s_gl_id_factor hz_cust_site_uses_all.gl_id_factor%TYPE;
1123: s_tax_classification hz_cust_site_uses_all.tax_classification%TYPE;

Line 1120: s_gl_id_unpaid_rec hz_cust_site_uses_all.gl_id_unpaid_rec%TYPE;

1116: s_gl_id_freight hz_cust_site_uses_all.gl_id_freight%TYPE;
1117: s_gl_id_clearing hz_cust_site_uses_all.gl_id_clearing%TYPE;
1118: s_gl_id_unbilled hz_cust_site_uses_all.gl_id_unbilled%TYPE;
1119: s_gl_id_unearned hz_cust_site_uses_all.gl_id_unearned%TYPE;
1120: s_gl_id_unpaid_rec hz_cust_site_uses_all.gl_id_unpaid_rec%TYPE;
1121: s_gl_id_remittance hz_cust_site_uses_all.gl_id_remittance%TYPE;
1122: s_gl_id_factor hz_cust_site_uses_all.gl_id_factor%TYPE;
1123: s_tax_classification hz_cust_site_uses_all.tax_classification%TYPE;
1124: s_last_update_date DATE;

Line 1121: s_gl_id_remittance hz_cust_site_uses_all.gl_id_remittance%TYPE;

1117: s_gl_id_clearing hz_cust_site_uses_all.gl_id_clearing%TYPE;
1118: s_gl_id_unbilled hz_cust_site_uses_all.gl_id_unbilled%TYPE;
1119: s_gl_id_unearned hz_cust_site_uses_all.gl_id_unearned%TYPE;
1120: s_gl_id_unpaid_rec hz_cust_site_uses_all.gl_id_unpaid_rec%TYPE;
1121: s_gl_id_remittance hz_cust_site_uses_all.gl_id_remittance%TYPE;
1122: s_gl_id_factor hz_cust_site_uses_all.gl_id_factor%TYPE;
1123: s_tax_classification hz_cust_site_uses_all.tax_classification%TYPE;
1124: s_last_update_date DATE;
1125: s_last_updated_by NUMBER;

Line 1122: s_gl_id_factor hz_cust_site_uses_all.gl_id_factor%TYPE;

1118: s_gl_id_unbilled hz_cust_site_uses_all.gl_id_unbilled%TYPE;
1119: s_gl_id_unearned hz_cust_site_uses_all.gl_id_unearned%TYPE;
1120: s_gl_id_unpaid_rec hz_cust_site_uses_all.gl_id_unpaid_rec%TYPE;
1121: s_gl_id_remittance hz_cust_site_uses_all.gl_id_remittance%TYPE;
1122: s_gl_id_factor hz_cust_site_uses_all.gl_id_factor%TYPE;
1123: s_tax_classification hz_cust_site_uses_all.tax_classification%TYPE;
1124: s_last_update_date DATE;
1125: s_last_updated_by NUMBER;
1126:

Line 1123: s_tax_classification hz_cust_site_uses_all.tax_classification%TYPE;

1119: s_gl_id_unearned hz_cust_site_uses_all.gl_id_unearned%TYPE;
1120: s_gl_id_unpaid_rec hz_cust_site_uses_all.gl_id_unpaid_rec%TYPE;
1121: s_gl_id_remittance hz_cust_site_uses_all.gl_id_remittance%TYPE;
1122: s_gl_id_factor hz_cust_site_uses_all.gl_id_factor%TYPE;
1123: s_tax_classification hz_cust_site_uses_all.tax_classification%TYPE;
1124: s_last_update_date DATE;
1125: s_last_updated_by NUMBER;
1126:
1127: CURSOR l_cust_site_use_csr IS

Line 2461: t_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;

2457: s_ADDRESSEE VARCHAR2(50) := NULL;
2458: s_shared_party_site VARCHAR2(1) := 'N';
2459: s_update_account_site VARCHAR2(1) := 'N';
2460: s_create_location_party_site VARCHAR2(1) := 'N';
2461: t_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;
2462: t_cust_acct_site_id hz_cust_site_uses_all.cust_acct_site_id%TYPE;
2463: t_primary_flag hz_cust_site_uses_all.primary_flag%TYPE;
2464: t_status hz_cust_site_uses_all.status%TYPE;
2465: t_address_id po_location_associations_all.address_id%TYPE;

Line 2462: t_cust_acct_site_id hz_cust_site_uses_all.cust_acct_site_id%TYPE;

2458: s_shared_party_site VARCHAR2(1) := 'N';
2459: s_update_account_site VARCHAR2(1) := 'N';
2460: s_create_location_party_site VARCHAR2(1) := 'N';
2461: t_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;
2462: t_cust_acct_site_id hz_cust_site_uses_all.cust_acct_site_id%TYPE;
2463: t_primary_flag hz_cust_site_uses_all.primary_flag%TYPE;
2464: t_status hz_cust_site_uses_all.status%TYPE;
2465: t_address_id po_location_associations_all.address_id%TYPE;
2466: t_site_loc_id hr_locations.location_id%TYPE;

Line 2463: t_primary_flag hz_cust_site_uses_all.primary_flag%TYPE;

2459: s_update_account_site VARCHAR2(1) := 'N';
2460: s_create_location_party_site VARCHAR2(1) := 'N';
2461: t_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;
2462: t_cust_acct_site_id hz_cust_site_uses_all.cust_acct_site_id%TYPE;
2463: t_primary_flag hz_cust_site_uses_all.primary_flag%TYPE;
2464: t_status hz_cust_site_uses_all.status%TYPE;
2465: t_address_id po_location_associations_all.address_id%TYPE;
2466: t_site_loc_id hr_locations.location_id%TYPE;
2467: t_orig_system_reference hz_locations.orig_system_reference%TYPE;

Line 2464: t_status hz_cust_site_uses_all.status%TYPE;

2460: s_create_location_party_site VARCHAR2(1) := 'N';
2461: t_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;
2462: t_cust_acct_site_id hz_cust_site_uses_all.cust_acct_site_id%TYPE;
2463: t_primary_flag hz_cust_site_uses_all.primary_flag%TYPE;
2464: t_status hz_cust_site_uses_all.status%TYPE;
2465: t_address_id po_location_associations_all.address_id%TYPE;
2466: t_site_loc_id hr_locations.location_id%TYPE;
2467: t_orig_system_reference hz_locations.orig_system_reference%TYPE;
2468: t_last_update_date DATE;

Line 4421: FROM hz_cust_site_uses_all c_site_use,

4417: l_city_name VARCHAr2(240);
4418:
4419: CURSOR site_use_cur IS
4420: SELECT c_site_use.site_use_id, c_acct_site.cust_acct_site_id
4421: FROM hz_cust_site_uses_all c_site_use,
4422: hz_cust_acct_sites_all c_acct_site
4423: WHERE c_site_use.site_use_code = 'SHIP_TO'
4424: AND c_site_use.cust_acct_site_id = c_acct_site.cust_acct_site_id
4425: AND c_acct_site.cust_account_id = p_cust_account_id