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.PA_PROJECT_PUB dependencies on PA_PROJECT_CUSTOMERS

Line 192: From pa_project_customers

188: inv_exchange_rate,
189: allow_inv_user_rate_type_flag,
190: bill_another_project_flag,
191: receiver_task_id
192: From pa_project_customers
193: Where customer_id = p_customer_id;
194:
195: -- IC and Multi National Currency changes Ends ...
196:

Line 496: l_project_relationship_code PA_PROJECT_CUSTOMERS.PROJECT_RELATIONSHIP_CODE%TYPE; --Variable added by aditi for tracking bug

492: -- 4193743 Added below local variables
493: l_bill_to_customer_id NUMBER;
494: l_ship_to_customer_id NUMBER;
495: l_enable_top_task_cust_flag VARCHAR2(1) := 'N'; --added for tracking bug by aditi
496: l_project_relationship_code PA_PROJECT_CUSTOMERS.PROJECT_RELATIONSHIP_CODE%TYPE; --Variable added by aditi for tracking bug
497:
498: -- 5191417 Added below cursor to validate priority_code
499:
500: l_valid_prio_code VARCHAR2(1) := 'N';

Line 678: FROM pa_project_customers

674:
675: CURSOR count_cust(p_project_id IN VARCHAR2)
676: IS
677: SELECT count(*)
678: FROM pa_project_customers
679: WHERE project_id = p_project_id;
680:
681: l_count_cust NUMBER := 0; -- bug# 12972554, Changed datatype of l_count_cust from VARCHAR2(1) TO NUMBER.
682:

Line 4176: UPDATE PA_PROJECT_CUSTOMERS

4172: RAISE FND_API.G_EXC_ERROR;
4173: END IF;
4174:
4175: -- Add the new project party ID to the customers row
4176: UPDATE PA_PROJECT_CUSTOMERS
4177: SET project_party_id = l_project_party_id
4178: WHERE project_id = l_project_id
4179: AND customer_id = l_in_customer_id; -- l_project_in_rec.customer_id; Tracking
4180: end if;

Line 5803: FROM pa_project_customers

5799: WHERE project_id = p_pa_project_id;
5800:
5801: CURSOR cur_check_proj_cust_exist (c_customer_id IN NUMBER ) IS
5802: SELECT 'Y'
5803: FROM pa_project_customers
5804: WHERE project_id = p_pa_project_id
5805: AND customer_id = c_customer_id ;
5806:
5807: --Added for bug 3746912

Line 9914: Select pa_project_customers.*

9910:
9911: /*Customer Account Relationships -CAR changes*/
9912:
9913: Cursor Cur_Customer(x_project_id NUMBER,l_customer_id in number) IS
9914: Select pa_project_customers.*
9915: From pa_project_customers
9916: where project_id=x_project_id
9917: and customer_id=l_customer_id;
9918:

Line 9915: From pa_project_customers

9911: /*Customer Account Relationships -CAR changes*/
9912:
9913: Cursor Cur_Customer(x_project_id NUMBER,l_customer_id in number) IS
9914: Select pa_project_customers.*
9915: From pa_project_customers
9916: where project_id=x_project_id
9917: and customer_id=l_customer_id;
9918:
9919: /*CAR changes end*/

Line 10206: l_project_relationship_code PA_PROJECT_CUSTOMERS.PROJECT_RELATIONSHIP_CODE%TYPE;

10202: l_ship_to_address_id NUMBER := NULL; --Initialized to NULL for Bug 3911782
10203: l_bill_to_contact_id NUMBER := NULL; --Initialized to NULL for tracking bug AMG API Gap Analysis : BUg 4153629
10204: l_ship_to_contact_id NUMBER := NULL; --Initialized to NULL for tracking bug AMG API Gap Analysis : BUg 4153629
10205: /* Variables sadded for tracking bug */
10206: l_project_relationship_code PA_PROJECT_CUSTOMERS.PROJECT_RELATIONSHIP_CODE%TYPE;
10207: l_customer_bill_split PA_PROJECT_CUSTOMERS.CUSTOMER_BILL_SPLIT%TYPE;
10208: l_customer_id NUMBER;
10209: l_msg_index_out NUMBER;
10210: tot_contribution NUMBER;

Line 10207: l_customer_bill_split PA_PROJECT_CUSTOMERS.CUSTOMER_BILL_SPLIT%TYPE;

10203: l_bill_to_contact_id NUMBER := NULL; --Initialized to NULL for tracking bug AMG API Gap Analysis : BUg 4153629
10204: l_ship_to_contact_id NUMBER := NULL; --Initialized to NULL for tracking bug AMG API Gap Analysis : BUg 4153629
10205: /* Variables sadded for tracking bug */
10206: l_project_relationship_code PA_PROJECT_CUSTOMERS.PROJECT_RELATIONSHIP_CODE%TYPE;
10207: l_customer_bill_split PA_PROJECT_CUSTOMERS.CUSTOMER_BILL_SPLIT%TYPE;
10208: l_customer_id NUMBER;
10209: l_msg_index_out NUMBER;
10210: tot_contribution NUMBER;
10211: /* Variables sadded for tracking bug */

Line 10841: FROM pa_project_customers

10837:
10838: CURSOR count_cust(p_project_id IN VARCHAR2)
10839: IS
10840: SELECT count(*)
10841: FROM pa_project_customers
10842: WHERE project_id = p_project_id;
10843:
10844: l_count_cust NUMBER := 0; -- bug# 12972554, Changed datatype of l_count_cust from VARCHAR2(1) TO NUMBER.
10845:

Line 19513: UPDATE pa_project_customers

19509:
19510: ELSE --customer id is not null and it is valid
19511:
19512:
19513: UPDATE pa_project_customers
19514: SET
19515: project_relationship_code = p_project_in.project_relationship_code
19516: WHERE
19517: customer_id = p_project_in.customer_id AND

Line 19740: Update Pa_project_customers

19736: END IF;
19737:
19738: /* Update the project customer information */
19739: ----dbms_output.put_line('before update ');
19740: Update Pa_project_customers
19741: Set bill_to_customer_id=l_bill_to_customer_id,
19742: ship_to_customer_id=l_ship_to_customer_id,
19743: Bill_To_Address_Id =l_bill_to_address_id,
19744: Ship_to_address_id =l_ship_to_address_id

Line 19827: --This API call will update pa_project_customers and pa_tasks

