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.CSP_SHIP_TO_ADDRESS_PVT dependencies on HZ_CUST_SITE_USES_ALL

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

1138: l_language VARCHAR2(4);
1139: EXCP_USER_DEFINED EXCEPTION;
1140:
1141: s_location_id hr_locations.location_id%TYPE := p_location_id;
1142: s_site_use_id hz_cust_site_uses_all.site_use_id%TYPE := NULL;
1143: b_site_use_id hz_cust_site_uses_all.site_use_id%TYPE := NULL;
1144: s_primary_flag hz_cust_site_uses_all.primary_flag%TYPE := NULL;
1145: s_status hz_cust_site_uses_all.status%TYPE := NULL;
1146:

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

1139: EXCP_USER_DEFINED EXCEPTION;
1140:
1141: s_location_id hr_locations.location_id%TYPE := p_location_id;
1142: s_site_use_id hz_cust_site_uses_all.site_use_id%TYPE := NULL;
1143: b_site_use_id hz_cust_site_uses_all.site_use_id%TYPE := NULL;
1144: s_primary_flag hz_cust_site_uses_all.primary_flag%TYPE := NULL;
1145: s_status hz_cust_site_uses_all.status%TYPE := NULL;
1146:
1147: CURSOR l_primary_party_site_use_csr IS

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

1140:
1141: s_location_id hr_locations.location_id%TYPE := p_location_id;
1142: s_site_use_id hz_cust_site_uses_all.site_use_id%TYPE := NULL;
1143: b_site_use_id hz_cust_site_uses_all.site_use_id%TYPE := NULL;
1144: s_primary_flag hz_cust_site_uses_all.primary_flag%TYPE := NULL;
1145: s_status hz_cust_site_uses_all.status%TYPE := NULL;
1146:
1147: CURSOR l_primary_party_site_use_csr IS
1148: select primary_per_type

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

1141: s_location_id hr_locations.location_id%TYPE := p_location_id;
1142: s_site_use_id hz_cust_site_uses_all.site_use_id%TYPE := NULL;
1143: b_site_use_id hz_cust_site_uses_all.site_use_id%TYPE := NULL;
1144: s_primary_flag hz_cust_site_uses_all.primary_flag%TYPE := NULL;
1145: s_status hz_cust_site_uses_all.status%TYPE := NULL;
1146:
1147: CURSOR l_primary_party_site_use_csr IS
1148: select primary_per_type
1149: from hz_party_site_uses

Line 1514: l_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;

1510: l_api_name CONSTANT VARCHAR2(30) := 'do_update_site_use';
1511: l_language VARCHAR2(4);
1512: EXCP_USER_DEFINED EXCEPTION;
1513:
1514: l_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;
1515: s_cust_acct_site_id hz_cust_site_uses_all.cust_acct_site_id%TYPE;
1516: s_creation_date hz_cust_site_uses_all.creation_date%TYPE;
1517: s_created_by hz_cust_site_uses_all.created_by%TYPE;
1518: s_site_use_code hz_cust_site_uses_all.site_use_code%TYPE;

Line 1515: s_cust_acct_site_id hz_cust_site_uses_all.cust_acct_site_id%TYPE;

1511: l_language VARCHAR2(4);
1512: EXCP_USER_DEFINED EXCEPTION;
1513:
1514: l_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;
1515: s_cust_acct_site_id hz_cust_site_uses_all.cust_acct_site_id%TYPE;
1516: s_creation_date hz_cust_site_uses_all.creation_date%TYPE;
1517: s_created_by hz_cust_site_uses_all.created_by%TYPE;
1518: s_site_use_code hz_cust_site_uses_all.site_use_code%TYPE;
1519: s_primary_flag hz_cust_site_uses_all.primary_flag%TYPE;

Line 1516: s_creation_date hz_cust_site_uses_all.creation_date%TYPE;

1512: EXCP_USER_DEFINED EXCEPTION;
1513:
1514: l_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;
1515: s_cust_acct_site_id hz_cust_site_uses_all.cust_acct_site_id%TYPE;
1516: s_creation_date hz_cust_site_uses_all.creation_date%TYPE;
1517: s_created_by hz_cust_site_uses_all.created_by%TYPE;
1518: s_site_use_code hz_cust_site_uses_all.site_use_code%TYPE;
1519: s_primary_flag hz_cust_site_uses_all.primary_flag%TYPE;
1520: s_status hz_cust_site_uses_all.status%TYPE;

Line 1517: s_created_by hz_cust_site_uses_all.created_by%TYPE;

1513:
1514: l_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;
1515: s_cust_acct_site_id hz_cust_site_uses_all.cust_acct_site_id%TYPE;
1516: s_creation_date hz_cust_site_uses_all.creation_date%TYPE;
1517: s_created_by hz_cust_site_uses_all.created_by%TYPE;
1518: s_site_use_code hz_cust_site_uses_all.site_use_code%TYPE;
1519: s_primary_flag hz_cust_site_uses_all.primary_flag%TYPE;
1520: s_status hz_cust_site_uses_all.status%TYPE;
1521: s_location hz_cust_site_uses_all.location%TYPE;

Line 1518: s_site_use_code hz_cust_site_uses_all.site_use_code%TYPE;

1514: l_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;
1515: s_cust_acct_site_id hz_cust_site_uses_all.cust_acct_site_id%TYPE;
1516: s_creation_date hz_cust_site_uses_all.creation_date%TYPE;
1517: s_created_by hz_cust_site_uses_all.created_by%TYPE;
1518: s_site_use_code hz_cust_site_uses_all.site_use_code%TYPE;
1519: s_primary_flag hz_cust_site_uses_all.primary_flag%TYPE;
1520: s_status hz_cust_site_uses_all.status%TYPE;
1521: s_location hz_cust_site_uses_all.location%TYPE;
1522: s_last_update_login hz_cust_site_uses_all.last_update_login%TYPE;

Line 1519: s_primary_flag hz_cust_site_uses_all.primary_flag%TYPE;

1515: s_cust_acct_site_id hz_cust_site_uses_all.cust_acct_site_id%TYPE;
1516: s_creation_date hz_cust_site_uses_all.creation_date%TYPE;
1517: s_created_by hz_cust_site_uses_all.created_by%TYPE;
1518: s_site_use_code hz_cust_site_uses_all.site_use_code%TYPE;
1519: s_primary_flag hz_cust_site_uses_all.primary_flag%TYPE;
1520: s_status hz_cust_site_uses_all.status%TYPE;
1521: s_location hz_cust_site_uses_all.location%TYPE;
1522: s_last_update_login hz_cust_site_uses_all.last_update_login%TYPE;
1523: s_contact_id hz_cust_site_uses_all.contact_id%TYPE;

Line 1520: s_status hz_cust_site_uses_all.status%TYPE;

1516: s_creation_date hz_cust_site_uses_all.creation_date%TYPE;
1517: s_created_by hz_cust_site_uses_all.created_by%TYPE;
1518: s_site_use_code hz_cust_site_uses_all.site_use_code%TYPE;
1519: s_primary_flag hz_cust_site_uses_all.primary_flag%TYPE;
1520: s_status hz_cust_site_uses_all.status%TYPE;
1521: s_location hz_cust_site_uses_all.location%TYPE;
1522: s_last_update_login hz_cust_site_uses_all.last_update_login%TYPE;
1523: s_contact_id hz_cust_site_uses_all.contact_id%TYPE;
1524: s_bill_to_site_use_id hz_cust_site_uses_all.bill_to_site_use_id%TYPE;

Line 1521: s_location hz_cust_site_uses_all.location%TYPE;

1517: s_created_by hz_cust_site_uses_all.created_by%TYPE;
1518: s_site_use_code hz_cust_site_uses_all.site_use_code%TYPE;
1519: s_primary_flag hz_cust_site_uses_all.primary_flag%TYPE;
1520: s_status hz_cust_site_uses_all.status%TYPE;
1521: s_location hz_cust_site_uses_all.location%TYPE;
1522: s_last_update_login hz_cust_site_uses_all.last_update_login%TYPE;
1523: s_contact_id hz_cust_site_uses_all.contact_id%TYPE;
1524: s_bill_to_site_use_id hz_cust_site_uses_all.bill_to_site_use_id%TYPE;
1525: s_orig_system_reference hz_cust_site_uses_all.orig_system_reference%TYPE;

Line 1522: s_last_update_login hz_cust_site_uses_all.last_update_login%TYPE;

1518: s_site_use_code hz_cust_site_uses_all.site_use_code%TYPE;
1519: s_primary_flag hz_cust_site_uses_all.primary_flag%TYPE;
1520: s_status hz_cust_site_uses_all.status%TYPE;
1521: s_location hz_cust_site_uses_all.location%TYPE;
1522: s_last_update_login hz_cust_site_uses_all.last_update_login%TYPE;
1523: s_contact_id hz_cust_site_uses_all.contact_id%TYPE;
1524: s_bill_to_site_use_id hz_cust_site_uses_all.bill_to_site_use_id%TYPE;
1525: s_orig_system_reference hz_cust_site_uses_all.orig_system_reference%TYPE;
1526: s_sic_code hz_cust_site_uses_all.sic_code%TYPE;

Line 1523: s_contact_id hz_cust_site_uses_all.contact_id%TYPE;

1519: s_primary_flag hz_cust_site_uses_all.primary_flag%TYPE;
1520: s_status hz_cust_site_uses_all.status%TYPE;
1521: s_location hz_cust_site_uses_all.location%TYPE;
1522: s_last_update_login hz_cust_site_uses_all.last_update_login%TYPE;
1523: s_contact_id hz_cust_site_uses_all.contact_id%TYPE;
1524: s_bill_to_site_use_id hz_cust_site_uses_all.bill_to_site_use_id%TYPE;
1525: s_orig_system_reference hz_cust_site_uses_all.orig_system_reference%TYPE;
1526: s_sic_code hz_cust_site_uses_all.sic_code%TYPE;
1527: s_payment_term_id hz_cust_site_uses_all.payment_term_id%TYPE;

Line 1524: s_bill_to_site_use_id hz_cust_site_uses_all.bill_to_site_use_id%TYPE;

1520: s_status hz_cust_site_uses_all.status%TYPE;
1521: s_location hz_cust_site_uses_all.location%TYPE;
1522: s_last_update_login hz_cust_site_uses_all.last_update_login%TYPE;
1523: s_contact_id hz_cust_site_uses_all.contact_id%TYPE;
1524: s_bill_to_site_use_id hz_cust_site_uses_all.bill_to_site_use_id%TYPE;
1525: s_orig_system_reference hz_cust_site_uses_all.orig_system_reference%TYPE;
1526: s_sic_code hz_cust_site_uses_all.sic_code%TYPE;
1527: s_payment_term_id hz_cust_site_uses_all.payment_term_id%TYPE;
1528: s_gsa_indicator hz_cust_site_uses_all.gsa_indicator%TYPE;

Line 1525: s_orig_system_reference hz_cust_site_uses_all.orig_system_reference%TYPE;

1521: s_location hz_cust_site_uses_all.location%TYPE;
1522: s_last_update_login hz_cust_site_uses_all.last_update_login%TYPE;
1523: s_contact_id hz_cust_site_uses_all.contact_id%TYPE;
1524: s_bill_to_site_use_id hz_cust_site_uses_all.bill_to_site_use_id%TYPE;
1525: s_orig_system_reference hz_cust_site_uses_all.orig_system_reference%TYPE;
1526: s_sic_code hz_cust_site_uses_all.sic_code%TYPE;
1527: s_payment_term_id hz_cust_site_uses_all.payment_term_id%TYPE;
1528: s_gsa_indicator hz_cust_site_uses_all.gsa_indicator%TYPE;
1529: s_ship_partial hz_cust_site_uses_all.ship_partial%TYPE;

Line 1526: s_sic_code hz_cust_site_uses_all.sic_code%TYPE;

1522: s_last_update_login hz_cust_site_uses_all.last_update_login%TYPE;
1523: s_contact_id hz_cust_site_uses_all.contact_id%TYPE;
1524: s_bill_to_site_use_id hz_cust_site_uses_all.bill_to_site_use_id%TYPE;
1525: s_orig_system_reference hz_cust_site_uses_all.orig_system_reference%TYPE;
1526: s_sic_code hz_cust_site_uses_all.sic_code%TYPE;
1527: s_payment_term_id hz_cust_site_uses_all.payment_term_id%TYPE;
1528: s_gsa_indicator hz_cust_site_uses_all.gsa_indicator%TYPE;
1529: s_ship_partial hz_cust_site_uses_all.ship_partial%TYPE;
1530: s_ship_via hz_cust_site_uses_all.ship_via%TYPE;

Line 1527: s_payment_term_id hz_cust_site_uses_all.payment_term_id%TYPE;

1523: s_contact_id hz_cust_site_uses_all.contact_id%TYPE;
1524: s_bill_to_site_use_id hz_cust_site_uses_all.bill_to_site_use_id%TYPE;
1525: s_orig_system_reference hz_cust_site_uses_all.orig_system_reference%TYPE;
1526: s_sic_code hz_cust_site_uses_all.sic_code%TYPE;
1527: s_payment_term_id hz_cust_site_uses_all.payment_term_id%TYPE;
1528: s_gsa_indicator hz_cust_site_uses_all.gsa_indicator%TYPE;
1529: s_ship_partial hz_cust_site_uses_all.ship_partial%TYPE;
1530: s_ship_via hz_cust_site_uses_all.ship_via%TYPE;
1531: s_fob_point hz_cust_site_uses_all.fob_point%TYPE;

Line 1528: s_gsa_indicator hz_cust_site_uses_all.gsa_indicator%TYPE;

1524: s_bill_to_site_use_id hz_cust_site_uses_all.bill_to_site_use_id%TYPE;
1525: s_orig_system_reference hz_cust_site_uses_all.orig_system_reference%TYPE;
1526: s_sic_code hz_cust_site_uses_all.sic_code%TYPE;
1527: s_payment_term_id hz_cust_site_uses_all.payment_term_id%TYPE;
1528: s_gsa_indicator hz_cust_site_uses_all.gsa_indicator%TYPE;
1529: s_ship_partial hz_cust_site_uses_all.ship_partial%TYPE;
1530: s_ship_via hz_cust_site_uses_all.ship_via%TYPE;
1531: s_fob_point hz_cust_site_uses_all.fob_point%TYPE;
1532: s_order_type_id hz_cust_site_uses_all.order_type_id%TYPE;

Line 1529: s_ship_partial hz_cust_site_uses_all.ship_partial%TYPE;

1525: s_orig_system_reference hz_cust_site_uses_all.orig_system_reference%TYPE;
1526: s_sic_code hz_cust_site_uses_all.sic_code%TYPE;
1527: s_payment_term_id hz_cust_site_uses_all.payment_term_id%TYPE;
1528: s_gsa_indicator hz_cust_site_uses_all.gsa_indicator%TYPE;
1529: s_ship_partial hz_cust_site_uses_all.ship_partial%TYPE;
1530: s_ship_via hz_cust_site_uses_all.ship_via%TYPE;
1531: s_fob_point hz_cust_site_uses_all.fob_point%TYPE;
1532: s_order_type_id hz_cust_site_uses_all.order_type_id%TYPE;
1533: s_price_list_id hz_cust_site_uses_all.price_list_id%TYPE;

Line 1530: s_ship_via hz_cust_site_uses_all.ship_via%TYPE;

1526: s_sic_code hz_cust_site_uses_all.sic_code%TYPE;
1527: s_payment_term_id hz_cust_site_uses_all.payment_term_id%TYPE;
1528: s_gsa_indicator hz_cust_site_uses_all.gsa_indicator%TYPE;
1529: s_ship_partial hz_cust_site_uses_all.ship_partial%TYPE;
1530: s_ship_via hz_cust_site_uses_all.ship_via%TYPE;
1531: s_fob_point hz_cust_site_uses_all.fob_point%TYPE;
1532: s_order_type_id hz_cust_site_uses_all.order_type_id%TYPE;
1533: s_price_list_id hz_cust_site_uses_all.price_list_id%TYPE;
1534: s_freight_term hz_cust_site_uses_all.freight_term%TYPE;

Line 1531: s_fob_point hz_cust_site_uses_all.fob_point%TYPE;

1527: s_payment_term_id hz_cust_site_uses_all.payment_term_id%TYPE;
1528: s_gsa_indicator hz_cust_site_uses_all.gsa_indicator%TYPE;
1529: s_ship_partial hz_cust_site_uses_all.ship_partial%TYPE;
1530: s_ship_via hz_cust_site_uses_all.ship_via%TYPE;
1531: s_fob_point hz_cust_site_uses_all.fob_point%TYPE;
1532: s_order_type_id hz_cust_site_uses_all.order_type_id%TYPE;
1533: s_price_list_id hz_cust_site_uses_all.price_list_id%TYPE;
1534: s_freight_term hz_cust_site_uses_all.freight_term%TYPE;
1535: s_warehouse_id hz_cust_site_uses_all.warehouse_id%TYPE;

Line 1532: s_order_type_id hz_cust_site_uses_all.order_type_id%TYPE;

1528: s_gsa_indicator hz_cust_site_uses_all.gsa_indicator%TYPE;
1529: s_ship_partial hz_cust_site_uses_all.ship_partial%TYPE;
1530: s_ship_via hz_cust_site_uses_all.ship_via%TYPE;
1531: s_fob_point hz_cust_site_uses_all.fob_point%TYPE;
1532: s_order_type_id hz_cust_site_uses_all.order_type_id%TYPE;
1533: s_price_list_id hz_cust_site_uses_all.price_list_id%TYPE;
1534: s_freight_term hz_cust_site_uses_all.freight_term%TYPE;
1535: s_warehouse_id hz_cust_site_uses_all.warehouse_id%TYPE;
1536: s_territory_id hz_cust_site_uses_all.territory_id%TYPE;

Line 1533: s_price_list_id hz_cust_site_uses_all.price_list_id%TYPE;

1529: s_ship_partial hz_cust_site_uses_all.ship_partial%TYPE;
1530: s_ship_via hz_cust_site_uses_all.ship_via%TYPE;
1531: s_fob_point hz_cust_site_uses_all.fob_point%TYPE;
1532: s_order_type_id hz_cust_site_uses_all.order_type_id%TYPE;
1533: s_price_list_id hz_cust_site_uses_all.price_list_id%TYPE;
1534: s_freight_term hz_cust_site_uses_all.freight_term%TYPE;
1535: s_warehouse_id hz_cust_site_uses_all.warehouse_id%TYPE;
1536: s_territory_id hz_cust_site_uses_all.territory_id%TYPE;
1537: s_attribute_category hz_cust_site_uses_all.attribute_category%TYPE;

Line 1534: s_freight_term hz_cust_site_uses_all.freight_term%TYPE;

1530: s_ship_via hz_cust_site_uses_all.ship_via%TYPE;
1531: s_fob_point hz_cust_site_uses_all.fob_point%TYPE;
1532: s_order_type_id hz_cust_site_uses_all.order_type_id%TYPE;
1533: s_price_list_id hz_cust_site_uses_all.price_list_id%TYPE;
1534: s_freight_term hz_cust_site_uses_all.freight_term%TYPE;
1535: s_warehouse_id hz_cust_site_uses_all.warehouse_id%TYPE;
1536: s_territory_id hz_cust_site_uses_all.territory_id%TYPE;
1537: s_attribute_category hz_cust_site_uses_all.attribute_category%TYPE;
1538: s_attribute1 hz_cust_site_uses_all.attribute1%TYPE;

Line 1535: s_warehouse_id hz_cust_site_uses_all.warehouse_id%TYPE;

1531: s_fob_point hz_cust_site_uses_all.fob_point%TYPE;
1532: s_order_type_id hz_cust_site_uses_all.order_type_id%TYPE;
1533: s_price_list_id hz_cust_site_uses_all.price_list_id%TYPE;
1534: s_freight_term hz_cust_site_uses_all.freight_term%TYPE;
1535: s_warehouse_id hz_cust_site_uses_all.warehouse_id%TYPE;
1536: s_territory_id hz_cust_site_uses_all.territory_id%TYPE;
1537: s_attribute_category hz_cust_site_uses_all.attribute_category%TYPE;
1538: s_attribute1 hz_cust_site_uses_all.attribute1%TYPE;
1539: s_attribute2 hz_cust_site_uses_all.attribute2%TYPE;

Line 1536: s_territory_id hz_cust_site_uses_all.territory_id%TYPE;

1532: s_order_type_id hz_cust_site_uses_all.order_type_id%TYPE;
1533: s_price_list_id hz_cust_site_uses_all.price_list_id%TYPE;
1534: s_freight_term hz_cust_site_uses_all.freight_term%TYPE;
1535: s_warehouse_id hz_cust_site_uses_all.warehouse_id%TYPE;
1536: s_territory_id hz_cust_site_uses_all.territory_id%TYPE;
1537: s_attribute_category hz_cust_site_uses_all.attribute_category%TYPE;
1538: s_attribute1 hz_cust_site_uses_all.attribute1%TYPE;
1539: s_attribute2 hz_cust_site_uses_all.attribute2%TYPE;
1540: s_attribute3 hz_cust_site_uses_all.attribute3%TYPE;

Line 1537: s_attribute_category hz_cust_site_uses_all.attribute_category%TYPE;

1533: s_price_list_id hz_cust_site_uses_all.price_list_id%TYPE;
1534: s_freight_term hz_cust_site_uses_all.freight_term%TYPE;
1535: s_warehouse_id hz_cust_site_uses_all.warehouse_id%TYPE;
1536: s_territory_id hz_cust_site_uses_all.territory_id%TYPE;
1537: s_attribute_category hz_cust_site_uses_all.attribute_category%TYPE;
1538: s_attribute1 hz_cust_site_uses_all.attribute1%TYPE;
1539: s_attribute2 hz_cust_site_uses_all.attribute2%TYPE;
1540: s_attribute3 hz_cust_site_uses_all.attribute3%TYPE;
1541: s_attribute4 hz_cust_site_uses_all.attribute4%TYPE;

Line 1538: s_attribute1 hz_cust_site_uses_all.attribute1%TYPE;

1534: s_freight_term hz_cust_site_uses_all.freight_term%TYPE;
1535: s_warehouse_id hz_cust_site_uses_all.warehouse_id%TYPE;
1536: s_territory_id hz_cust_site_uses_all.territory_id%TYPE;
1537: s_attribute_category hz_cust_site_uses_all.attribute_category%TYPE;
1538: s_attribute1 hz_cust_site_uses_all.attribute1%TYPE;
1539: s_attribute2 hz_cust_site_uses_all.attribute2%TYPE;
1540: s_attribute3 hz_cust_site_uses_all.attribute3%TYPE;
1541: s_attribute4 hz_cust_site_uses_all.attribute4%TYPE;
1542: s_attribute5 hz_cust_site_uses_all.attribute5%TYPE;

Line 1539: s_attribute2 hz_cust_site_uses_all.attribute2%TYPE;

1535: s_warehouse_id hz_cust_site_uses_all.warehouse_id%TYPE;
1536: s_territory_id hz_cust_site_uses_all.territory_id%TYPE;
1537: s_attribute_category hz_cust_site_uses_all.attribute_category%TYPE;
1538: s_attribute1 hz_cust_site_uses_all.attribute1%TYPE;
1539: s_attribute2 hz_cust_site_uses_all.attribute2%TYPE;
1540: s_attribute3 hz_cust_site_uses_all.attribute3%TYPE;
1541: s_attribute4 hz_cust_site_uses_all.attribute4%TYPE;
1542: s_attribute5 hz_cust_site_uses_all.attribute5%TYPE;
1543: s_attribute6 hz_cust_site_uses_all.attribute6%TYPE;

Line 1540: s_attribute3 hz_cust_site_uses_all.attribute3%TYPE;

1536: s_territory_id hz_cust_site_uses_all.territory_id%TYPE;
1537: s_attribute_category hz_cust_site_uses_all.attribute_category%TYPE;
1538: s_attribute1 hz_cust_site_uses_all.attribute1%TYPE;
1539: s_attribute2 hz_cust_site_uses_all.attribute2%TYPE;
1540: s_attribute3 hz_cust_site_uses_all.attribute3%TYPE;
1541: s_attribute4 hz_cust_site_uses_all.attribute4%TYPE;
1542: s_attribute5 hz_cust_site_uses_all.attribute5%TYPE;
1543: s_attribute6 hz_cust_site_uses_all.attribute6%TYPE;
1544: s_attribute7 hz_cust_site_uses_all.attribute7%TYPE;

Line 1541: s_attribute4 hz_cust_site_uses_all.attribute4%TYPE;

1537: s_attribute_category hz_cust_site_uses_all.attribute_category%TYPE;
1538: s_attribute1 hz_cust_site_uses_all.attribute1%TYPE;
1539: s_attribute2 hz_cust_site_uses_all.attribute2%TYPE;
1540: s_attribute3 hz_cust_site_uses_all.attribute3%TYPE;
1541: s_attribute4 hz_cust_site_uses_all.attribute4%TYPE;
1542: s_attribute5 hz_cust_site_uses_all.attribute5%TYPE;
1543: s_attribute6 hz_cust_site_uses_all.attribute6%TYPE;
1544: s_attribute7 hz_cust_site_uses_all.attribute7%TYPE;
1545: s_attribute8 hz_cust_site_uses_all.attribute8%TYPE;

Line 1542: s_attribute5 hz_cust_site_uses_all.attribute5%TYPE;

1538: s_attribute1 hz_cust_site_uses_all.attribute1%TYPE;
1539: s_attribute2 hz_cust_site_uses_all.attribute2%TYPE;
1540: s_attribute3 hz_cust_site_uses_all.attribute3%TYPE;
1541: s_attribute4 hz_cust_site_uses_all.attribute4%TYPE;
1542: s_attribute5 hz_cust_site_uses_all.attribute5%TYPE;
1543: s_attribute6 hz_cust_site_uses_all.attribute6%TYPE;
1544: s_attribute7 hz_cust_site_uses_all.attribute7%TYPE;
1545: s_attribute8 hz_cust_site_uses_all.attribute8%TYPE;
1546: s_attribute9 hz_cust_site_uses_all.attribute9%TYPE;

Line 1543: s_attribute6 hz_cust_site_uses_all.attribute6%TYPE;

1539: s_attribute2 hz_cust_site_uses_all.attribute2%TYPE;
1540: s_attribute3 hz_cust_site_uses_all.attribute3%TYPE;
1541: s_attribute4 hz_cust_site_uses_all.attribute4%TYPE;
1542: s_attribute5 hz_cust_site_uses_all.attribute5%TYPE;
1543: s_attribute6 hz_cust_site_uses_all.attribute6%TYPE;
1544: s_attribute7 hz_cust_site_uses_all.attribute7%TYPE;
1545: s_attribute8 hz_cust_site_uses_all.attribute8%TYPE;
1546: s_attribute9 hz_cust_site_uses_all.attribute9%TYPE;
1547: s_attribute10 hz_cust_site_uses_all.attribute10%TYPE;

Line 1544: s_attribute7 hz_cust_site_uses_all.attribute7%TYPE;

1540: s_attribute3 hz_cust_site_uses_all.attribute3%TYPE;
1541: s_attribute4 hz_cust_site_uses_all.attribute4%TYPE;
1542: s_attribute5 hz_cust_site_uses_all.attribute5%TYPE;
1543: s_attribute6 hz_cust_site_uses_all.attribute6%TYPE;
1544: s_attribute7 hz_cust_site_uses_all.attribute7%TYPE;
1545: s_attribute8 hz_cust_site_uses_all.attribute8%TYPE;
1546: s_attribute9 hz_cust_site_uses_all.attribute9%TYPE;
1547: s_attribute10 hz_cust_site_uses_all.attribute10%TYPE;
1548: s_request_id hz_cust_site_uses_all.request_id%TYPE;

Line 1545: s_attribute8 hz_cust_site_uses_all.attribute8%TYPE;

1541: s_attribute4 hz_cust_site_uses_all.attribute4%TYPE;
1542: s_attribute5 hz_cust_site_uses_all.attribute5%TYPE;
1543: s_attribute6 hz_cust_site_uses_all.attribute6%TYPE;
1544: s_attribute7 hz_cust_site_uses_all.attribute7%TYPE;
1545: s_attribute8 hz_cust_site_uses_all.attribute8%TYPE;
1546: s_attribute9 hz_cust_site_uses_all.attribute9%TYPE;
1547: s_attribute10 hz_cust_site_uses_all.attribute10%TYPE;
1548: s_request_id hz_cust_site_uses_all.request_id%TYPE;
1549: s_program_application_id hz_cust_site_uses_all.program_application_id%TYPE;

Line 1546: s_attribute9 hz_cust_site_uses_all.attribute9%TYPE;

1542: s_attribute5 hz_cust_site_uses_all.attribute5%TYPE;
1543: s_attribute6 hz_cust_site_uses_all.attribute6%TYPE;
1544: s_attribute7 hz_cust_site_uses_all.attribute7%TYPE;
1545: s_attribute8 hz_cust_site_uses_all.attribute8%TYPE;
1546: s_attribute9 hz_cust_site_uses_all.attribute9%TYPE;
1547: s_attribute10 hz_cust_site_uses_all.attribute10%TYPE;
1548: s_request_id hz_cust_site_uses_all.request_id%TYPE;
1549: s_program_application_id hz_cust_site_uses_all.program_application_id%TYPE;
1550: s_program_id hz_cust_site_uses_all.program_id%TYPE;

Line 1547: s_attribute10 hz_cust_site_uses_all.attribute10%TYPE;

1543: s_attribute6 hz_cust_site_uses_all.attribute6%TYPE;
1544: s_attribute7 hz_cust_site_uses_all.attribute7%TYPE;
1545: s_attribute8 hz_cust_site_uses_all.attribute8%TYPE;
1546: s_attribute9 hz_cust_site_uses_all.attribute9%TYPE;
1547: s_attribute10 hz_cust_site_uses_all.attribute10%TYPE;
1548: s_request_id hz_cust_site_uses_all.request_id%TYPE;
1549: s_program_application_id hz_cust_site_uses_all.program_application_id%TYPE;
1550: s_program_id hz_cust_site_uses_all.program_id%TYPE;
1551: s_program_update_date hz_cust_site_uses_all.program_update_date%TYPE;

Line 1548: s_request_id hz_cust_site_uses_all.request_id%TYPE;

1544: s_attribute7 hz_cust_site_uses_all.attribute7%TYPE;
1545: s_attribute8 hz_cust_site_uses_all.attribute8%TYPE;
1546: s_attribute9 hz_cust_site_uses_all.attribute9%TYPE;
1547: s_attribute10 hz_cust_site_uses_all.attribute10%TYPE;
1548: s_request_id hz_cust_site_uses_all.request_id%TYPE;
1549: s_program_application_id hz_cust_site_uses_all.program_application_id%TYPE;
1550: s_program_id hz_cust_site_uses_all.program_id%TYPE;
1551: s_program_update_date hz_cust_site_uses_all.program_update_date%TYPE;
1552: s_tax_reference hz_cust_site_uses_all.tax_reference%TYPE;

Line 1549: s_program_application_id hz_cust_site_uses_all.program_application_id%TYPE;

1545: s_attribute8 hz_cust_site_uses_all.attribute8%TYPE;
1546: s_attribute9 hz_cust_site_uses_all.attribute9%TYPE;
1547: s_attribute10 hz_cust_site_uses_all.attribute10%TYPE;
1548: s_request_id hz_cust_site_uses_all.request_id%TYPE;
1549: s_program_application_id hz_cust_site_uses_all.program_application_id%TYPE;
1550: s_program_id hz_cust_site_uses_all.program_id%TYPE;
1551: s_program_update_date hz_cust_site_uses_all.program_update_date%TYPE;
1552: s_tax_reference hz_cust_site_uses_all.tax_reference%TYPE;
1553: s_sort_priority hz_cust_site_uses_all.sort_priority%TYPE;

Line 1550: s_program_id hz_cust_site_uses_all.program_id%TYPE;

1546: s_attribute9 hz_cust_site_uses_all.attribute9%TYPE;
1547: s_attribute10 hz_cust_site_uses_all.attribute10%TYPE;
1548: s_request_id hz_cust_site_uses_all.request_id%TYPE;
1549: s_program_application_id hz_cust_site_uses_all.program_application_id%TYPE;
1550: s_program_id hz_cust_site_uses_all.program_id%TYPE;
1551: s_program_update_date hz_cust_site_uses_all.program_update_date%TYPE;
1552: s_tax_reference hz_cust_site_uses_all.tax_reference%TYPE;
1553: s_sort_priority hz_cust_site_uses_all.sort_priority%TYPE;
1554: s_tax_code hz_cust_site_uses_all.tax_code%TYPE;

Line 1551: s_program_update_date hz_cust_site_uses_all.program_update_date%TYPE;

1547: s_attribute10 hz_cust_site_uses_all.attribute10%TYPE;
1548: s_request_id hz_cust_site_uses_all.request_id%TYPE;
1549: s_program_application_id hz_cust_site_uses_all.program_application_id%TYPE;
1550: s_program_id hz_cust_site_uses_all.program_id%TYPE;
1551: s_program_update_date hz_cust_site_uses_all.program_update_date%TYPE;
1552: s_tax_reference hz_cust_site_uses_all.tax_reference%TYPE;
1553: s_sort_priority hz_cust_site_uses_all.sort_priority%TYPE;
1554: s_tax_code hz_cust_site_uses_all.tax_code%TYPE;
1555: s_attribute11 hz_cust_site_uses_all.attribute11%TYPE;

Line 1552: s_tax_reference hz_cust_site_uses_all.tax_reference%TYPE;

1548: s_request_id hz_cust_site_uses_all.request_id%TYPE;
1549: s_program_application_id hz_cust_site_uses_all.program_application_id%TYPE;
1550: s_program_id hz_cust_site_uses_all.program_id%TYPE;
1551: s_program_update_date hz_cust_site_uses_all.program_update_date%TYPE;
1552: s_tax_reference hz_cust_site_uses_all.tax_reference%TYPE;
1553: s_sort_priority hz_cust_site_uses_all.sort_priority%TYPE;
1554: s_tax_code hz_cust_site_uses_all.tax_code%TYPE;
1555: s_attribute11 hz_cust_site_uses_all.attribute11%TYPE;
1556: s_attribute12 hz_cust_site_uses_all.attribute12%TYPE;

Line 1553: s_sort_priority hz_cust_site_uses_all.sort_priority%TYPE;

1549: s_program_application_id hz_cust_site_uses_all.program_application_id%TYPE;
1550: s_program_id hz_cust_site_uses_all.program_id%TYPE;
1551: s_program_update_date hz_cust_site_uses_all.program_update_date%TYPE;
1552: s_tax_reference hz_cust_site_uses_all.tax_reference%TYPE;
1553: s_sort_priority hz_cust_site_uses_all.sort_priority%TYPE;
1554: s_tax_code hz_cust_site_uses_all.tax_code%TYPE;
1555: s_attribute11 hz_cust_site_uses_all.attribute11%TYPE;
1556: s_attribute12 hz_cust_site_uses_all.attribute12%TYPE;
1557: s_attribute13 hz_cust_site_uses_all.attribute13%TYPE;

Line 1554: s_tax_code hz_cust_site_uses_all.tax_code%TYPE;

1550: s_program_id hz_cust_site_uses_all.program_id%TYPE;
1551: s_program_update_date hz_cust_site_uses_all.program_update_date%TYPE;
1552: s_tax_reference hz_cust_site_uses_all.tax_reference%TYPE;
1553: s_sort_priority hz_cust_site_uses_all.sort_priority%TYPE;
1554: s_tax_code hz_cust_site_uses_all.tax_code%TYPE;
1555: s_attribute11 hz_cust_site_uses_all.attribute11%TYPE;
1556: s_attribute12 hz_cust_site_uses_all.attribute12%TYPE;
1557: s_attribute13 hz_cust_site_uses_all.attribute13%TYPE;
1558: s_attribute14 hz_cust_site_uses_all.attribute14%TYPE;

Line 1555: s_attribute11 hz_cust_site_uses_all.attribute11%TYPE;

1551: s_program_update_date hz_cust_site_uses_all.program_update_date%TYPE;
1552: s_tax_reference hz_cust_site_uses_all.tax_reference%TYPE;
1553: s_sort_priority hz_cust_site_uses_all.sort_priority%TYPE;
1554: s_tax_code hz_cust_site_uses_all.tax_code%TYPE;
1555: s_attribute11 hz_cust_site_uses_all.attribute11%TYPE;
1556: s_attribute12 hz_cust_site_uses_all.attribute12%TYPE;
1557: s_attribute13 hz_cust_site_uses_all.attribute13%TYPE;
1558: s_attribute14 hz_cust_site_uses_all.attribute14%TYPE;
1559: s_attribute15 hz_cust_site_uses_all.attribute15%TYPE;

Line 1556: s_attribute12 hz_cust_site_uses_all.attribute12%TYPE;

1552: s_tax_reference hz_cust_site_uses_all.tax_reference%TYPE;
1553: s_sort_priority hz_cust_site_uses_all.sort_priority%TYPE;
1554: s_tax_code hz_cust_site_uses_all.tax_code%TYPE;
1555: s_attribute11 hz_cust_site_uses_all.attribute11%TYPE;
1556: s_attribute12 hz_cust_site_uses_all.attribute12%TYPE;
1557: s_attribute13 hz_cust_site_uses_all.attribute13%TYPE;
1558: s_attribute14 hz_cust_site_uses_all.attribute14%TYPE;
1559: s_attribute15 hz_cust_site_uses_all.attribute15%TYPE;
1560: s_attribute16 hz_cust_site_uses_all.attribute16%TYPE;

Line 1557: s_attribute13 hz_cust_site_uses_all.attribute13%TYPE;

1553: s_sort_priority hz_cust_site_uses_all.sort_priority%TYPE;
1554: s_tax_code hz_cust_site_uses_all.tax_code%TYPE;
1555: s_attribute11 hz_cust_site_uses_all.attribute11%TYPE;
1556: s_attribute12 hz_cust_site_uses_all.attribute12%TYPE;
1557: s_attribute13 hz_cust_site_uses_all.attribute13%TYPE;
1558: s_attribute14 hz_cust_site_uses_all.attribute14%TYPE;
1559: s_attribute15 hz_cust_site_uses_all.attribute15%TYPE;
1560: s_attribute16 hz_cust_site_uses_all.attribute16%TYPE;
1561: s_attribute17 hz_cust_site_uses_all.attribute17%TYPE;

Line 1558: s_attribute14 hz_cust_site_uses_all.attribute14%TYPE;

1554: s_tax_code hz_cust_site_uses_all.tax_code%TYPE;
1555: s_attribute11 hz_cust_site_uses_all.attribute11%TYPE;
1556: s_attribute12 hz_cust_site_uses_all.attribute12%TYPE;
1557: s_attribute13 hz_cust_site_uses_all.attribute13%TYPE;
1558: s_attribute14 hz_cust_site_uses_all.attribute14%TYPE;
1559: s_attribute15 hz_cust_site_uses_all.attribute15%TYPE;
1560: s_attribute16 hz_cust_site_uses_all.attribute16%TYPE;
1561: s_attribute17 hz_cust_site_uses_all.attribute17%TYPE;
1562: s_attribute18 hz_cust_site_uses_all.attribute18%TYPE;

