DBA Data[Home] [Help]

APPS.JTF_TASKS_PUB dependencies on HZ_PARTY_SITES

Line 667: l_address_id hz_party_sites.party_site_id%TYPE := p_address_id;

663: l_cust_account_number hz_cust_accounts.account_number%TYPE := p_cust_account_number;
664: l_cust_account_id hz_cust_accounts.cust_account_id%TYPE := p_cust_account_id;
665: l_customer_id hz_parties.party_id%TYPE := p_customer_id;
666: l_customer_number hz_parties.party_number%TYPE := p_customer_number;
667: l_address_id hz_party_sites.party_site_id%TYPE := p_address_id;
668: l_location_id hz_locations.location_id%TYPE := p_location_id;
669: l_address_number hz_party_sites.party_site_number%TYPE := p_address_number;
670: l_parent_task_id jtf_tasks_b.task_id%TYPE := p_parent_task_id;
671: l_parent_task_number jtf_tasks_b.task_number%TYPE := p_parent_task_number;

Line 669: l_address_number hz_party_sites.party_site_number%TYPE := p_address_number;

665: l_customer_id hz_parties.party_id%TYPE := p_customer_id;
666: l_customer_number hz_parties.party_number%TYPE := p_customer_number;
667: l_address_id hz_party_sites.party_site_id%TYPE := p_address_id;
668: l_location_id hz_locations.location_id%TYPE := p_location_id;
669: l_address_number hz_party_sites.party_site_number%TYPE := p_address_number;
670: l_parent_task_id jtf_tasks_b.task_id%TYPE := p_parent_task_id;
671: l_parent_task_number jtf_tasks_b.task_number%TYPE := p_parent_task_number;
672: l_source_object_type_code jtf_tasks_b.source_object_type_code%TYPE := p_source_object_type_code;
673: l_source_object_id jtf_tasks_b.source_object_id%TYPE := p_source_object_id;

Line 1798: , ---- hz_party_sites

1794: p_customer_id IN NUMBER DEFAULT NULL
1795: , p_cust_account_number IN VARCHAR2 DEFAULT NULL
1796: , p_cust_account_id IN NUMBER DEFAULT NULL
1797: , p_address_id IN NUMBER DEFAULT NULL
1798: , ---- hz_party_sites
1799: p_address_number IN VARCHAR2 DEFAULT NULL
1800: , p_planned_start_date IN DATE DEFAULT NULL
1801: , p_planned_end_date IN DATE DEFAULT NULL
1802: , p_scheduled_start_date IN DATE DEFAULT NULL

Line 2936: l_address_id hz_party_sites.party_site_id%TYPE;

2932: l_customer_id hz_parties.party_id%TYPE;
2933: l_customer_number hz_parties.party_number%TYPE;
2934: l_cust_account_id hz_cust_accounts.cust_account_id%TYPE;
2935: l_cust_account_number hz_cust_accounts.account_number%TYPE;
2936: l_address_id hz_party_sites.party_site_id%TYPE;
2937: l_location_id hz_locations.location_id%TYPE;
2938: l_address_number hz_party_sites.party_site_number%TYPE;
2939: l_planned_start_date DATE;
2940: l_planned_end_date DATE;

Line 2938: l_address_number hz_party_sites.party_site_number%TYPE;

2934: l_cust_account_id hz_cust_accounts.cust_account_id%TYPE;
2935: l_cust_account_number hz_cust_accounts.account_number%TYPE;
2936: l_address_id hz_party_sites.party_site_id%TYPE;
2937: l_location_id hz_locations.location_id%TYPE;
2938: l_address_number hz_party_sites.party_site_number%TYPE;
2939: l_planned_start_date DATE;
2940: l_planned_end_date DATE;
2941: l_scheduled_start_date DATE;
2942: l_scheduled_end_date DATE;