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_CUSTOMERS_CONTACTS_PVT dependencies on PA_PROJECT_CUSTOMERS

Line 66: l_bill_another_project_flag pa_project_customers.bill_another_project_flag%TYPE;

62: --Billing setup related changes for FP_M development. Tracking bug 3279981
63: ,p_Default_Top_Task_Cust_Flag IN VARCHAR2
64: )
65: IS
66: l_bill_another_project_flag pa_project_customers.bill_another_project_flag%TYPE;
67: l_msg_count NUMBER;
68: l_last_update_date DATE;
69: l_last_updated_by NUMBER(15);
70: l_creation_date DATE;

Line 196: PA_PROJECT_CUSTOMERS_PKG.INSERT_ROW

192: end if;
193:
194: if p_validate_only <> FND_API.G_TRUE then
195:
196: PA_PROJECT_CUSTOMERS_PKG.INSERT_ROW
197: ( X_Rowid => l_rowid
198: ,X_Project_Id => p_project_id
199: ,X_Customer_Id => p_customer_id
200: ,X_Last_Update_Date => l_last_update_date

Line 225: -- In this case, just update pa_project_customers with this

221:
222: -- anlee org role changes
223: -- If p_project_party_id is not null, then this API has been
224: -- called from org details flow
225: -- In this case, just update pa_project_customers with this
226: -- project_party_id
227: if p_project_party_id is not null then
228: UPDATE PA_PROJECT_CUSTOMERS
229: SET project_party_id = p_project_party_id

Line 228: UPDATE PA_PROJECT_CUSTOMERS

224: -- called from org details flow
225: -- In this case, just update pa_project_customers with this
226: -- project_party_id
227: if p_project_party_id is not null then
228: UPDATE PA_PROJECT_CUSTOMERS
229: SET project_party_id = p_project_party_id
230: WHERE rowid = l_rowid;
231: else
232: -- Not from org details flow

Line 283: UPDATE PA_PROJECT_CUSTOMERS

279: raise FND_API.G_EXC_ERROR;
280: end if;
281:
282: -- Add the new project party ID to the customers row
283: UPDATE PA_PROJECT_CUSTOMERS
284: SET project_party_id = l_project_party_id
285: WHERE rowid = l_rowid;
286: else
287: -- Add the existing project party ID to the customers row

Line 288: UPDATE PA_PROJECT_CUSTOMERS

284: SET project_party_id = l_project_party_id
285: WHERE rowid = l_rowid;
286: else
287: -- Add the existing project party ID to the customers row
288: UPDATE PA_PROJECT_CUSTOMERS
289: SET project_party_id = l_temp
290: WHERE rowid = l_rowid;
291: end if;
292: end if;

Line 384: l_bill_another_project_flag pa_project_customers.bill_another_project_flag%TYPE;

380: --Billing setup related changes for FP_M development. Tracking bug 3279981
381: ,p_Default_Top_Task_Cust_Flag IN VARCHAR2
382: )
383: IS
384: l_bill_another_project_flag pa_project_customers.bill_another_project_flag%TYPE;
385: l_msg_count NUMBER;
386: l_msg_data VARCHAR(250);
387: l_last_update_date DATE;
388: l_last_updated_by NUMBER(15);

Line 402: FROM pa_project_customers

398: l_receiver_task_id NUMBER;
399:
400: CURSOR C (c_project_id NUMBER, c_customer_id NUMBER) IS
401: SELECT rowid
402: FROM pa_project_customers
403: WHERE project_id = c_project_id AND
404: customer_id = c_customer_id;
405:
406: BEGIN

Line 426: FROM pa_project_customers

422:
423: if p_validate_only <> FND_API.G_TRUE then
424: BEGIN
425: SELECT 'x' INTO l_dummy
426: FROM pa_project_customers
427: WHERE project_id = p_project_id
428: AND customer_id = p_customer_id
429: AND record_version_number = p_record_version_number
430: FOR UPDATE OF record_version_number NOWAIT;

Line 464: FROM pa_project_customers

460: --dbms_output.put_line('control wil come till here - print p_record_version_number'||p_record_version_number);
461:
462: BEGIN
463: SELECT 'x' INTO l_dummy
464: FROM pa_project_customers
465: WHERE project_id = p_project_id
466: AND customer_id = p_customer_id
467: AND record_version_number = p_record_version_number;
468: EXCEPTION

Line 601: PA_PROJECT_CUSTOMERS_PKG.UPDATE_ROW