19823: end if;
19824: -- Bug 5622539
19825:
19826: IF hghst_ctr_cust_id IS NOT null THEN
19827: --This API call will update pa_project_customers and pa_tasks
19828: pa_top_task_cust_invoice_pvt.enbl_disbl_cust_at_top_task(
19829: P_API_VERSION => 1.0
19830: , P_INIT_MSG_LIST => 'T'
19831: , P_COMMIT => 'F'

Line 19875: cust_id PA_PROJECT_CUSTOMERS.customer_id%TYPE;

19871: --IF 'N' = p_project_in.enable_top_task_customer_flag AND 'Y' = l_project_rec.enable_top_task_customer_flag THEN -- 4188765 Commented
19872: IF 'N' = p_project_in.enable_top_task_customer_flag AND 'Y' = l_old_cust_top_task_flag THEN -- 4188765 Added
19873: --Disabling the customer at top task flag. Thus, we need to set the customer bill split for the project customers
19874: DECLARE
19875: cust_id PA_PROJECT_CUSTOMERS.customer_id%TYPE;
19876: hghst_ctr_cust_id NUMBER;
19877: hghst_ctr_cust_name hz_parties.party_name%TYPE; --VARCHAR2(50); Bug 5622539
19878: hghst_ctr_cust_num hz_parties.party_number%TYPE; --VARCHAR2(30); Bug 5622539
19879: -- num_customers NUMBER := 0; bug 5622539

Line 19887: FROM pa_project_customers

19883: l_msg_count NUMBER := 0;
19884: l_msg_data VARCHAR2(2000);
19885: CURSOR cur_get_def_top_task_cust IS
19886: SELECT customer_id
19887: FROM pa_project_customers
19888: WHERE project_id = l_project_id
19889: AND default_top_task_cust_flag = 'Y' ;
19890: BEGIN
19891: -- l_exclude_cust_id_tbl(1) := 0; Bug 5622539

Line 19937: --This API call will update pa_project_customers and pa_tasks

19933: FETCH cur_get_def_top_task_cust INTO cust_id;
19934: CLOSE cur_get_def_top_task_cust;
19935:
19936: IF hghst_ctr_cust_id IS NOT NULL THEN
19937: --This API call will update pa_project_customers and pa_tasks
19938: pa_top_task_cust_invoice_pvt.enbl_disbl_cust_at_top_task(
19939: P_API_VERSION => 1.0
19940: , P_INIT_MSG_LIST => 'T'
19941: , P_COMMIT => 'F'

Line 20392: Update Pa_project_customers

20388: END IF;
20389:
20390: /* Update the project customer information */
20391: /* The code below is also redundant for a new customer
20392: Update Pa_project_customers
20393: Set bill_to_customer_id=l_bill_to_customer_id,
20394: ship_to_customer_id=l_ship_to_customer_id,
20395: Bill_To_Address_Id =l_bill_to_address_id,
20396: Ship_to_address_id =l_ship_to_address_id

Line 20982: Update Pa_project_customers

20978: END IF;
20979:
20980: /* Update the project customer information */
20981:
20982: Update Pa_project_customers
20983: Set bill_to_customer_id=l_bill_to_customer_id,
20984: ship_to_customer_id=l_ship_to_customer_id,
20985: Bill_To_Address_Id =l_bill_to_address_id,
20986: Ship_to_address_id =l_ship_to_address_id

Line 21175: It will check if the customer already exists, then Insert into pa_project_customers will

21171: -- End of addition for bug 5554475
21172:
21173: /* Added Call to pa_customer_info.Create_Customer_Contacts. We only will be adding new contacts.
21174: There are no attrbutes that can be updated in a contact. Hence, the call below will suffice.
21175: It will check if the customer already exists, then Insert into pa_project_customers will
21176: be skipped and data will only be inserted into pa_project_contacts */
21177:
21178: pa_customer_info.Create_Customer_Contacts
21179: ( X_Project_Id => l_project_id,

Line 21371: --This API call will update pa_project_customers and pa_tasks

21367: , x_msg_count => l_msg_count
21368: , x_msg_data => l_msg_data );
21369:
21370: IF hghst_ctr_cust_id IS NOT null THEN
21371: --This API call will update pa_project_customers and pa_tasks
21372: pa_top_task_cust_invoice_pvt.enbl_disbl_cust_at_top_task(
21373: P_API_VERSION => 1.0
21374: , P_INIT_MSG_LIST => 'T'
21375: , P_COMMIT => 'F'

Line 21400: cust_id PA_PROJECT_CUSTOMERS.customer_id%TYPE;

21396: /* Commented the Below code for Bug 5622539
21397: IF 'N' = p_project_in.enable_top_task_customer_flag AND 'Y' = l_old_cust_top_task_flag THEN -- 4188765 Added
21398: --Disabling the customer at top task flag. Thus, we need to set the customer bill split for the project customers
21399: DECLARE
21400: cust_id PA_PROJECT_CUSTOMERS.customer_id%TYPE;
21401: hghst_ctr_cust_id NUMBER;
21402: hghst_ctr_cust_name VARCHAR2(50);
21403: hghst_ctr_cust_num VARCHAR2(30);
21404: num_customers NUMBER := 0;

Line 21412: FROM pa_project_customers

21408: l_msg_count NUMBER := 0;
21409: l_msg_data VARCHAR2(2000);
21410: CURSOR cur_get_def_top_task_cust IS
21411: SELECT customer_id
21412: FROM pa_project_customers
21413: WHERE project_id = l_project_id
21414: AND default_top_task_cust_flag = 'Y' ;
21415: BEGIN
21416: l_exclude_cust_id_tbl(1) := 0;

Line 21439: --This API call will update pa_project_customers and pa_tasks

21435: FETCH cur_get_def_top_task_cust INTO cust_id;
21436: CLOSE cur_get_def_top_task_cust;
21437:
21438: IF hghst_ctr_cust_id IS NOT NULL THEN
21439: --This API call will update pa_project_customers and pa_tasks
21440: pa_top_task_cust_invoice_pvt.enbl_disbl_cust_at_top_task(
21441: P_API_VERSION => 1.0
21442: , P_INIT_MSG_LIST => 'T'
21443: , P_COMMIT => 'F'

Line 21507: UPDATE pa_project_customers SET customer_bill_split = 100

21503:
21504:
21505: IF hghst_ctr_cust_id IS NOT NULL THEN
21506:
21507: UPDATE pa_project_customers SET customer_bill_split = 100
21508: WHERE customer_id = hghst_ctr_cust_id AND project_id = l_project_id;
21509:
21510: UPDATE pa_project_customers SET customer_bill_split = 0
21511: WHERE customer_id <> hghst_ctr_cust_id AND project_id = l_project_id;

Line 21510: UPDATE pa_project_customers SET customer_bill_split = 0

21506:
21507: UPDATE pa_project_customers SET customer_bill_split = 100
21508: WHERE customer_id = hghst_ctr_cust_id AND project_id = l_project_id;
21509:
21510: UPDATE pa_project_customers SET customer_bill_split = 0
21511: WHERE customer_id <> hghst_ctr_cust_id AND project_id = l_project_id;
21512: END IF;
21513: END IF;
21514:

Line 21518: UPDATE pa_project_customers SET customer_bill_split = null

21514:
21515:
21516: ELSE --enabling the federal flag
21517:
21518: UPDATE pa_project_customers SET customer_bill_split = null
21519: WHERE project_id = l_project_id;
21520:
21521:
21522: END IF;

Line 21534: UPDATE pa_project_customers SET customer_bill_split = null

21530: --The following will simply null out the bill split if either of the two flags are null.
21531:
21532: IF p_project_in.date_eff_funds_flag ='Y' OR p_project_in.enable_top_task_customer_flag = 'Y' THEN
21533:
21534: UPDATE pa_project_customers SET customer_bill_split = null
21535: WHERE project_id = l_project_id;
21536: END IF;
21537: --Sunkalya federal: bug#5511353.
21538:

Line 22811: FROM pa_project_customers

22807: WHERE project_id = c_project_id;
22808:
22809: CURSOR cur_check_proj_cust_exist (c_project_id IN NUMBER , c_customer_id IN NUMBER ) IS
22810: SELECT 'Y'
22811: FROM pa_project_customers
22812: WHERE project_id = c_project_id
22813: AND customer_id = c_customer_id ;
22814:
22815: CURSOR cur_get_def_top_task_cust(c_project_id IN NUMBER) IS

Line 22817: FROM pa_project_customers

22813: AND customer_id = c_customer_id ;
22814:
22815: CURSOR cur_get_def_top_task_cust(c_project_id IN NUMBER) IS
22816: SELECT customer_id
22817: FROM pa_project_customers
22818: WHERE project_id = c_project_id
22819: AND default_top_task_cust_flag = 'Y';
22820: -- Added This cursor for Bug No 4689326
22821: CURSOR l_cur_customer_name(l_customer_id NUMBER)