Line 1559: s_attribute15 hz_cust_site_uses_all.attribute15%TYPE;

1555: s_attribute11 hz_cust_site_uses_all.attribute11%TYPE;
1556: s_attribute12 hz_cust_site_uses_all.attribute12%TYPE;
1557: s_attribute13 hz_cust_site_uses_all.attribute13%TYPE;
1558: s_attribute14 hz_cust_site_uses_all.attribute14%TYPE;
1559: s_attribute15 hz_cust_site_uses_all.attribute15%TYPE;
1560: s_attribute16 hz_cust_site_uses_all.attribute16%TYPE;
1561: s_attribute17 hz_cust_site_uses_all.attribute17%TYPE;
1562: s_attribute18 hz_cust_site_uses_all.attribute18%TYPE;
1563: s_attribute19 hz_cust_site_uses_all.attribute19%TYPE;

Line 1560: s_attribute16 hz_cust_site_uses_all.attribute16%TYPE;

1556: s_attribute12 hz_cust_site_uses_all.attribute12%TYPE;
1557: s_attribute13 hz_cust_site_uses_all.attribute13%TYPE;
1558: s_attribute14 hz_cust_site_uses_all.attribute14%TYPE;
1559: s_attribute15 hz_cust_site_uses_all.attribute15%TYPE;
1560: s_attribute16 hz_cust_site_uses_all.attribute16%TYPE;
1561: s_attribute17 hz_cust_site_uses_all.attribute17%TYPE;
1562: s_attribute18 hz_cust_site_uses_all.attribute18%TYPE;
1563: s_attribute19 hz_cust_site_uses_all.attribute19%TYPE;
1564: s_attribute20 hz_cust_site_uses_all.attribute20%TYPE;

Line 1561: s_attribute17 hz_cust_site_uses_all.attribute17%TYPE;

1557: s_attribute13 hz_cust_site_uses_all.attribute13%TYPE;
1558: s_attribute14 hz_cust_site_uses_all.attribute14%TYPE;
1559: s_attribute15 hz_cust_site_uses_all.attribute15%TYPE;
1560: s_attribute16 hz_cust_site_uses_all.attribute16%TYPE;
1561: s_attribute17 hz_cust_site_uses_all.attribute17%TYPE;
1562: s_attribute18 hz_cust_site_uses_all.attribute18%TYPE;
1563: s_attribute19 hz_cust_site_uses_all.attribute19%TYPE;
1564: s_attribute20 hz_cust_site_uses_all.attribute20%TYPE;
1565: s_attribute21 hz_cust_site_uses_all.attribute21%TYPE;

Line 1562: s_attribute18 hz_cust_site_uses_all.attribute18%TYPE;

1558: s_attribute14 hz_cust_site_uses_all.attribute14%TYPE;
1559: s_attribute15 hz_cust_site_uses_all.attribute15%TYPE;
1560: s_attribute16 hz_cust_site_uses_all.attribute16%TYPE;
1561: s_attribute17 hz_cust_site_uses_all.attribute17%TYPE;
1562: s_attribute18 hz_cust_site_uses_all.attribute18%TYPE;
1563: s_attribute19 hz_cust_site_uses_all.attribute19%TYPE;
1564: s_attribute20 hz_cust_site_uses_all.attribute20%TYPE;
1565: s_attribute21 hz_cust_site_uses_all.attribute21%TYPE;
1566: s_attribute22 hz_cust_site_uses_all.attribute22%TYPE;

Line 1563: s_attribute19 hz_cust_site_uses_all.attribute19%TYPE;

1559: s_attribute15 hz_cust_site_uses_all.attribute15%TYPE;
1560: s_attribute16 hz_cust_site_uses_all.attribute16%TYPE;
1561: s_attribute17 hz_cust_site_uses_all.attribute17%TYPE;
1562: s_attribute18 hz_cust_site_uses_all.attribute18%TYPE;
1563: s_attribute19 hz_cust_site_uses_all.attribute19%TYPE;
1564: s_attribute20 hz_cust_site_uses_all.attribute20%TYPE;
1565: s_attribute21 hz_cust_site_uses_all.attribute21%TYPE;
1566: s_attribute22 hz_cust_site_uses_all.attribute22%TYPE;
1567: s_attribute23 hz_cust_site_uses_all.attribute23%TYPE;

Line 1564: s_attribute20 hz_cust_site_uses_all.attribute20%TYPE;

1560: s_attribute16 hz_cust_site_uses_all.attribute16%TYPE;
1561: s_attribute17 hz_cust_site_uses_all.attribute17%TYPE;
1562: s_attribute18 hz_cust_site_uses_all.attribute18%TYPE;
1563: s_attribute19 hz_cust_site_uses_all.attribute19%TYPE;
1564: s_attribute20 hz_cust_site_uses_all.attribute20%TYPE;
1565: s_attribute21 hz_cust_site_uses_all.attribute21%TYPE;
1566: s_attribute22 hz_cust_site_uses_all.attribute22%TYPE;
1567: s_attribute23 hz_cust_site_uses_all.attribute23%TYPE;
1568: s_attribute24 hz_cust_site_uses_all.attribute24%TYPE;

Line 1565: s_attribute21 hz_cust_site_uses_all.attribute21%TYPE;

1561: s_attribute17 hz_cust_site_uses_all.attribute17%TYPE;
1562: s_attribute18 hz_cust_site_uses_all.attribute18%TYPE;
1563: s_attribute19 hz_cust_site_uses_all.attribute19%TYPE;
1564: s_attribute20 hz_cust_site_uses_all.attribute20%TYPE;
1565: s_attribute21 hz_cust_site_uses_all.attribute21%TYPE;
1566: s_attribute22 hz_cust_site_uses_all.attribute22%TYPE;
1567: s_attribute23 hz_cust_site_uses_all.attribute23%TYPE;
1568: s_attribute24 hz_cust_site_uses_all.attribute24%TYPE;
1569: s_attribute25 hz_cust_site_uses_all.attribute25%TYPE;

Line 1566: s_attribute22 hz_cust_site_uses_all.attribute22%TYPE;

1562: s_attribute18 hz_cust_site_uses_all.attribute18%TYPE;
1563: s_attribute19 hz_cust_site_uses_all.attribute19%TYPE;
1564: s_attribute20 hz_cust_site_uses_all.attribute20%TYPE;
1565: s_attribute21 hz_cust_site_uses_all.attribute21%TYPE;
1566: s_attribute22 hz_cust_site_uses_all.attribute22%TYPE;
1567: s_attribute23 hz_cust_site_uses_all.attribute23%TYPE;
1568: s_attribute24 hz_cust_site_uses_all.attribute24%TYPE;
1569: s_attribute25 hz_cust_site_uses_all.attribute25%TYPE;
1570: s_last_accrue_charge_date DATE;

Line 1567: s_attribute23 hz_cust_site_uses_all.attribute23%TYPE;

1563: s_attribute19 hz_cust_site_uses_all.attribute19%TYPE;
1564: s_attribute20 hz_cust_site_uses_all.attribute20%TYPE;
1565: s_attribute21 hz_cust_site_uses_all.attribute21%TYPE;
1566: s_attribute22 hz_cust_site_uses_all.attribute22%TYPE;
1567: s_attribute23 hz_cust_site_uses_all.attribute23%TYPE;
1568: s_attribute24 hz_cust_site_uses_all.attribute24%TYPE;
1569: s_attribute25 hz_cust_site_uses_all.attribute25%TYPE;
1570: s_last_accrue_charge_date DATE;
1571: s_snd_last_accrue_charge_date DATE;

Line 1568: s_attribute24 hz_cust_site_uses_all.attribute24%TYPE;

1564: s_attribute20 hz_cust_site_uses_all.attribute20%TYPE;
1565: s_attribute21 hz_cust_site_uses_all.attribute21%TYPE;
1566: s_attribute22 hz_cust_site_uses_all.attribute22%TYPE;
1567: s_attribute23 hz_cust_site_uses_all.attribute23%TYPE;
1568: s_attribute24 hz_cust_site_uses_all.attribute24%TYPE;
1569: s_attribute25 hz_cust_site_uses_all.attribute25%TYPE;
1570: s_last_accrue_charge_date DATE;
1571: s_snd_last_accrue_charge_date DATE;
1572: s_last_unaccrue_charge_date DATE;

Line 1569: s_attribute25 hz_cust_site_uses_all.attribute25%TYPE;

1565: s_attribute21 hz_cust_site_uses_all.attribute21%TYPE;
1566: s_attribute22 hz_cust_site_uses_all.attribute22%TYPE;
1567: s_attribute23 hz_cust_site_uses_all.attribute23%TYPE;
1568: s_attribute24 hz_cust_site_uses_all.attribute24%TYPE;
1569: s_attribute25 hz_cust_site_uses_all.attribute25%TYPE;
1570: s_last_accrue_charge_date DATE;
1571: s_snd_last_accrue_charge_date DATE;
1572: s_last_unaccrue_charge_date DATE;
1573: s_snd_last_unaccrue_chrg_date DATE;

Line 1574: s_demand_class_code hz_cust_site_uses_all.demand_class_code%TYPE;

1570: s_last_accrue_charge_date DATE;
1571: s_snd_last_accrue_charge_date DATE;
1572: s_last_unaccrue_charge_date DATE;
1573: s_snd_last_unaccrue_chrg_date DATE;
1574: s_demand_class_code hz_cust_site_uses_all.demand_class_code%TYPE;
1575: s_org_id hz_cust_site_uses_all.org_id%TYPE;
1576: s_tax_header_level_flag hz_cust_site_uses_all.tax_header_level_flag%TYPE;
1577: s_tax_rounding_rule hz_cust_site_uses_all.tax_rounding_rule%TYPE;
1578: s_wh_update_date hz_cust_site_uses_all.wh_update_date%TYPE;

Line 1575: s_org_id hz_cust_site_uses_all.org_id%TYPE;

1571: s_snd_last_accrue_charge_date DATE;
1572: s_last_unaccrue_charge_date DATE;
1573: s_snd_last_unaccrue_chrg_date DATE;
1574: s_demand_class_code hz_cust_site_uses_all.demand_class_code%TYPE;
1575: s_org_id hz_cust_site_uses_all.org_id%TYPE;
1576: s_tax_header_level_flag hz_cust_site_uses_all.tax_header_level_flag%TYPE;
1577: s_tax_rounding_rule hz_cust_site_uses_all.tax_rounding_rule%TYPE;
1578: s_wh_update_date hz_cust_site_uses_all.wh_update_date%TYPE;
1579: s_global_attribute1 hz_cust_site_uses_all.global_attribute1%TYPE;

Line 1576: s_tax_header_level_flag hz_cust_site_uses_all.tax_header_level_flag%TYPE;

1572: s_last_unaccrue_charge_date DATE;
1573: s_snd_last_unaccrue_chrg_date DATE;
1574: s_demand_class_code hz_cust_site_uses_all.demand_class_code%TYPE;
1575: s_org_id hz_cust_site_uses_all.org_id%TYPE;
1576: s_tax_header_level_flag hz_cust_site_uses_all.tax_header_level_flag%TYPE;
1577: s_tax_rounding_rule hz_cust_site_uses_all.tax_rounding_rule%TYPE;
1578: s_wh_update_date hz_cust_site_uses_all.wh_update_date%TYPE;
1579: s_global_attribute1 hz_cust_site_uses_all.global_attribute1%TYPE;
1580: s_global_attribute2 hz_cust_site_uses_all.global_attribute2%TYPE;

Line 1577: s_tax_rounding_rule hz_cust_site_uses_all.tax_rounding_rule%TYPE;

1573: s_snd_last_unaccrue_chrg_date DATE;
1574: s_demand_class_code hz_cust_site_uses_all.demand_class_code%TYPE;
1575: s_org_id hz_cust_site_uses_all.org_id%TYPE;
1576: s_tax_header_level_flag hz_cust_site_uses_all.tax_header_level_flag%TYPE;
1577: s_tax_rounding_rule hz_cust_site_uses_all.tax_rounding_rule%TYPE;
1578: s_wh_update_date hz_cust_site_uses_all.wh_update_date%TYPE;
1579: s_global_attribute1 hz_cust_site_uses_all.global_attribute1%TYPE;
1580: s_global_attribute2 hz_cust_site_uses_all.global_attribute2%TYPE;
1581: s_global_attribute3 hz_cust_site_uses_all.global_attribute3%TYPE;

Line 1578: s_wh_update_date hz_cust_site_uses_all.wh_update_date%TYPE;

1574: s_demand_class_code hz_cust_site_uses_all.demand_class_code%TYPE;
1575: s_org_id hz_cust_site_uses_all.org_id%TYPE;
1576: s_tax_header_level_flag hz_cust_site_uses_all.tax_header_level_flag%TYPE;
1577: s_tax_rounding_rule hz_cust_site_uses_all.tax_rounding_rule%TYPE;
1578: s_wh_update_date hz_cust_site_uses_all.wh_update_date%TYPE;
1579: s_global_attribute1 hz_cust_site_uses_all.global_attribute1%TYPE;
1580: s_global_attribute2 hz_cust_site_uses_all.global_attribute2%TYPE;
1581: s_global_attribute3 hz_cust_site_uses_all.global_attribute3%TYPE;
1582: s_global_attribute4 hz_cust_site_uses_all.global_attribute4%TYPE;

