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_RETENTION_UTIL dependencies on PA_PROJ_RETN_BILL_RULES

Line 602: DELETE FROM pa_proj_retn_bill_rules

598: WHERE project_id = p_project_id
599: AND customer_id = p_customer_id;
600:
601:
602: DELETE FROM pa_proj_retn_bill_rules
603: WHERE project_id = p_project_id
604: AND customer_id = p_customer_id;
605:
606:

Line 660: DELETE FROM pa_proj_retn_bill_rules

656:
657: DELETE FROM pa_proj_retn_rules
658: WHERE project_id = p_project_id;
659:
660: DELETE FROM pa_proj_retn_bill_rules
661: WHERE project_id = p_project_id;
662:
663: ELSE
664: DELETE FROM pa_proj_retn_rules

Line 668: DELETE FROM pa_proj_retn_bill_rules

664: DELETE FROM pa_proj_retn_rules
665: WHERE project_id = p_project_id
666: AND task_id = p_task_id;
667:
668: DELETE FROM pa_proj_retn_bill_rules
669: WHERE project_id = p_project_id
670: AND task_id = p_task_id;
671:
672: END IF;

Line 736: from pa_proj_retn_bill_rules

732: cursor bill_cur( l_fr_project_id number, l_fr_customer_id number) IS
733: select billing_method_code, task_id, completed_percentage,
734: total_retention_amount, retn_billing_cycle_id, client_extension_flag,
735: retn_billing_percentage, retn_billing_amount
736: from pa_proj_retn_bill_rules
737: where project_id = l_fr_project_id
738: and customer_id = l_fr_customer_id;
739:
740: l_to_task_id NUMBER;

Line 898: INSERT INTO pa_proj_retn_bill_rules

894: l_to_task_id := NULL;
895: end if;
896:
897: --dbms_output.put_line ('actual insertion');
898: INSERT INTO pa_proj_retn_bill_rules
899: ( RETN_BILLING_RULE_ID,
900: BILLING_METHOD_CODE,
901: PROJECT_ID,
902: CUSTOMER_ID,

Line 915: (pa_proj_retn_bill_rules_s.nextval,

911: CREATED_BY ,
912: LAST_UPDATE_DATE ,
913: LAST_UPDATED_BY)
914: VALUES
915: (pa_proj_retn_bill_rules_s.nextval,
916: bill_rec.billing_method_code,
917: p_to_project_id,
918: p_to_customer_id,
919: l_to_task_id,

Line 1681: DELETE FROM pa_proj_retn_bill_rules

1677: Delete the Old method from Table and Insert a Row with New Method
1678: ------------------------------------------------------------------ */
1679:
1680:
1681: DELETE FROM pa_proj_retn_bill_rules
1682: WHERE project_id = p_project_id
1683: AND nvl(task_id, -99) = nvl(p_task_id, -99)
1684: AND customer_id = p_customer_id ;
1685:

Line 1712: INSERT INTO pa_proj_retn_bill_rules

1708: IF ((p_billing_method_code = 'TOTAL_RETENTION_AMOUNT') OR (p_billing_method_code = 'RETENTION_BILLING_CYCLE')
1709: OR (p_billing_method_code = 'CLIENT_EXTENSION')) THEN
1710:
1711:
1712: INSERT INTO pa_proj_retn_bill_rules
1713: ( PROJECT_ID ,
1714: CUSTOMER_ID ,
1715: TASK_ID,
1716: BILLING_METHOD_CODE,

Line 1744: pa_proj_retn_bill_rules_s.nextval

1740: sysdate,
1741: -1,
1742: sysdate,
1743: -1,
1744: pa_proj_retn_bill_rules_s.nextval
1745: );
1746:
1747: END IF;
1748:

Line 1996: DELETE FROM pa_proj_retn_bill_rules

1992: /* ---------------------------------------------------------------
1993: Delete the Old Method from Database
1994: --------------------------------------------------------------- */
1995:
1996: DELETE FROM pa_proj_retn_bill_rules
1997: WHERE project_id = p_project_id
1998: AND nvl(task_id, -99) = nvl(p_task_id, -99)
1999: AND customer_id = p_customer_id ;
2000:

Line 2021: INSERT INTO pa_proj_retn_bill_rules

2017:
2018: FOR I IN 1 .. l_completed_percentage.COUNT
2019: LOOP
2020:
2021: INSERT INTO pa_proj_retn_bill_rules
2022: ( PROJECT_ID ,
2023: CUSTOMER_ID ,
2024: TASK_ID,
2025: BILLING_METHOD_CODE,

Line 2053: pa_proj_retn_bill_rules_s.nextval

2049: sysdate,
2050: -1,
2051: sysdate,
2052: -1,
2053: pa_proj_retn_bill_rules_s.nextval
2054: );
2055:
2056:
2057: END LOOP;

Line 2174: task already exists in pa_proj_retn_bill_rules table */

2170: l_message_code := NULL;
2171:
2172:
2173: /* If Retention Level is Task then validating the Task and also check this
2174: task already exists in pa_proj_retn_bill_rules table */
2175:
2176: IF (p_retention_level = 'T') THEN
2177:
2178:

Line 2319: FROM pa_proj_retn_bill_rules

2315:
2316:
2317: SELECT count(*)
2318: INTO l_bill_rec_count
2319: FROM pa_proj_retn_bill_rules
2320: WHERE project_id = p_project_id
2321: AND task_id = x_task_id
2322: AND customer_id = p_customer_id;
2323:

Line 2339: FROM pa_proj_retn_bill_rules

2335:
2336:
2337: SELECT count(*)
2338: INTO l_bill_rec_count
2339: FROM pa_proj_retn_bill_rules
2340: WHERE project_id = p_project_id
2341: AND customer_id = p_customer_id;
2342:
2343:

Line 2659: DELETE FROM PA_PROJ_RETN_BILL_RULES

2655: DELETE FROM PA_PROJ_RETN_RULES
2656: WHERE Project_ID = P_Project_ID
2657: AND Customer_ID = P_Customer_ID;
2658:
2659: DELETE FROM PA_PROJ_RETN_BILL_RULES
2660: WHERE Project_ID = P_Project_ID
2661: AND Customer_ID = P_Customer_ID;
2662:
2663: UPDATE PA_PROJECT_CUSTOMERS

Line 2717: PA_PROJ_RETN_BILL_RULES

2713:
2714: X_Return_Status_Code := FND_API.G_RET_STS_SUCCESS; -- 'S';
2715:
2716: DELETE FROM
2717: PA_PROJ_RETN_BILL_RULES
2718: WHERE
2719: RETN_BILLING_RULE_ID = P_Bill_Rule_ID ;
2720: COMMIT;
2721:

Line 2744: PA_PROJ_RETN_BILL_RULES

2740: 1
2741: INTO
2742: l_Exist_Flag
2743: FROM
2744: PA_PROJ_RETN_BILL_RULES
2745: WHERE
2746: Project_ID = P_Project_ID
2747: AND Customer_ID = P_Customer_ID
2748: AND RowNum < 2;

Line 3004: PA_PROJ_RETN_BILL_RULES

3000: BEGIN
3001: SELECT 1
3002: INTO l_Billing_Rules_Count
3003: FROM
3004: PA_PROJ_RETN_BILL_RULES
3005: WHERE
3006: Project_ID = P_Project_ID
3007: AND Customer_ID = P_Customer_ID
3008: AND RowNum < 2;