APPS.PA_RETENTION_UTIL dependencies on PA_PROJ_RETN_RULES

Line 597: DELETE FROM pa_proj_retn_rules

593: x_return_status := FND_API.G_RET_STS_SUCCESS;
594: x_msg_count := 0;
595: --dbms_output.put_line ('in delete retention rules');
596:
597: DELETE FROM pa_proj_retn_rules
598: WHERE project_id = p_project_id
599: AND customer_id = p_customer_id;
600:
601:

Line 657: DELETE FROM pa_proj_retn_rules

653: x_msg_count := 0;
654:
655: IF NVL(p_task_id, 0) = 0 then
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;

Line 664: DELETE FROM pa_proj_retn_rules

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
665: WHERE project_id = p_project_id
666: AND task_id = p_task_id;
667:
668: DELETE FROM pa_proj_retn_bill_rules

Line 728: from pa_proj_retn_rules

724: effective_start_date, effective_end_date,
725: retention_percentage, retention_amount, threshold_amount,
726: projfunc_total_retained, project_total_retained,
727: total_retained, revenue_category_code
728: from pa_proj_retn_rules
729: where project_id = l_fr_project_id
730: and customer_id = l_fr_customer_id;
731:
732: cursor bill_cur( l_fr_project_id number, l_fr_customer_id number) IS

Line 773: INSERT INTO pa_proj_retn_rules

769: x_msg_count => l_msg_count ,
770: x_msg_data => l_msg_data );
771:
772:
773: INSERT INTO pa_proj_retn_rules
774: (RETENTION_RULE_ID,
775: RETENTION_LEVEL_CODE,
776: PROJECT_ID,
777: CUSTOMER_ID,

Line 794: (pa_proj_retn_rules_s.nextval,

790: LAST_UPDATE_DATE ,
791: LAST_UPDATED_BY,
792: REVENUE_CATEGORY_CODE)
793: VALUES
794: (pa_proj_retn_rules_s.nextval,
795: retn_rec.retention_level_code,
796: p_to_project_id,
797: p_to_customer_id,
798: l_to_task_id,

Line 824: INSERT INTO pa_proj_retn_rules

820:
821: else
822: l_to_task_id := NULL;
823:
824: INSERT INTO pa_proj_retn_rules
825: (RETENTION_RULE_ID,
826: RETENTION_LEVEL_CODE,
827: PROJECT_ID,
828: CUSTOMER_ID,

Line 845: (pa_proj_retn_rules_s.nextval,

841: LAST_UPDATE_DATE ,
842: LAST_UPDATED_BY,
843: REVENUE_CATEGORY_CODE)
844: VALUES
845: (pa_proj_retn_rules_s.nextval,
846: retn_rec.retention_level_code,
847: p_to_project_id,
848: p_to_customer_id,
849: l_to_task_id,

Line 2399: FROM PA_PROJ_RETN_RULES

2395: l_Max_End_Date date;
2396:
2397: CURSOR Retention_Rules IS
2398: SELECT Effective_Start_Date, Effective_End_Date
2399: FROM PA_PROJ_RETN_RULES
2400: WHERE Project_ID = P_Project_ID
2401: AND NVL(Task_ID, -1) = NVL(P_Task_ID, -1)
2402: AND Customer_ID = P_Customer_ID
2403: AND Retention_Level_Code = P_Retention_Level_Code

Line 2655: DELETE FROM PA_PROJ_RETN_RULES

2651:
2652: X_Return_Status_Code := FND_API.G_RET_STS_SUCCESS; -- 'S';
2653:
2654: BEGIN
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

Line 2994: PA_PROJ_RETN_RULES

2990: INTO
2991: l_NonRetained_Count,
2992: l_Retained_Count
2993: FROM
2994: PA_PROJ_RETN_RULES
2995: WHERE
2996: Project_ID = P_Project_ID
2997: AND Customer_ID = P_Customer_ID;
2998: END;

Line 3065: FROM pa_proj_retn_rules rtn

3061: SELECT 1
3062: INTO l_retn_invfmt_error
3063: FROM dual
3064: WHERE EXISTS(SELECT null
3065: FROM pa_proj_retn_rules rtn
3066: WHERE rtn.project_id = p_project_id);
3067:
3068: IF l_retn_invfmt_error = 1 THEN
3069: IF NVL(p_retn_inv_fmt,0)<>0 THEN