Line 1579: s_global_attribute1 hz_cust_site_uses_all.global_attribute1%TYPE;

1575: s_org_id hz_cust_site_uses_all.org_id%TYPE;
1576: s_tax_header_level_flag hz_cust_site_uses_all.tax_header_level_flag%TYPE;
1577: s_tax_rounding_rule hz_cust_site_uses_all.tax_rounding_rule%TYPE;
1578: s_wh_update_date hz_cust_site_uses_all.wh_update_date%TYPE;
1579: s_global_attribute1 hz_cust_site_uses_all.global_attribute1%TYPE;
1580: s_global_attribute2 hz_cust_site_uses_all.global_attribute2%TYPE;
1581: s_global_attribute3 hz_cust_site_uses_all.global_attribute3%TYPE;
1582: s_global_attribute4 hz_cust_site_uses_all.global_attribute4%TYPE;
1583: s_global_attribute5 hz_cust_site_uses_all.global_attribute5%TYPE;

Line 1580: s_global_attribute2 hz_cust_site_uses_all.global_attribute2%TYPE;

1576: s_tax_header_level_flag hz_cust_site_uses_all.tax_header_level_flag%TYPE;
1577: s_tax_rounding_rule hz_cust_site_uses_all.tax_rounding_rule%TYPE;
1578: s_wh_update_date hz_cust_site_uses_all.wh_update_date%TYPE;
1579: s_global_attribute1 hz_cust_site_uses_all.global_attribute1%TYPE;
1580: s_global_attribute2 hz_cust_site_uses_all.global_attribute2%TYPE;
1581: s_global_attribute3 hz_cust_site_uses_all.global_attribute3%TYPE;
1582: s_global_attribute4 hz_cust_site_uses_all.global_attribute4%TYPE;
1583: s_global_attribute5 hz_cust_site_uses_all.global_attribute5%TYPE;
1584: s_global_attribute6 hz_cust_site_uses_all.global_attribute6%TYPE;

Line 1581: s_global_attribute3 hz_cust_site_uses_all.global_attribute3%TYPE;

1577: s_tax_rounding_rule hz_cust_site_uses_all.tax_rounding_rule%TYPE;
1578: s_wh_update_date hz_cust_site_uses_all.wh_update_date%TYPE;
1579: s_global_attribute1 hz_cust_site_uses_all.global_attribute1%TYPE;
1580: s_global_attribute2 hz_cust_site_uses_all.global_attribute2%TYPE;
1581: s_global_attribute3 hz_cust_site_uses_all.global_attribute3%TYPE;
1582: s_global_attribute4 hz_cust_site_uses_all.global_attribute4%TYPE;
1583: s_global_attribute5 hz_cust_site_uses_all.global_attribute5%TYPE;
1584: s_global_attribute6 hz_cust_site_uses_all.global_attribute6%TYPE;
1585: s_global_attribute7 hz_cust_site_uses_all.global_attribute7%TYPE;

Line 1582: s_global_attribute4 hz_cust_site_uses_all.global_attribute4%TYPE;

1578: s_wh_update_date hz_cust_site_uses_all.wh_update_date%TYPE;
1579: s_global_attribute1 hz_cust_site_uses_all.global_attribute1%TYPE;
1580: s_global_attribute2 hz_cust_site_uses_all.global_attribute2%TYPE;
1581: s_global_attribute3 hz_cust_site_uses_all.global_attribute3%TYPE;
1582: s_global_attribute4 hz_cust_site_uses_all.global_attribute4%TYPE;
1583: s_global_attribute5 hz_cust_site_uses_all.global_attribute5%TYPE;
1584: s_global_attribute6 hz_cust_site_uses_all.global_attribute6%TYPE;
1585: s_global_attribute7 hz_cust_site_uses_all.global_attribute7%TYPE;
1586: s_global_attribute8 hz_cust_site_uses_all.global_attribute8%TYPE;

Line 1583: s_global_attribute5 hz_cust_site_uses_all.global_attribute5%TYPE;

1579: s_global_attribute1 hz_cust_site_uses_all.global_attribute1%TYPE;
1580: s_global_attribute2 hz_cust_site_uses_all.global_attribute2%TYPE;
1581: s_global_attribute3 hz_cust_site_uses_all.global_attribute3%TYPE;
1582: s_global_attribute4 hz_cust_site_uses_all.global_attribute4%TYPE;
1583: s_global_attribute5 hz_cust_site_uses_all.global_attribute5%TYPE;
1584: s_global_attribute6 hz_cust_site_uses_all.global_attribute6%TYPE;
1585: s_global_attribute7 hz_cust_site_uses_all.global_attribute7%TYPE;
1586: s_global_attribute8 hz_cust_site_uses_all.global_attribute8%TYPE;
1587: s_global_attribute9 hz_cust_site_uses_all.global_attribute9%TYPE;

Line 1584: s_global_attribute6 hz_cust_site_uses_all.global_attribute6%TYPE;

1580: s_global_attribute2 hz_cust_site_uses_all.global_attribute2%TYPE;
1581: s_global_attribute3 hz_cust_site_uses_all.global_attribute3%TYPE;
1582: s_global_attribute4 hz_cust_site_uses_all.global_attribute4%TYPE;
1583: s_global_attribute5 hz_cust_site_uses_all.global_attribute5%TYPE;
1584: s_global_attribute6 hz_cust_site_uses_all.global_attribute6%TYPE;
1585: s_global_attribute7 hz_cust_site_uses_all.global_attribute7%TYPE;
1586: s_global_attribute8 hz_cust_site_uses_all.global_attribute8%TYPE;
1587: s_global_attribute9 hz_cust_site_uses_all.global_attribute9%TYPE;
1588: s_global_attribute10 hz_cust_site_uses_all.global_attribute10%TYPE;

Line 1585: s_global_attribute7 hz_cust_site_uses_all.global_attribute7%TYPE;

1581: s_global_attribute3 hz_cust_site_uses_all.global_attribute3%TYPE;
1582: s_global_attribute4 hz_cust_site_uses_all.global_attribute4%TYPE;
1583: s_global_attribute5 hz_cust_site_uses_all.global_attribute5%TYPE;
1584: s_global_attribute6 hz_cust_site_uses_all.global_attribute6%TYPE;
1585: s_global_attribute7 hz_cust_site_uses_all.global_attribute7%TYPE;
1586: s_global_attribute8 hz_cust_site_uses_all.global_attribute8%TYPE;
1587: s_global_attribute9 hz_cust_site_uses_all.global_attribute9%TYPE;
1588: s_global_attribute10 hz_cust_site_uses_all.global_attribute10%TYPE;
1589: s_global_attribute11 hz_cust_site_uses_all.global_attribute11%TYPE;

Line 1586: s_global_attribute8 hz_cust_site_uses_all.global_attribute8%TYPE;

1582: s_global_attribute4 hz_cust_site_uses_all.global_attribute4%TYPE;
1583: s_global_attribute5 hz_cust_site_uses_all.global_attribute5%TYPE;
1584: s_global_attribute6 hz_cust_site_uses_all.global_attribute6%TYPE;
1585: s_global_attribute7 hz_cust_site_uses_all.global_attribute7%TYPE;
1586: s_global_attribute8 hz_cust_site_uses_all.global_attribute8%TYPE;
1587: s_global_attribute9 hz_cust_site_uses_all.global_attribute9%TYPE;
1588: s_global_attribute10 hz_cust_site_uses_all.global_attribute10%TYPE;
1589: s_global_attribute11 hz_cust_site_uses_all.global_attribute11%TYPE;
1590: s_global_attribute12 hz_cust_site_uses_all.global_attribute12%TYPE;

Line 1587: s_global_attribute9 hz_cust_site_uses_all.global_attribute9%TYPE;

1583: s_global_attribute5 hz_cust_site_uses_all.global_attribute5%TYPE;
1584: s_global_attribute6 hz_cust_site_uses_all.global_attribute6%TYPE;
1585: s_global_attribute7 hz_cust_site_uses_all.global_attribute7%TYPE;
1586: s_global_attribute8 hz_cust_site_uses_all.global_attribute8%TYPE;
1587: s_global_attribute9 hz_cust_site_uses_all.global_attribute9%TYPE;
1588: s_global_attribute10 hz_cust_site_uses_all.global_attribute10%TYPE;
1589: s_global_attribute11 hz_cust_site_uses_all.global_attribute11%TYPE;
1590: s_global_attribute12 hz_cust_site_uses_all.global_attribute12%TYPE;
1591: s_global_attribute13 hz_cust_site_uses_all.global_attribute13%TYPE;

Line 1588: s_global_attribute10 hz_cust_site_uses_all.global_attribute10%TYPE;

1584: s_global_attribute6 hz_cust_site_uses_all.global_attribute6%TYPE;
1585: s_global_attribute7 hz_cust_site_uses_all.global_attribute7%TYPE;
1586: s_global_attribute8 hz_cust_site_uses_all.global_attribute8%TYPE;
1587: s_global_attribute9 hz_cust_site_uses_all.global_attribute9%TYPE;
1588: s_global_attribute10 hz_cust_site_uses_all.global_attribute10%TYPE;
1589: s_global_attribute11 hz_cust_site_uses_all.global_attribute11%TYPE;
1590: s_global_attribute12 hz_cust_site_uses_all.global_attribute12%TYPE;
1591: s_global_attribute13 hz_cust_site_uses_all.global_attribute13%TYPE;
1592: s_global_attribute14 hz_cust_site_uses_all.global_attribute14%TYPE;

Line 1589: s_global_attribute11 hz_cust_site_uses_all.global_attribute11%TYPE;

1585: s_global_attribute7 hz_cust_site_uses_all.global_attribute7%TYPE;
1586: s_global_attribute8 hz_cust_site_uses_all.global_attribute8%TYPE;
1587: s_global_attribute9 hz_cust_site_uses_all.global_attribute9%TYPE;
1588: s_global_attribute10 hz_cust_site_uses_all.global_attribute10%TYPE;
1589: s_global_attribute11 hz_cust_site_uses_all.global_attribute11%TYPE;
1590: s_global_attribute12 hz_cust_site_uses_all.global_attribute12%TYPE;
1591: s_global_attribute13 hz_cust_site_uses_all.global_attribute13%TYPE;
1592: s_global_attribute14 hz_cust_site_uses_all.global_attribute14%TYPE;
1593: s_global_attribute15 hz_cust_site_uses_all.global_attribute15%TYPE;

Line 1590: s_global_attribute12 hz_cust_site_uses_all.global_attribute12%TYPE;

1586: s_global_attribute8 hz_cust_site_uses_all.global_attribute8%TYPE;
1587: s_global_attribute9 hz_cust_site_uses_all.global_attribute9%TYPE;
1588: s_global_attribute10 hz_cust_site_uses_all.global_attribute10%TYPE;
1589: s_global_attribute11 hz_cust_site_uses_all.global_attribute11%TYPE;
1590: s_global_attribute12 hz_cust_site_uses_all.global_attribute12%TYPE;
1591: s_global_attribute13 hz_cust_site_uses_all.global_attribute13%TYPE;
1592: s_global_attribute14 hz_cust_site_uses_all.global_attribute14%TYPE;
1593: s_global_attribute15 hz_cust_site_uses_all.global_attribute15%TYPE;
1594: s_global_attribute16 hz_cust_site_uses_all.global_attribute16%TYPE;

Line 1591: s_global_attribute13 hz_cust_site_uses_all.global_attribute13%TYPE;

1587: s_global_attribute9 hz_cust_site_uses_all.global_attribute9%TYPE;
1588: s_global_attribute10 hz_cust_site_uses_all.global_attribute10%TYPE;
1589: s_global_attribute11 hz_cust_site_uses_all.global_attribute11%TYPE;
1590: s_global_attribute12 hz_cust_site_uses_all.global_attribute12%TYPE;
1591: s_global_attribute13 hz_cust_site_uses_all.global_attribute13%TYPE;
1592: s_global_attribute14 hz_cust_site_uses_all.global_attribute14%TYPE;
1593: s_global_attribute15 hz_cust_site_uses_all.global_attribute15%TYPE;
1594: s_global_attribute16 hz_cust_site_uses_all.global_attribute16%TYPE;
1595: s_global_attribute17 hz_cust_site_uses_all.global_attribute17%TYPE;

Line 1592: s_global_attribute14 hz_cust_site_uses_all.global_attribute14%TYPE;

1588: s_global_attribute10 hz_cust_site_uses_all.global_attribute10%TYPE;
1589: s_global_attribute11 hz_cust_site_uses_all.global_attribute11%TYPE;
1590: s_global_attribute12 hz_cust_site_uses_all.global_attribute12%TYPE;
1591: s_global_attribute13 hz_cust_site_uses_all.global_attribute13%TYPE;
1592: s_global_attribute14 hz_cust_site_uses_all.global_attribute14%TYPE;
1593: s_global_attribute15 hz_cust_site_uses_all.global_attribute15%TYPE;
1594: s_global_attribute16 hz_cust_site_uses_all.global_attribute16%TYPE;
1595: s_global_attribute17 hz_cust_site_uses_all.global_attribute17%TYPE;
1596: s_global_attribute18 hz_cust_site_uses_all.global_attribute18%TYPE;