597: IF (p_calling_module = 'AMG') THEN
598: l_bill_another_project_flag := p_bill_another_project_flag; -- aDDED FOR TRACKING bug
599: End If;
600: /* End of changes for tracking bug 4153629*/
601: PA_PROJECT_CUSTOMERS_PKG.UPDATE_ROW
602: ( X_Rowid => l_rowid
603: ,X_Project_Id => p_project_id
604: ,X_Customer_Id => p_customer_id
605: ,X_Last_Update_Date => l_last_update_date

Line 686: l_bill_another_project_flag pa_project_customers.bill_another_project_flag%TYPE;

682: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
683: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
684: )
685: IS
686: l_bill_another_project_flag pa_project_customers.bill_another_project_flag%TYPE;
687: l_return_status VARCHAR2(1);
688: l_msg_count NUMBER;
689: l_msg_data VARCHAR2(250);
690: l_rowid VARCHAR2(250);

Line 693: l_project_party_id pa_project_customers.project_party_id%TYPE;

689: l_msg_data VARCHAR2(250);
690: l_rowid VARCHAR2(250);
691: l_dummy VARCHAR2(1);
692: /* Variables declared for bug 3101990 */
693: l_project_party_id pa_project_customers.project_party_id%TYPE;
694: l_ext_people_exists pa_project_customers.project_party_id%TYPE;
695: l_billing_accnt_exists pa_project_customers.project_party_id%TYPE;
696:
697: CURSOR C (c_project_id NUMBER, c_customer_id NUMBER) IS

Line 694: l_ext_people_exists pa_project_customers.project_party_id%TYPE;

690: l_rowid VARCHAR2(250);
691: l_dummy VARCHAR2(1);
692: /* Variables declared for bug 3101990 */
693: l_project_party_id pa_project_customers.project_party_id%TYPE;
694: l_ext_people_exists pa_project_customers.project_party_id%TYPE;
695: l_billing_accnt_exists pa_project_customers.project_party_id%TYPE;
696:
697: CURSOR C (c_project_id NUMBER, c_customer_id NUMBER) IS
698: SELECT rowid

Line 695: l_billing_accnt_exists pa_project_customers.project_party_id%TYPE;

691: l_dummy VARCHAR2(1);
692: /* Variables declared for bug 3101990 */
693: l_project_party_id pa_project_customers.project_party_id%TYPE;
694: l_ext_people_exists pa_project_customers.project_party_id%TYPE;
695: l_billing_accnt_exists pa_project_customers.project_party_id%TYPE;
696:
697: CURSOR C (c_project_id NUMBER, c_customer_id NUMBER) IS
698: SELECT rowid
699: FROM pa_project_customers

Line 699: FROM pa_project_customers

695: l_billing_accnt_exists pa_project_customers.project_party_id%TYPE;
696:
697: CURSOR C (c_project_id NUMBER, c_customer_id NUMBER) IS
698: SELECT rowid
699: FROM pa_project_customers
700: WHERE project_id = c_project_id AND
701: customer_id = c_customer_id;
702:
703: /* 3 new cursors defined for bug 3101990 */

Line 707: FROM pa_project_customers

703: /* 3 new cursors defined for bug 3101990 */
704:
705: CURSOR get_project_party_id IS
706: SELECT project_party_id
707: FROM pa_project_customers
708: WHERE project_id = p_project_id AND
709: customer_id = p_customer_id;
710:
711: -- 4616302 TCA UPTAKE: HZ_PARTY_RELATIONS IMPACTS

Line 752: FROM pa_project_customers

748: -- 4616302 end
749:
750: CURSOR c_billing_accnt_exists(c_project_party_id NUMBER) IS
751: SELECT project_party_id
752: FROM pa_project_customers
753: WHERE project_id = p_project_id
754: AND project_party_id = c_project_party_id
755: AND customer_id <> p_customer_id;
756:

Line 775: FROM pa_project_customers

771:
772: if p_validate_only <> FND_API.G_TRUE then
773: BEGIN
774: SELECT 'x' INTO l_dummy
775: FROM pa_project_customers
776: WHERE project_id = p_project_id
777: AND customer_id = p_customer_id
778: AND record_version_number = p_record_version_number
779: FOR UPDATE OF record_version_number NOWAIT;

Line 807: FROM pa_project_customers

803: END;
804: else
805: BEGIN
806: SELECT 'x' INTO l_dummy
807: FROM pa_project_customers
808: WHERE project_id = p_project_id
809: AND customer_id = p_customer_id
810: AND record_version_number = p_record_version_number;
811: EXCEPTION

Line 942: PA_PROJECT_CUSTOMERS_PKG.DELETE_ROW(l_rowid, p_record_version_number);

938: open C(p_project_id, p_customer_id);
939: fetch C into l_rowid;
940: close C;
941:
942: PA_PROJECT_CUSTOMERS_PKG.DELETE_ROW(l_rowid, p_record_version_number);
943: end if;
944:
945: x_return_status := FND_API.G_RET_STS_SUCCESS;
946: