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 495: l_project_relationship_code PA_PROJECT_CUSTOMERS.PROJECT_RELATIONSHIP_CODE%TYPE; --Variable added by aditi for tracking bug

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

Line 645: FROM pa_project_customers

641:
642: CURSOR count_cust(p_project_id IN VARCHAR2)
643: IS
644: SELECT count(*)
645: FROM pa_project_customers
646: WHERE project_id = p_project_id;
647:
648: l_count_cust VARCHAR2(1) := NULL;
649:

Line 4090: UPDATE PA_PROJECT_CUSTOMERS

4086: RAISE FND_API.G_EXC_ERROR;
4087: END IF;
4088:
4089: -- Add the new project party ID to the customers row
4090: UPDATE PA_PROJECT_CUSTOMERS
4091: SET project_party_id = l_project_party_id
4092: WHERE project_id = l_project_id
4093: AND customer_id = l_in_customer_id; -- l_project_in_rec.customer_id; Tracking
4094: end if;

Line 5653: FROM pa_project_customers

5649: WHERE project_id = p_pa_project_id;
5650:
5651: CURSOR cur_check_proj_cust_exist (c_customer_id IN NUMBER ) IS
5652: SELECT 'Y'
5653: FROM pa_project_customers
5654: WHERE project_id = p_pa_project_id
5655: AND customer_id = c_customer_id ;
5656:
5657: --Added for bug 3746912

Line 9662: Select pa_project_customers.*

9658:
9659: /*Customer Account Relationships -CAR changes*/
9660:
9661: Cursor Cur_Customer(x_project_id NUMBER,l_customer_id in number) IS
9662: Select pa_project_customers.*
9663: From pa_project_customers
9664: where project_id=x_project_id
9665: and customer_id=l_customer_id;
9666:

Line 9663: From pa_project_customers

9659: /*Customer Account Relationships -CAR changes*/
9660:
9661: Cursor Cur_Customer(x_project_id NUMBER,l_customer_id in number) IS
9662: Select pa_project_customers.*
9663: From pa_project_customers
9664: where project_id=x_project_id
9665: and customer_id=l_customer_id;
9666:
9667: /*CAR changes end*/

Line 9945: l_project_relationship_code PA_PROJECT_CUSTOMERS.PROJECT_RELATIONSHIP_CODE%TYPE;

9941: l_ship_to_address_id NUMBER := NULL; --Initialized to NULL for Bug 3911782
9942: l_bill_to_contact_id NUMBER := NULL; --Initialized to NULL for tracking bug AMG API Gap Analysis : BUg 4153629
9943: l_ship_to_contact_id NUMBER := NULL; --Initialized to NULL for tracking bug AMG API Gap Analysis : BUg 4153629
9944: /* Variables sadded for tracking bug */
9945: l_project_relationship_code PA_PROJECT_CUSTOMERS.PROJECT_RELATIONSHIP_CODE%TYPE;
9946: l_customer_bill_split PA_PROJECT_CUSTOMERS.CUSTOMER_BILL_SPLIT%TYPE;
9947: l_customer_id NUMBER;
9948: l_msg_index_out NUMBER;
9949: tot_contribution NUMBER;

Line 9946: l_customer_bill_split PA_PROJECT_CUSTOMERS.CUSTOMER_BILL_SPLIT%TYPE;

9942: l_bill_to_contact_id NUMBER := NULL; --Initialized to NULL for tracking bug AMG API Gap Analysis : BUg 4153629
9943: l_ship_to_contact_id NUMBER := NULL; --Initialized to NULL for tracking bug AMG API Gap Analysis : BUg 4153629
9944: /* Variables sadded for tracking bug */
9945: l_project_relationship_code PA_PROJECT_CUSTOMERS.PROJECT_RELATIONSHIP_CODE%TYPE;
9946: l_customer_bill_split PA_PROJECT_CUSTOMERS.CUSTOMER_BILL_SPLIT%TYPE;
9947: l_customer_id NUMBER;
9948: l_msg_index_out NUMBER;
9949: tot_contribution NUMBER;
9950: /* Variables sadded for tracking bug */

Line 10574: FROM pa_project_customers

10570:
10571: CURSOR count_cust(p_project_id IN VARCHAR2)
10572: IS
10573: SELECT count(*)
10574: FROM pa_project_customers
10575: WHERE project_id = p_project_id;
10576:
10577: l_count_cust VARCHAR2(1) := NULL;
10578:

Line 19115: UPDATE pa_project_customers

19111:
19112: ELSE --customer id is not null and it is valid
19113:
19114:
19115: UPDATE pa_project_customers
19116: SET
19117: project_relationship_code = p_project_in.project_relationship_code
19118: WHERE
19119: customer_id = p_project_in.customer_id AND