Line 1593: s_global_attribute15 hz_cust_site_uses_all.global_attribute15%TYPE;

1589: s_global_attribute11 hz_cust_site_uses_all.global_attribute11%TYPE;
1590: s_global_attribute12 hz_cust_site_uses_all.global_attribute12%TYPE;
1591: s_global_attribute13 hz_cust_site_uses_all.global_attribute13%TYPE;
1592: s_global_attribute14 hz_cust_site_uses_all.global_attribute14%TYPE;
1593: s_global_attribute15 hz_cust_site_uses_all.global_attribute15%TYPE;
1594: s_global_attribute16 hz_cust_site_uses_all.global_attribute16%TYPE;
1595: s_global_attribute17 hz_cust_site_uses_all.global_attribute17%TYPE;
1596: s_global_attribute18 hz_cust_site_uses_all.global_attribute18%TYPE;
1597: s_global_attribute19 hz_cust_site_uses_all.global_attribute19%TYPE;

Line 1594: s_global_attribute16 hz_cust_site_uses_all.global_attribute16%TYPE;

1590: s_global_attribute12 hz_cust_site_uses_all.global_attribute12%TYPE;
1591: s_global_attribute13 hz_cust_site_uses_all.global_attribute13%TYPE;
1592: s_global_attribute14 hz_cust_site_uses_all.global_attribute14%TYPE;
1593: s_global_attribute15 hz_cust_site_uses_all.global_attribute15%TYPE;
1594: s_global_attribute16 hz_cust_site_uses_all.global_attribute16%TYPE;
1595: s_global_attribute17 hz_cust_site_uses_all.global_attribute17%TYPE;
1596: s_global_attribute18 hz_cust_site_uses_all.global_attribute18%TYPE;
1597: s_global_attribute19 hz_cust_site_uses_all.global_attribute19%TYPE;
1598: s_global_attribute20 hz_cust_site_uses_all.global_attribute20%TYPE;

Line 1595: s_global_attribute17 hz_cust_site_uses_all.global_attribute17%TYPE;

1591: s_global_attribute13 hz_cust_site_uses_all.global_attribute13%TYPE;
1592: s_global_attribute14 hz_cust_site_uses_all.global_attribute14%TYPE;
1593: s_global_attribute15 hz_cust_site_uses_all.global_attribute15%TYPE;
1594: s_global_attribute16 hz_cust_site_uses_all.global_attribute16%TYPE;
1595: s_global_attribute17 hz_cust_site_uses_all.global_attribute17%TYPE;
1596: s_global_attribute18 hz_cust_site_uses_all.global_attribute18%TYPE;
1597: s_global_attribute19 hz_cust_site_uses_all.global_attribute19%TYPE;
1598: s_global_attribute20 hz_cust_site_uses_all.global_attribute20%TYPE;
1599: s_global_attribute_category hz_cust_site_uses_all.global_attribute_category%TYPE;

Line 1596: s_global_attribute18 hz_cust_site_uses_all.global_attribute18%TYPE;

1592: s_global_attribute14 hz_cust_site_uses_all.global_attribute14%TYPE;
1593: s_global_attribute15 hz_cust_site_uses_all.global_attribute15%TYPE;
1594: s_global_attribute16 hz_cust_site_uses_all.global_attribute16%TYPE;
1595: s_global_attribute17 hz_cust_site_uses_all.global_attribute17%TYPE;
1596: s_global_attribute18 hz_cust_site_uses_all.global_attribute18%TYPE;
1597: s_global_attribute19 hz_cust_site_uses_all.global_attribute19%TYPE;
1598: s_global_attribute20 hz_cust_site_uses_all.global_attribute20%TYPE;
1599: s_global_attribute_category hz_cust_site_uses_all.global_attribute_category%TYPE;
1600: s_primary_salesrep_id hz_cust_site_uses_all.primary_salesrep_id%TYPE;

Line 1597: s_global_attribute19 hz_cust_site_uses_all.global_attribute19%TYPE;

1593: s_global_attribute15 hz_cust_site_uses_all.global_attribute15%TYPE;
1594: s_global_attribute16 hz_cust_site_uses_all.global_attribute16%TYPE;
1595: s_global_attribute17 hz_cust_site_uses_all.global_attribute17%TYPE;
1596: s_global_attribute18 hz_cust_site_uses_all.global_attribute18%TYPE;
1597: s_global_attribute19 hz_cust_site_uses_all.global_attribute19%TYPE;
1598: s_global_attribute20 hz_cust_site_uses_all.global_attribute20%TYPE;
1599: s_global_attribute_category hz_cust_site_uses_all.global_attribute_category%TYPE;
1600: s_primary_salesrep_id hz_cust_site_uses_all.primary_salesrep_id%TYPE;
1601: s_finchrg_receivables_trx_id hz_cust_site_uses_all.finchrg_receivables_trx_id%TYPE;

Line 1598: s_global_attribute20 hz_cust_site_uses_all.global_attribute20%TYPE;

1594: s_global_attribute16 hz_cust_site_uses_all.global_attribute16%TYPE;
1595: s_global_attribute17 hz_cust_site_uses_all.global_attribute17%TYPE;
1596: s_global_attribute18 hz_cust_site_uses_all.global_attribute18%TYPE;
1597: s_global_attribute19 hz_cust_site_uses_all.global_attribute19%TYPE;
1598: s_global_attribute20 hz_cust_site_uses_all.global_attribute20%TYPE;
1599: s_global_attribute_category hz_cust_site_uses_all.global_attribute_category%TYPE;
1600: s_primary_salesrep_id hz_cust_site_uses_all.primary_salesrep_id%TYPE;
1601: s_finchrg_receivables_trx_id hz_cust_site_uses_all.finchrg_receivables_trx_id%TYPE;
1602: s_dates_negative_tolerance hz_cust_site_uses_all.dates_negative_tolerance%TYPE;

Line 1599: s_global_attribute_category hz_cust_site_uses_all.global_attribute_category%TYPE;

1595: s_global_attribute17 hz_cust_site_uses_all.global_attribute17%TYPE;
1596: s_global_attribute18 hz_cust_site_uses_all.global_attribute18%TYPE;
1597: s_global_attribute19 hz_cust_site_uses_all.global_attribute19%TYPE;
1598: s_global_attribute20 hz_cust_site_uses_all.global_attribute20%TYPE;
1599: s_global_attribute_category hz_cust_site_uses_all.global_attribute_category%TYPE;
1600: s_primary_salesrep_id hz_cust_site_uses_all.primary_salesrep_id%TYPE;
1601: s_finchrg_receivables_trx_id hz_cust_site_uses_all.finchrg_receivables_trx_id%TYPE;
1602: s_dates_negative_tolerance hz_cust_site_uses_all.dates_negative_tolerance%TYPE;
1603: s_dates_positive_tolerance hz_cust_site_uses_all.dates_positive_tolerance%TYPE;

Line 1600: s_primary_salesrep_id hz_cust_site_uses_all.primary_salesrep_id%TYPE;

1596: s_global_attribute18 hz_cust_site_uses_all.global_attribute18%TYPE;
1597: s_global_attribute19 hz_cust_site_uses_all.global_attribute19%TYPE;
1598: s_global_attribute20 hz_cust_site_uses_all.global_attribute20%TYPE;
1599: s_global_attribute_category hz_cust_site_uses_all.global_attribute_category%TYPE;
1600: s_primary_salesrep_id hz_cust_site_uses_all.primary_salesrep_id%TYPE;
1601: s_finchrg_receivables_trx_id hz_cust_site_uses_all.finchrg_receivables_trx_id%TYPE;
1602: s_dates_negative_tolerance hz_cust_site_uses_all.dates_negative_tolerance%TYPE;
1603: s_dates_positive_tolerance hz_cust_site_uses_all.dates_positive_tolerance%TYPE;
1604: s_date_type_preference hz_cust_site_uses_all.date_type_preference%TYPE;

Line 1601: s_finchrg_receivables_trx_id hz_cust_site_uses_all.finchrg_receivables_trx_id%TYPE;

1597: s_global_attribute19 hz_cust_site_uses_all.global_attribute19%TYPE;
1598: s_global_attribute20 hz_cust_site_uses_all.global_attribute20%TYPE;
1599: s_global_attribute_category hz_cust_site_uses_all.global_attribute_category%TYPE;
1600: s_primary_salesrep_id hz_cust_site_uses_all.primary_salesrep_id%TYPE;
1601: s_finchrg_receivables_trx_id hz_cust_site_uses_all.finchrg_receivables_trx_id%TYPE;
1602: s_dates_negative_tolerance hz_cust_site_uses_all.dates_negative_tolerance%TYPE;
1603: s_dates_positive_tolerance hz_cust_site_uses_all.dates_positive_tolerance%TYPE;
1604: s_date_type_preference hz_cust_site_uses_all.date_type_preference%TYPE;
1605: s_over_shipment_tolerance hz_cust_site_uses_all.over_shipment_tolerance%TYPE;

Line 1602: s_dates_negative_tolerance hz_cust_site_uses_all.dates_negative_tolerance%TYPE;

1598: s_global_attribute20 hz_cust_site_uses_all.global_attribute20%TYPE;
1599: s_global_attribute_category hz_cust_site_uses_all.global_attribute_category%TYPE;
1600: s_primary_salesrep_id hz_cust_site_uses_all.primary_salesrep_id%TYPE;
1601: s_finchrg_receivables_trx_id hz_cust_site_uses_all.finchrg_receivables_trx_id%TYPE;
1602: s_dates_negative_tolerance hz_cust_site_uses_all.dates_negative_tolerance%TYPE;
1603: s_dates_positive_tolerance hz_cust_site_uses_all.dates_positive_tolerance%TYPE;
1604: s_date_type_preference hz_cust_site_uses_all.date_type_preference%TYPE;
1605: s_over_shipment_tolerance hz_cust_site_uses_all.over_shipment_tolerance%TYPE;
1606: s_under_shipment_tolerance hz_cust_site_uses_all.under_shipment_tolerance%TYPE;

Line 1603: s_dates_positive_tolerance hz_cust_site_uses_all.dates_positive_tolerance%TYPE;

1599: s_global_attribute_category hz_cust_site_uses_all.global_attribute_category%TYPE;
1600: s_primary_salesrep_id hz_cust_site_uses_all.primary_salesrep_id%TYPE;
1601: s_finchrg_receivables_trx_id hz_cust_site_uses_all.finchrg_receivables_trx_id%TYPE;
1602: s_dates_negative_tolerance hz_cust_site_uses_all.dates_negative_tolerance%TYPE;
1603: s_dates_positive_tolerance hz_cust_site_uses_all.dates_positive_tolerance%TYPE;
1604: s_date_type_preference hz_cust_site_uses_all.date_type_preference%TYPE;
1605: s_over_shipment_tolerance hz_cust_site_uses_all.over_shipment_tolerance%TYPE;
1606: s_under_shipment_tolerance hz_cust_site_uses_all.under_shipment_tolerance%TYPE;
1607: s_item_cross_ref_pref hz_cust_site_uses_all.item_cross_ref_pref%TYPE;

Line 1604: s_date_type_preference hz_cust_site_uses_all.date_type_preference%TYPE;

1600: s_primary_salesrep_id hz_cust_site_uses_all.primary_salesrep_id%TYPE;
1601: s_finchrg_receivables_trx_id hz_cust_site_uses_all.finchrg_receivables_trx_id%TYPE;
1602: s_dates_negative_tolerance hz_cust_site_uses_all.dates_negative_tolerance%TYPE;
1603: s_dates_positive_tolerance hz_cust_site_uses_all.dates_positive_tolerance%TYPE;
1604: s_date_type_preference hz_cust_site_uses_all.date_type_preference%TYPE;
1605: s_over_shipment_tolerance hz_cust_site_uses_all.over_shipment_tolerance%TYPE;
1606: s_under_shipment_tolerance hz_cust_site_uses_all.under_shipment_tolerance%TYPE;
1607: s_item_cross_ref_pref hz_cust_site_uses_all.item_cross_ref_pref%TYPE;
1608: s_over_return_tolerance hz_cust_site_uses_all.over_return_tolerance%TYPE;

Line 1605: s_over_shipment_tolerance hz_cust_site_uses_all.over_shipment_tolerance%TYPE;

1601: s_finchrg_receivables_trx_id hz_cust_site_uses_all.finchrg_receivables_trx_id%TYPE;
1602: s_dates_negative_tolerance hz_cust_site_uses_all.dates_negative_tolerance%TYPE;
1603: s_dates_positive_tolerance hz_cust_site_uses_all.dates_positive_tolerance%TYPE;
1604: s_date_type_preference hz_cust_site_uses_all.date_type_preference%TYPE;
1605: s_over_shipment_tolerance hz_cust_site_uses_all.over_shipment_tolerance%TYPE;
1606: s_under_shipment_tolerance hz_cust_site_uses_all.under_shipment_tolerance%TYPE;
1607: s_item_cross_ref_pref hz_cust_site_uses_all.item_cross_ref_pref%TYPE;
1608: s_over_return_tolerance hz_cust_site_uses_all.over_return_tolerance%TYPE;
1609: s_under_return_tolerance hz_cust_site_uses_all.under_return_tolerance%TYPE;

