APPS.JTF_TASKS_PUB dependencies on HZ_PARTIES

Line 665: l_customer_id hz_parties.party_id%TYPE := p_customer_id;

661: l_assigned_by_name fnd_user.user_name%TYPE := p_assigned_by_name;
662: l_assigned_by_id NUMBER := p_assigned_by_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;

Line 666: l_customer_number hz_parties.party_number%TYPE := p_customer_number;

662: l_assigned_by_id NUMBER := p_assigned_by_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;

Line 1793: , -- from hz_parties

1789: , p_owner_territory_id IN NUMBER DEFAULT NULL
1790: , p_assigned_by_name IN VARCHAR2 DEFAULT NULL
1791: , p_assigned_by_id IN NUMBER DEFAULT NULL
1792: , p_customer_number IN VARCHAR2 DEFAULT NULL
1793: , -- from hz_parties
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

Line 2932: l_customer_id hz_parties.party_id%TYPE;

2928: l_task_priority_name jtf_task_priorities_tl.NAME%TYPE := p_task_priority_name;
2929: l_task_priority_id jtf_task_priorities_b.task_priority_id%TYPE := p_task_priority_id;
2930: l_assigned_by_name fnd_user.user_name%TYPE := p_assigned_by_name;
2931: l_assigned_by_id NUMBER := p_assigned_by_id;
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;

Line 2933: l_customer_number hz_parties.party_number%TYPE;

2929: l_task_priority_id jtf_task_priorities_b.task_priority_id%TYPE := p_task_priority_id;
2930: l_assigned_by_name fnd_user.user_name%TYPE := p_assigned_by_name;
2931: l_assigned_by_id NUMBER := p_assigned_by_id;
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;

Line 5398: FROM hz_parties

5394: , p_customer_number IN jtf_tasks_v.customer_number%TYPE
5395: ) IS
5396: CURSOR c1 IS
5397: SELECT party_id
5398: FROM hz_parties
5399: WHERE party_name = p_customer_name;
5400:
5401: CURSOR c2 IS
5402: SELECT party_id

Line 5403: FROM hz_parties

5399: WHERE party_name = p_customer_name;
5400:
5401: CURSOR c2 IS
5402: SELECT party_id
5403: FROM hz_parties
5404: WHERE party_number = p_customer_number;
5405: BEGIN
5406: IF (p_customer_number IS NOT NULL) THEN
5407: OPEN c2;