Line 19342: Update Pa_project_customers

19338: END IF;
19339:
19340: /* Update the project customer information */
19341: ----dbms_output.put_line('before update ');
19342: Update Pa_project_customers
19343: Set bill_to_customer_id=l_bill_to_customer_id,
19344: ship_to_customer_id=l_ship_to_customer_id,
19345: Bill_To_Address_Id =l_bill_to_address_id,
19346: Ship_to_address_id =l_ship_to_address_id

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

19425: end if;
19426: -- Bug 5622539
19427:
19428: IF hghst_ctr_cust_id IS NOT null THEN
19429: --This API call will update pa_project_customers and pa_tasks
19430: pa_top_task_cust_invoice_pvt.enbl_disbl_cust_at_top_task(
19431: P_API_VERSION => 1.0
19432: , P_INIT_MSG_LIST => 'T'
19433: , P_COMMIT => 'F'

Line 19477: cust_id PA_PROJECT_CUSTOMERS.customer_id%TYPE;

19473: --IF 'N' = p_project_in.enable_top_task_customer_flag AND 'Y' = l_project_rec.enable_top_task_customer_flag THEN -- 4188765 Commented
19474: IF 'N' = p_project_in.enable_top_task_customer_flag AND 'Y' = l_old_cust_top_task_flag THEN -- 4188765 Added
19475: --Disabling the customer at top task flag. Thus, we need to set the customer bill split for the project customers
19476: DECLARE
19477: cust_id PA_PROJECT_CUSTOMERS.customer_id%TYPE;
19478: hghst_ctr_cust_id NUMBER;
19479: hghst_ctr_cust_name hz_parties.party_name%TYPE; --VARCHAR2(50); Bug 5622539
19480: hghst_ctr_cust_num hz_parties.party_number%TYPE; --VARCHAR2(30); Bug 5622539
19481: -- num_customers NUMBER := 0; bug 5622539

Line 19489: FROM pa_project_customers

19485: l_msg_count NUMBER := 0;
19486: l_msg_data VARCHAR2(2000);
19487: CURSOR cur_get_def_top_task_cust IS
19488: SELECT customer_id
19489: FROM pa_project_customers
19490: WHERE project_id = l_project_id
19491: AND default_top_task_cust_flag = 'Y' ;
19492: BEGIN
19493: -- l_exclude_cust_id_tbl(1) := 0; Bug 5622539

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

19535: FETCH cur_get_def_top_task_cust INTO cust_id;
19536: CLOSE cur_get_def_top_task_cust;
19537:
19538: IF hghst_ctr_cust_id IS NOT NULL THEN
19539: --This API call will update pa_project_customers and pa_tasks
19540: pa_top_task_cust_invoice_pvt.enbl_disbl_cust_at_top_task(
19541: P_API_VERSION => 1.0
19542: , P_INIT_MSG_LIST => 'T'
19543: , P_COMMIT => 'F'

Line 19991: Update Pa_project_customers

19987: END IF;
19988:
19989: /* Update the project customer information */
19990: /* The code below is also redundant for a new customer
19991: Update Pa_project_customers
19992: Set bill_to_customer_id=l_bill_to_customer_id,
19993: ship_to_customer_id=l_ship_to_customer_id,
19994: Bill_To_Address_Id =l_bill_to_address_id,
19995: Ship_to_address_id =l_ship_to_address_id

Line 20581: Update Pa_project_customers

20577: END IF;
20578:
20579: /* Update the project customer information */
20580:
20581: Update Pa_project_customers
20582: Set bill_to_customer_id=l_bill_to_customer_id,
20583: ship_to_customer_id=l_ship_to_customer_id,
20584: Bill_To_Address_Id =l_bill_to_address_id,
20585: Ship_to_address_id =l_ship_to_address_id

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

20770: -- End of addition for bug 5554475
20771:
20772: /* Added Call to pa_customer_info.Create_Customer_Contacts. We only will be adding new contacts.
20773: There are no attrbutes that can be updated in a contact. Hence, the call below will suffice.
20774: It will check if the customer already exists, then Insert into pa_project_customers will
20775: be skipped and data will only be inserted into pa_project_contacts */
20776:
20777: pa_customer_info.Create_Customer_Contacts
20778: ( X_Project_Id => l_project_id,

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

20966: , x_msg_count => l_msg_count
20967: , x_msg_data => l_msg_data );
20968:
20969: IF hghst_ctr_cust_id IS NOT null THEN
20970: --This API call will update pa_project_customers and pa_tasks
20971: pa_top_task_cust_invoice_pvt.enbl_disbl_cust_at_top_task(
20972: P_API_VERSION => 1.0
20973: , P_INIT_MSG_LIST => 'T'
20974: , P_COMMIT => 'F'

Line 20999: cust_id PA_PROJECT_CUSTOMERS.customer_id%TYPE;

20995: /* Commented the Below code for Bug 5622539
20996: IF 'N' = p_project_in.enable_top_task_customer_flag AND 'Y' = l_old_cust_top_task_flag THEN -- 4188765 Added
20997: --Disabling the customer at top task flag. Thus, we need to set the customer bill split for the project customers
20998: DECLARE
20999: cust_id PA_PROJECT_CUSTOMERS.customer_id%TYPE;
21000: hghst_ctr_cust_id NUMBER;
21001: hghst_ctr_cust_name VARCHAR2(50);
21002: hghst_ctr_cust_num VARCHAR2(30);
21003: num_customers NUMBER := 0;

Line 21011: FROM pa_project_customers

21007: l_msg_count NUMBER := 0;
21008: l_msg_data VARCHAR2(2000);
21009: CURSOR cur_get_def_top_task_cust IS
21010: SELECT customer_id
21011: FROM pa_project_customers
21012: WHERE project_id = l_project_id
21013: AND default_top_task_cust_flag = 'Y' ;
21014: BEGIN
21015: l_exclude_cust_id_tbl(1) := 0;

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

21034: FETCH cur_get_def_top_task_cust INTO cust_id;
21035: CLOSE cur_get_def_top_task_cust;
21036:
21037: IF hghst_ctr_cust_id IS NOT NULL THEN
21038: --This API call will update pa_project_customers and pa_tasks
21039: pa_top_task_cust_invoice_pvt.enbl_disbl_cust_at_top_task(
21040: P_API_VERSION => 1.0
21041: , P_INIT_MSG_LIST => 'T'
21042: , P_COMMIT => 'F'

Line 21106: UPDATE pa_project_customers SET customer_bill_split = 100

21102:
21103:
21104: IF hghst_ctr_cust_id IS NOT NULL THEN
21105:
21106: UPDATE pa_project_customers SET customer_bill_split = 100
21107: WHERE customer_id = hghst_ctr_cust_id AND project_id = l_project_id;
21108:
21109: UPDATE pa_project_customers SET customer_bill_split = 0
21110: WHERE customer_id <> hghst_ctr_cust_id AND project_id = l_project_id;

Line 21109: UPDATE pa_project_customers SET customer_bill_split = 0

21105:
21106: UPDATE pa_project_customers SET customer_bill_split = 100
21107: WHERE customer_id = hghst_ctr_cust_id AND project_id = l_project_id;
21108:
21109: UPDATE pa_project_customers SET customer_bill_split = 0
21110: WHERE customer_id <> hghst_ctr_cust_id AND project_id = l_project_id;
21111: END IF;
21112: END IF;
21113:

Line 21117: UPDATE pa_project_customers SET customer_bill_split = null

21113:
21114:
21115: ELSE --enabling the federal flag
21116:
21117: UPDATE pa_project_customers SET customer_bill_split = null
21118: WHERE project_id = l_project_id;
21119:
21120:
21121: END IF;

Line 21133: UPDATE pa_project_customers SET customer_bill_split = null

21129: --The following will simply null out the bill split if either of the two flags are null.
21130:
21131: IF p_project_in.date_eff_funds_flag ='Y' OR p_project_in.enable_top_task_customer_flag = 'Y' THEN
21132:
21133: UPDATE pa_project_customers SET customer_bill_split = null
21134: WHERE project_id = l_project_id;
21135: END IF;
21136: --Sunkalya federal: bug#5511353.
21137:

Line 22344: FROM pa_project_customers

22340: WHERE project_id = c_project_id;
22341:
22342: CURSOR cur_check_proj_cust_exist (c_project_id IN NUMBER , c_customer_id IN NUMBER ) IS
22343: SELECT 'Y'
22344: FROM pa_project_customers
22345: WHERE project_id = c_project_id
22346: AND customer_id = c_customer_id ;
22347:
22348: CURSOR cur_get_def_top_task_cust(c_project_id IN NUMBER) IS

Line 22350: FROM pa_project_customers

22346: AND customer_id = c_customer_id ;
22347:
22348: CURSOR cur_get_def_top_task_cust(c_project_id IN NUMBER) IS
22349: SELECT customer_id
22350: FROM pa_project_customers
22351: WHERE project_id = c_project_id
22352: AND default_top_task_cust_flag = 'Y';
22353: -- Added This cursor for Bug No 4689326
22354: CURSOR l_cur_customer_name(l_customer_id NUMBER)