Line 1606: s_under_shipment_tolerance hz_cust_site_uses_all.under_shipment_tolerance%TYPE;

1602: s_dates_negative_tolerance hz_cust_site_uses_all.dates_negative_tolerance%TYPE;
1603: s_dates_positive_tolerance hz_cust_site_uses_all.dates_positive_tolerance%TYPE;
1604: s_date_type_preference hz_cust_site_uses_all.date_type_preference%TYPE;
1605: s_over_shipment_tolerance hz_cust_site_uses_all.over_shipment_tolerance%TYPE;
1606: s_under_shipment_tolerance hz_cust_site_uses_all.under_shipment_tolerance%TYPE;
1607: s_item_cross_ref_pref hz_cust_site_uses_all.item_cross_ref_pref%TYPE;
1608: s_over_return_tolerance hz_cust_site_uses_all.over_return_tolerance%TYPE;
1609: s_under_return_tolerance hz_cust_site_uses_all.under_return_tolerance%TYPE;
1610: s_ship_sets_include_lines_flag hz_cust_site_uses_all.ship_sets_include_lines_flag%TYPE;

Line 1607: s_item_cross_ref_pref hz_cust_site_uses_all.item_cross_ref_pref%TYPE;

1603: s_dates_positive_tolerance hz_cust_site_uses_all.dates_positive_tolerance%TYPE;
1604: s_date_type_preference hz_cust_site_uses_all.date_type_preference%TYPE;
1605: s_over_shipment_tolerance hz_cust_site_uses_all.over_shipment_tolerance%TYPE;
1606: s_under_shipment_tolerance hz_cust_site_uses_all.under_shipment_tolerance%TYPE;
1607: s_item_cross_ref_pref hz_cust_site_uses_all.item_cross_ref_pref%TYPE;
1608: s_over_return_tolerance hz_cust_site_uses_all.over_return_tolerance%TYPE;
1609: s_under_return_tolerance hz_cust_site_uses_all.under_return_tolerance%TYPE;
1610: s_ship_sets_include_lines_flag hz_cust_site_uses_all.ship_sets_include_lines_flag%TYPE;
1611: s_arv_include_lines_flag hz_cust_site_uses_all.arrivalsets_include_lines_flag%TYPE;

Line 1608: s_over_return_tolerance hz_cust_site_uses_all.over_return_tolerance%TYPE;

1604: s_date_type_preference hz_cust_site_uses_all.date_type_preference%TYPE;
1605: s_over_shipment_tolerance hz_cust_site_uses_all.over_shipment_tolerance%TYPE;
1606: s_under_shipment_tolerance hz_cust_site_uses_all.under_shipment_tolerance%TYPE;
1607: s_item_cross_ref_pref hz_cust_site_uses_all.item_cross_ref_pref%TYPE;
1608: s_over_return_tolerance hz_cust_site_uses_all.over_return_tolerance%TYPE;
1609: s_under_return_tolerance hz_cust_site_uses_all.under_return_tolerance%TYPE;
1610: s_ship_sets_include_lines_flag hz_cust_site_uses_all.ship_sets_include_lines_flag%TYPE;
1611: s_arv_include_lines_flag hz_cust_site_uses_all.arrivalsets_include_lines_flag%TYPE;
1612: s_sched_date_push_flag hz_cust_site_uses_all.sched_date_push_flag%TYPE;

Line 1609: s_under_return_tolerance hz_cust_site_uses_all.under_return_tolerance%TYPE;

1605: s_over_shipment_tolerance hz_cust_site_uses_all.over_shipment_tolerance%TYPE;
1606: s_under_shipment_tolerance hz_cust_site_uses_all.under_shipment_tolerance%TYPE;
1607: s_item_cross_ref_pref hz_cust_site_uses_all.item_cross_ref_pref%TYPE;
1608: s_over_return_tolerance hz_cust_site_uses_all.over_return_tolerance%TYPE;
1609: s_under_return_tolerance hz_cust_site_uses_all.under_return_tolerance%TYPE;
1610: s_ship_sets_include_lines_flag hz_cust_site_uses_all.ship_sets_include_lines_flag%TYPE;
1611: s_arv_include_lines_flag hz_cust_site_uses_all.arrivalsets_include_lines_flag%TYPE;
1612: s_sched_date_push_flag hz_cust_site_uses_all.sched_date_push_flag%TYPE;
1613: s_invoice_quantity_rule hz_cust_site_uses_all.invoice_quantity_rule%TYPE;

Line 1610: s_ship_sets_include_lines_flag hz_cust_site_uses_all.ship_sets_include_lines_flag%TYPE;

1606: s_under_shipment_tolerance hz_cust_site_uses_all.under_shipment_tolerance%TYPE;
1607: s_item_cross_ref_pref hz_cust_site_uses_all.item_cross_ref_pref%TYPE;
1608: s_over_return_tolerance hz_cust_site_uses_all.over_return_tolerance%TYPE;
1609: s_under_return_tolerance hz_cust_site_uses_all.under_return_tolerance%TYPE;
1610: s_ship_sets_include_lines_flag hz_cust_site_uses_all.ship_sets_include_lines_flag%TYPE;
1611: s_arv_include_lines_flag hz_cust_site_uses_all.arrivalsets_include_lines_flag%TYPE;
1612: s_sched_date_push_flag hz_cust_site_uses_all.sched_date_push_flag%TYPE;
1613: s_invoice_quantity_rule hz_cust_site_uses_all.invoice_quantity_rule%TYPE;
1614: s_pricing_event hz_cust_site_uses_all.pricing_event%TYPE;

Line 1611: s_arv_include_lines_flag hz_cust_site_uses_all.arrivalsets_include_lines_flag%TYPE;

1607: s_item_cross_ref_pref hz_cust_site_uses_all.item_cross_ref_pref%TYPE;
1608: s_over_return_tolerance hz_cust_site_uses_all.over_return_tolerance%TYPE;
1609: s_under_return_tolerance hz_cust_site_uses_all.under_return_tolerance%TYPE;
1610: s_ship_sets_include_lines_flag hz_cust_site_uses_all.ship_sets_include_lines_flag%TYPE;
1611: s_arv_include_lines_flag hz_cust_site_uses_all.arrivalsets_include_lines_flag%TYPE;
1612: s_sched_date_push_flag hz_cust_site_uses_all.sched_date_push_flag%TYPE;
1613: s_invoice_quantity_rule hz_cust_site_uses_all.invoice_quantity_rule%TYPE;
1614: s_pricing_event hz_cust_site_uses_all.pricing_event%TYPE;
1615: s_gl_id_rec hz_cust_site_uses_all.gl_id_rec%TYPE;

Line 1612: s_sched_date_push_flag hz_cust_site_uses_all.sched_date_push_flag%TYPE;

1608: s_over_return_tolerance hz_cust_site_uses_all.over_return_tolerance%TYPE;
1609: s_under_return_tolerance hz_cust_site_uses_all.under_return_tolerance%TYPE;
1610: s_ship_sets_include_lines_flag hz_cust_site_uses_all.ship_sets_include_lines_flag%TYPE;
1611: s_arv_include_lines_flag hz_cust_site_uses_all.arrivalsets_include_lines_flag%TYPE;
1612: s_sched_date_push_flag hz_cust_site_uses_all.sched_date_push_flag%TYPE;
1613: s_invoice_quantity_rule hz_cust_site_uses_all.invoice_quantity_rule%TYPE;
1614: s_pricing_event hz_cust_site_uses_all.pricing_event%TYPE;
1615: s_gl_id_rec hz_cust_site_uses_all.gl_id_rec%TYPE;
1616: s_gl_id_rev hz_cust_site_uses_all.gl_id_rev%TYPE;

Line 1613: s_invoice_quantity_rule hz_cust_site_uses_all.invoice_quantity_rule%TYPE;

1609: s_under_return_tolerance hz_cust_site_uses_all.under_return_tolerance%TYPE;
1610: s_ship_sets_include_lines_flag hz_cust_site_uses_all.ship_sets_include_lines_flag%TYPE;
1611: s_arv_include_lines_flag hz_cust_site_uses_all.arrivalsets_include_lines_flag%TYPE;
1612: s_sched_date_push_flag hz_cust_site_uses_all.sched_date_push_flag%TYPE;
1613: s_invoice_quantity_rule hz_cust_site_uses_all.invoice_quantity_rule%TYPE;
1614: s_pricing_event hz_cust_site_uses_all.pricing_event%TYPE;
1615: s_gl_id_rec hz_cust_site_uses_all.gl_id_rec%TYPE;
1616: s_gl_id_rev hz_cust_site_uses_all.gl_id_rev%TYPE;
1617: s_gl_id_tax hz_cust_site_uses_all.gl_id_tax%TYPE;

Line 1614: s_pricing_event hz_cust_site_uses_all.pricing_event%TYPE;

1610: s_ship_sets_include_lines_flag hz_cust_site_uses_all.ship_sets_include_lines_flag%TYPE;
1611: s_arv_include_lines_flag hz_cust_site_uses_all.arrivalsets_include_lines_flag%TYPE;
1612: s_sched_date_push_flag hz_cust_site_uses_all.sched_date_push_flag%TYPE;
1613: s_invoice_quantity_rule hz_cust_site_uses_all.invoice_quantity_rule%TYPE;
1614: s_pricing_event hz_cust_site_uses_all.pricing_event%TYPE;
1615: s_gl_id_rec hz_cust_site_uses_all.gl_id_rec%TYPE;
1616: s_gl_id_rev hz_cust_site_uses_all.gl_id_rev%TYPE;
1617: s_gl_id_tax hz_cust_site_uses_all.gl_id_tax%TYPE;
1618: s_gl_id_freight hz_cust_site_uses_all.gl_id_freight%TYPE;

Line 1615: s_gl_id_rec hz_cust_site_uses_all.gl_id_rec%TYPE;

1611: s_arv_include_lines_flag hz_cust_site_uses_all.arrivalsets_include_lines_flag%TYPE;
1612: s_sched_date_push_flag hz_cust_site_uses_all.sched_date_push_flag%TYPE;
1613: s_invoice_quantity_rule hz_cust_site_uses_all.invoice_quantity_rule%TYPE;
1614: s_pricing_event hz_cust_site_uses_all.pricing_event%TYPE;
1615: s_gl_id_rec hz_cust_site_uses_all.gl_id_rec%TYPE;
1616: s_gl_id_rev hz_cust_site_uses_all.gl_id_rev%TYPE;
1617: s_gl_id_tax hz_cust_site_uses_all.gl_id_tax%TYPE;
1618: s_gl_id_freight hz_cust_site_uses_all.gl_id_freight%TYPE;
1619: s_gl_id_clearing hz_cust_site_uses_all.gl_id_clearing%TYPE;

Line 1616: s_gl_id_rev hz_cust_site_uses_all.gl_id_rev%TYPE;

1612: s_sched_date_push_flag hz_cust_site_uses_all.sched_date_push_flag%TYPE;
1613: s_invoice_quantity_rule hz_cust_site_uses_all.invoice_quantity_rule%TYPE;
1614: s_pricing_event hz_cust_site_uses_all.pricing_event%TYPE;
1615: s_gl_id_rec hz_cust_site_uses_all.gl_id_rec%TYPE;
1616: s_gl_id_rev hz_cust_site_uses_all.gl_id_rev%TYPE;
1617: s_gl_id_tax hz_cust_site_uses_all.gl_id_tax%TYPE;
1618: s_gl_id_freight hz_cust_site_uses_all.gl_id_freight%TYPE;
1619: s_gl_id_clearing hz_cust_site_uses_all.gl_id_clearing%TYPE;
1620: s_gl_id_unbilled hz_cust_site_uses_all.gl_id_unbilled%TYPE;

Line 1617: s_gl_id_tax hz_cust_site_uses_all.gl_id_tax%TYPE;

1613: s_invoice_quantity_rule hz_cust_site_uses_all.invoice_quantity_rule%TYPE;
1614: s_pricing_event hz_cust_site_uses_all.pricing_event%TYPE;
1615: s_gl_id_rec hz_cust_site_uses_all.gl_id_rec%TYPE;
1616: s_gl_id_rev hz_cust_site_uses_all.gl_id_rev%TYPE;
1617: s_gl_id_tax hz_cust_site_uses_all.gl_id_tax%TYPE;
1618: s_gl_id_freight hz_cust_site_uses_all.gl_id_freight%TYPE;
1619: s_gl_id_clearing hz_cust_site_uses_all.gl_id_clearing%TYPE;
1620: s_gl_id_unbilled hz_cust_site_uses_all.gl_id_unbilled%TYPE;
1621: s_gl_id_unearned hz_cust_site_uses_all.gl_id_unearned%TYPE;

Line 1618: s_gl_id_freight hz_cust_site_uses_all.gl_id_freight%TYPE;

