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

Line 323: -- column of the pa_project_customers.

319:
320: -- Bug FIx 3049266
321: -- For the PA.K rollup patch certification we started making use of the customer account relationship feature.
322: -- From now on we will store the bill_to_customer_id i.e LOC customer id of an award in the bill_to_customer_id
323: -- column of the pa_project_customers.
324: -- We will not UPDATE teh record with the latest, by overriding the existing customer_id.
325: -- For this the columns bill_to_customer_id and ship_to_customer_id need to be defined as overridable.
326: -- This change can be done in the implementaitons form, but that forces us to come up with a data fix
327: -- for the existing implementations. So adding that check before creating an award. Thus we dont need any

Line 498: l_bill_to_customer_id PA_PROJECT_CUSTOMERS.BILL_TO_CUSTOMER_ID%TYPE := X_BILL_TO_CUSTOMER_ID ;

494: -- in the award project tempalte. Because of this Bug 3049266 is happening.
495: -- So passing NULL value to skip the error causing validation in the create_project procedure
496: -- in the pa_project_pub API.
497:
498: l_bill_to_customer_id PA_PROJECT_CUSTOMERS.BILL_TO_CUSTOMER_ID%TYPE := X_BILL_TO_CUSTOMER_ID ;
499: l_ship_to_customer_id PA_PROJECT_CUSTOMERS.SHIP_TO_CUSTOMER_ID%TYPE := X_BILL_TO_CUSTOMER_ID ;
500:
501: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_AWARD_PROJECT';
502:

Line 499: l_ship_to_customer_id PA_PROJECT_CUSTOMERS.SHIP_TO_CUSTOMER_ID%TYPE := X_BILL_TO_CUSTOMER_ID ;

495: -- So passing NULL value to skip the error causing validation in the create_project procedure
496: -- in the pa_project_pub API.
497:
498: l_bill_to_customer_id PA_PROJECT_CUSTOMERS.BILL_TO_CUSTOMER_ID%TYPE := X_BILL_TO_CUSTOMER_ID ;
499: l_ship_to_customer_id PA_PROJECT_CUSTOMERS.SHIP_TO_CUSTOMER_ID%TYPE := X_BILL_TO_CUSTOMER_ID ;
500:
501: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_AWARD_PROJECT';
502:
503: Cursor manager_active IS

Line 2726: /* Updating PA_PROJECT_CUSTOMERS with the Bill_To_Address_Id and Ship_To_Address_Id being used in Award Template */

2722: END IF;
2723: END IF;
2724:
2725: ---------------------------------------------------------------------------
2726: /* Updating PA_PROJECT_CUSTOMERS with the Bill_To_Address_Id and Ship_To_Address_Id being used in Award Template */
2727:
2728: G_Stage := '(140:Updating pa_project_customers)';
2729: IF X_Bill_To_Address_Id_IN IS NOT NULL THEN
2730: UPDATE PA_PROJECT_CUSTOMERS

Line 2728: G_Stage := '(140:Updating pa_project_customers)';

2724:
2725: ---------------------------------------------------------------------------
2726: /* Updating PA_PROJECT_CUSTOMERS with the Bill_To_Address_Id and Ship_To_Address_Id being used in Award Template */
2727:
2728: G_Stage := '(140:Updating pa_project_customers)';
2729: IF X_Bill_To_Address_Id_IN IS NOT NULL THEN
2730: UPDATE PA_PROJECT_CUSTOMERS
2731: set BILL_TO_ADDRESS_ID = X_Bill_To_Address_Id_IN
2732: ,LAST_UPDATE_DATE = SYSDATE

Line 2730: UPDATE PA_PROJECT_CUSTOMERS

2726: /* Updating PA_PROJECT_CUSTOMERS with the Bill_To_Address_Id and Ship_To_Address_Id being used in Award Template */
2727:
2728: G_Stage := '(140:Updating pa_project_customers)';
2729: IF X_Bill_To_Address_Id_IN IS NOT NULL THEN
2730: UPDATE PA_PROJECT_CUSTOMERS
2731: set BILL_TO_ADDRESS_ID = X_Bill_To_Address_Id_IN
2732: ,LAST_UPDATE_DATE = SYSDATE
2733: ,LAST_UPDATED_BY = fnd_global.user_id
2734: ,LAST_UPDATE_LOGIN = fnd_global.login_id

Line 2739: G_Stage := '(150:Updating pa_project_customers)';

2735: WHERE project_id = Store_Project_Id
2736: and customer_id = X_Customer_Id;
2737: END IF;
2738:
2739: G_Stage := '(150:Updating pa_project_customers)';
2740: IF X_Ship_To_Address_Id_IN IS NOT NULL THEN
2741: UPDATE PA_PROJECT_CUSTOMERS
2742: set SHIP_TO_ADDRESS_ID = X_Ship_To_Address_Id_IN
2743: ,LAST_UPDATE_DATE = SYSDATE

Line 2741: UPDATE PA_PROJECT_CUSTOMERS

2737: END IF;
2738:
2739: G_Stage := '(150:Updating pa_project_customers)';
2740: IF X_Ship_To_Address_Id_IN IS NOT NULL THEN
2741: UPDATE PA_PROJECT_CUSTOMERS
2742: set SHIP_TO_ADDRESS_ID = X_Ship_To_Address_Id_IN
2743: ,LAST_UPDATE_DATE = SYSDATE
2744: ,LAST_UPDATED_BY = fnd_global.user_id
2745: ,LAST_UPDATE_LOGIN = fnd_global.login_id

Line 3088: l_bill_to_customer_id pa_project_customers.bill_to_customer_id%TYPE := X_bill_to_customer_id;

3084: -- The issue is it is declared as %type that means it is number 15 and it is
3085: -- initialized with g_pa_miss_num which is initialized to a really big number
3086: -- so stopped initializing to the g_pa_miss_num.
3087:
3088: l_bill_to_customer_id pa_project_customers.bill_to_customer_id%TYPE := X_bill_to_customer_id;
3089: l_ship_to_customer_id pa_project_customers.ship_to_customer_id%TYPE := X_bill_to_customer_id ;
3090:
3091: --END Of fix 3062140
3092:

Line 3089: l_ship_to_customer_id pa_project_customers.ship_to_customer_id%TYPE := X_bill_to_customer_id ;

3085: -- initialized with g_pa_miss_num which is initialized to a really big number
3086: -- so stopped initializing to the g_pa_miss_num.
3087:
3088: l_bill_to_customer_id pa_project_customers.bill_to_customer_id%TYPE := X_bill_to_customer_id;
3089: l_ship_to_customer_id pa_project_customers.ship_to_customer_id%TYPE := X_bill_to_customer_id ;
3090:
3091: --END Of fix 3062140
3092:
3093: l_err_code NUMBER;