1614: s_pricing_event hz_cust_site_uses_all.pricing_event%TYPE;
1615: s_gl_id_rec hz_cust_site_uses_all.gl_id_rec%TYPE;
1616: s_gl_id_rev hz_cust_site_uses_all.gl_id_rev%TYPE;
1617: s_gl_id_tax hz_cust_site_uses_all.gl_id_tax%TYPE;
1618: s_gl_id_freight hz_cust_site_uses_all.gl_id_freight%TYPE;
1619: s_gl_id_clearing hz_cust_site_uses_all.gl_id_clearing%TYPE;
1620: s_gl_id_unbilled hz_cust_site_uses_all.gl_id_unbilled%TYPE;
1621: s_gl_id_unearned hz_cust_site_uses_all.gl_id_unearned%TYPE;
1622: s_gl_id_unpaid_rec hz_cust_site_uses_all.gl_id_unpaid_rec%TYPE;

Line 1619: s_gl_id_clearing hz_cust_site_uses_all.gl_id_clearing%TYPE;

1615: s_gl_id_rec hz_cust_site_uses_all.gl_id_rec%TYPE;
1616: s_gl_id_rev hz_cust_site_uses_all.gl_id_rev%TYPE;
1617: s_gl_id_tax hz_cust_site_uses_all.gl_id_tax%TYPE;
1618: s_gl_id_freight hz_cust_site_uses_all.gl_id_freight%TYPE;
1619: s_gl_id_clearing hz_cust_site_uses_all.gl_id_clearing%TYPE;
1620: s_gl_id_unbilled hz_cust_site_uses_all.gl_id_unbilled%TYPE;
1621: s_gl_id_unearned hz_cust_site_uses_all.gl_id_unearned%TYPE;
1622: s_gl_id_unpaid_rec hz_cust_site_uses_all.gl_id_unpaid_rec%TYPE;
1623: s_gl_id_remittance hz_cust_site_uses_all.gl_id_remittance%TYPE;

Line 1620: s_gl_id_unbilled hz_cust_site_uses_all.gl_id_unbilled%TYPE;

1616: s_gl_id_rev hz_cust_site_uses_all.gl_id_rev%TYPE;
1617: s_gl_id_tax hz_cust_site_uses_all.gl_id_tax%TYPE;
1618: s_gl_id_freight hz_cust_site_uses_all.gl_id_freight%TYPE;
1619: s_gl_id_clearing hz_cust_site_uses_all.gl_id_clearing%TYPE;
1620: s_gl_id_unbilled hz_cust_site_uses_all.gl_id_unbilled%TYPE;
1621: s_gl_id_unearned hz_cust_site_uses_all.gl_id_unearned%TYPE;
1622: s_gl_id_unpaid_rec hz_cust_site_uses_all.gl_id_unpaid_rec%TYPE;
1623: s_gl_id_remittance hz_cust_site_uses_all.gl_id_remittance%TYPE;
1624: s_gl_id_factor hz_cust_site_uses_all.gl_id_factor%TYPE;

Line 1621: s_gl_id_unearned hz_cust_site_uses_all.gl_id_unearned%TYPE;

1617: s_gl_id_tax hz_cust_site_uses_all.gl_id_tax%TYPE;
1618: s_gl_id_freight hz_cust_site_uses_all.gl_id_freight%TYPE;
1619: s_gl_id_clearing hz_cust_site_uses_all.gl_id_clearing%TYPE;
1620: s_gl_id_unbilled hz_cust_site_uses_all.gl_id_unbilled%TYPE;
1621: s_gl_id_unearned hz_cust_site_uses_all.gl_id_unearned%TYPE;
1622: s_gl_id_unpaid_rec hz_cust_site_uses_all.gl_id_unpaid_rec%TYPE;
1623: s_gl_id_remittance hz_cust_site_uses_all.gl_id_remittance%TYPE;
1624: s_gl_id_factor hz_cust_site_uses_all.gl_id_factor%TYPE;
1625: s_tax_classification hz_cust_site_uses_all.tax_classification%TYPE;

Line 1622: s_gl_id_unpaid_rec hz_cust_site_uses_all.gl_id_unpaid_rec%TYPE;

1618: s_gl_id_freight hz_cust_site_uses_all.gl_id_freight%TYPE;
1619: s_gl_id_clearing hz_cust_site_uses_all.gl_id_clearing%TYPE;
1620: s_gl_id_unbilled hz_cust_site_uses_all.gl_id_unbilled%TYPE;
1621: s_gl_id_unearned hz_cust_site_uses_all.gl_id_unearned%TYPE;
1622: s_gl_id_unpaid_rec hz_cust_site_uses_all.gl_id_unpaid_rec%TYPE;
1623: s_gl_id_remittance hz_cust_site_uses_all.gl_id_remittance%TYPE;
1624: s_gl_id_factor hz_cust_site_uses_all.gl_id_factor%TYPE;
1625: s_tax_classification hz_cust_site_uses_all.tax_classification%TYPE;
1626: s_last_update_date DATE;

Line 1623: s_gl_id_remittance hz_cust_site_uses_all.gl_id_remittance%TYPE;

1619: s_gl_id_clearing hz_cust_site_uses_all.gl_id_clearing%TYPE;
1620: s_gl_id_unbilled hz_cust_site_uses_all.gl_id_unbilled%TYPE;
1621: s_gl_id_unearned hz_cust_site_uses_all.gl_id_unearned%TYPE;
1622: s_gl_id_unpaid_rec hz_cust_site_uses_all.gl_id_unpaid_rec%TYPE;
1623: s_gl_id_remittance hz_cust_site_uses_all.gl_id_remittance%TYPE;
1624: s_gl_id_factor hz_cust_site_uses_all.gl_id_factor%TYPE;
1625: s_tax_classification hz_cust_site_uses_all.tax_classification%TYPE;
1626: s_last_update_date DATE;
1627: s_last_updated_by NUMBER;

Line 1624: s_gl_id_factor hz_cust_site_uses_all.gl_id_factor%TYPE;

1620: s_gl_id_unbilled hz_cust_site_uses_all.gl_id_unbilled%TYPE;
1621: s_gl_id_unearned hz_cust_site_uses_all.gl_id_unearned%TYPE;
1622: s_gl_id_unpaid_rec hz_cust_site_uses_all.gl_id_unpaid_rec%TYPE;
1623: s_gl_id_remittance hz_cust_site_uses_all.gl_id_remittance%TYPE;
1624: s_gl_id_factor hz_cust_site_uses_all.gl_id_factor%TYPE;
1625: s_tax_classification hz_cust_site_uses_all.tax_classification%TYPE;
1626: s_last_update_date DATE;
1627: s_last_updated_by NUMBER;
1628:

Line 1625: s_tax_classification hz_cust_site_uses_all.tax_classification%TYPE;

1621: s_gl_id_unearned hz_cust_site_uses_all.gl_id_unearned%TYPE;
1622: s_gl_id_unpaid_rec hz_cust_site_uses_all.gl_id_unpaid_rec%TYPE;
1623: s_gl_id_remittance hz_cust_site_uses_all.gl_id_remittance%TYPE;
1624: s_gl_id_factor hz_cust_site_uses_all.gl_id_factor%TYPE;
1625: s_tax_classification hz_cust_site_uses_all.tax_classification%TYPE;
1626: s_last_update_date DATE;
1627: s_last_updated_by NUMBER;
1628:
1629: CURSOR l_cust_site_use_csr IS

Line 2967: t_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;

2963: s_ADDRESSEE VARCHAR2(50) := NULL;
2964: s_shared_party_site VARCHAR2(1) := 'N';
2965: s_update_account_site VARCHAR2(1) := 'N';
2966: s_create_location_party_site VARCHAR2(1) := 'N';
2967: t_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;
2968: t_cust_acct_site_id hz_cust_site_uses_all.cust_acct_site_id%TYPE;
2969: t_primary_flag hz_cust_site_uses_all.primary_flag%TYPE;
2970: t_status hz_cust_site_uses_all.status%TYPE;
2971: t_address_id po_location_associations_all.address_id%TYPE;

Line 2968: t_cust_acct_site_id hz_cust_site_uses_all.cust_acct_site_id%TYPE;

2964: s_shared_party_site VARCHAR2(1) := 'N';
2965: s_update_account_site VARCHAR2(1) := 'N';
2966: s_create_location_party_site VARCHAR2(1) := 'N';
2967: t_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;
2968: t_cust_acct_site_id hz_cust_site_uses_all.cust_acct_site_id%TYPE;
2969: t_primary_flag hz_cust_site_uses_all.primary_flag%TYPE;
2970: t_status hz_cust_site_uses_all.status%TYPE;
2971: t_address_id po_location_associations_all.address_id%TYPE;
2972: t_site_loc_id hr_locations.location_id%TYPE;

Line 2969: t_primary_flag hz_cust_site_uses_all.primary_flag%TYPE;

2965: s_update_account_site VARCHAR2(1) := 'N';
2966: s_create_location_party_site VARCHAR2(1) := 'N';
2967: t_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;
2968: t_cust_acct_site_id hz_cust_site_uses_all.cust_acct_site_id%TYPE;
2969: t_primary_flag hz_cust_site_uses_all.primary_flag%TYPE;
2970: t_status hz_cust_site_uses_all.status%TYPE;
2971: t_address_id po_location_associations_all.address_id%TYPE;
2972: t_site_loc_id hr_locations.location_id%TYPE;
2973: t_orig_system_reference hz_locations.orig_system_reference%TYPE;

Line 2970: t_status hz_cust_site_uses_all.status%TYPE;

2966: s_create_location_party_site VARCHAR2(1) := 'N';
2967: t_site_use_id hz_cust_site_uses_all.site_use_id%TYPE;
2968: t_cust_acct_site_id hz_cust_site_uses_all.cust_acct_site_id%TYPE;
2969: t_primary_flag hz_cust_site_uses_all.primary_flag%TYPE;
2970: t_status hz_cust_site_uses_all.status%TYPE;
2971: t_address_id po_location_associations_all.address_id%TYPE;
2972: t_site_loc_id hr_locations.location_id%TYPE;
2973: t_orig_system_reference hz_locations.orig_system_reference%TYPE;
2974: t_last_update_date DATE;

Line 5282: FROM hz_cust_site_uses_all c_site_use,

5278: l_city_name VARCHAr2(240);
5279:
5280: CURSOR site_use_cur IS
5281: SELECT c_site_use.site_use_id, c_acct_site.cust_acct_site_id
5282: FROM hz_cust_site_uses_all c_site_use,
5283: hz_cust_acct_sites_all c_acct_site
5284: WHERE c_site_use.site_use_code = 'SHIP_TO'
5285: AND c_site_use.status = 'A'
5286: AND c_site_use.cust_acct_site_id = c_acct_site.cust_acct_site_id

Line 5635: select cust_acct_site_id from HZ_CUST_SITE_USES_ALL

5631: set bill_to_flag = 'Y',
5632: ship_to_flag = 'Y'
5633: where cust_account_id = l_customer_id
5634: and cust_acct_site_id = (
5635: select cust_acct_site_id from HZ_CUST_SITE_USES_ALL
5636: where site_use_id = l_old_site_use_id);
5637: ELSE
5638: return;
5639: END IF;

Line 5683: select cust_acct_site_id from HZ_CUST_SITE_USES_ALL

5679: set bill_to_flag = 'P',
5680: ship_to_flag = 'P'
5681: where cust_account_id = l_customer_id
5682: and cust_acct_site_id = (
5683: select cust_acct_site_id from HZ_CUST_SITE_USES_ALL
5684: where site_use_id = p_rs_site_use_id);
5685: ELSE
5686: return;
5687: END IF;

Line 5833: from hz_cust_site_uses_all

5829: temp_ship_to_use_id number;
5830:
5831: cursor get_cust_acct_site_uses is
5832: select site_use_id
5833: from hz_cust_site_uses_all
5834: where cust_acct_site_id = p_cust_site_id;
5835:
5836: cursor get_bill_site_id is
5837: select cust_acct_site_id

Line 5838: from HZ_CUST_SITE_USES_ALL

5834: where cust_acct_site_id = p_cust_site_id;
5835:
5836: cursor get_bill_site_id is
5837: select cust_acct_site_id
5838: from HZ_CUST_SITE_USES_ALL
5839: where site_use_code = 'BILL_TO'
5840: and site_use_id = v_ship_bill_site;
5841:
5842: cursor check_bill_to_location is

Line 5844: from HZ_CUST_SITE_USES_ALL orgu,

5840: and site_use_id = v_ship_bill_site;
5841:
5842: cursor check_bill_to_location is
5843: select newu.site_use_id
5844: from HZ_CUST_SITE_USES_ALL orgu,
5845: HZ_CUST_ACCT_SITES_ALL orgs,
5846: HZ_CUST_SITE_USES_ALL newu,
5847: HZ_CUST_ACCT_SITES_ALL news
5848: where orgu.site_use_code = 'BILL_TO'

Line 5846: HZ_CUST_SITE_USES_ALL newu,

5842: cursor check_bill_to_location is
5843: select newu.site_use_id
5844: from HZ_CUST_SITE_USES_ALL orgu,
5845: HZ_CUST_ACCT_SITES_ALL orgs,
5846: HZ_CUST_SITE_USES_ALL newu,
5847: HZ_CUST_ACCT_SITES_ALL news
5848: where orgu.site_use_code = 'BILL_TO'
5849: and orgu.site_use_id = v_ship_bill_site
5850: and orgu.cust_acct_site_id = orgs.cust_acct_site_id