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_INVOICE_ACTIONS dependencies on PA_DRAFT_INVOICES_ALL

Line 8: | PA_DRAFT_INVOICES_ALL table with invoice approval columns |

4: /*----------------- Private Procedure/Function Declarations -----------------*/
5:
6: /*----------------------------------------------------------------------------+
7: | This Private Procedure Update_Approve_Invoices Updates |
8: | PA_DRAFT_INVOICES_ALL table with invoice approval columns |
9: +----------------------------------------------------------------------------*/
10: Procedure Update_Approve_Invoices ( P_Project_ID in number,
11: P_Draft_Invoice_Num in number,
12: P_User_ID in number,

Line 16: UPDATE PA_Draft_Invoices_ALL

12: P_User_ID in number,
13: P_Employee_ID in number) is
14: BEGIN
15:
16: UPDATE PA_Draft_Invoices_ALL
17: SET Approved_Date = sysdate,
18: Approved_by_person_id = P_Employee_ID,
19: Last_Update_Date = sysdate,
20: Last_Updated_By = P_User_ID

Line 31: | PA_DRAFT_INVOICES_ALL table with invoice approval columns as NULL |

27: END Update_Approve_Invoices;
28:
29: /*----------------------------------------------------------------------------+
30: | This Private Procedure Update_Unapprove_Invoices Updates |
31: | PA_DRAFT_INVOICES_ALL table with invoice approval columns as NULL |
32: +----------------------------------------------------------------------------*/
33: Procedure Update_Unapprove_Invoices ( P_Invoice_Set_ID in number,
34: P_User_ID in number) is
35: BEGIN

Line 37: UPDATE PA_Draft_Invoices_ALL

33: Procedure Update_Unapprove_Invoices ( P_Invoice_Set_ID in number,
34: P_User_ID in number) is
35: BEGIN
36:
37: UPDATE PA_Draft_Invoices_ALL
38: SET Approved_Date = NULL,
39: Approved_by_person_id = NULL,
40: Released_Date = NULL,
41: Released_by_person_id = NULL,

Line 55: | PA_DRAFT_INVOICES_ALL table with invoice Release attributes |

51: END Update_Unapprove_Invoices;
52:
53: /*----------------------------------------------------------------------------+
54: | This Private Procedure Update_Release_Invoices Updates |
55: | PA_DRAFT_INVOICES_ALL table with invoice Release attributes |
56: +----------------------------------------------------------------------------*/
57: Procedure Update_Release_Invoices ( P_Project_ID in number,
58: P_Draft_Invoice_Num in number,
59: P_RA_Invoice_Date in date,

Line 66: UPDATE PA_Draft_Invoices_ALL

62: P_Employee_ID in number,
63: P_Credit_Memo_Reason_Code in varchar2) is
64: BEGIN
65:
66: UPDATE PA_Draft_Invoices_ALL
67: SET Released_Date = sysdate,
68: Released_by_person_id = P_Employee_ID,
69: RA_Invoice_Number = P_RA_Invoice_Num,
70: Invoice_Date = P_RA_Invoice_Date,

Line 86: | PA_DRAFT_INVOICES_ALL table with invoice Release attributes as NULL |

82:
83:
84: /*----------------------------------------------------------------------------+
85: | This Private Procedure Update_Unrelease_Invoices Updates |
86: | PA_DRAFT_INVOICES_ALL table with invoice Release attributes as NULL |
87: +----------------------------------------------------------------------------*/
88: Procedure Update_Unrelease_Invoices ( P_Invoice_Set_ID in number,
89: P_User_ID in number) is
90: BEGIN

Line 92: UPDATE PA_Draft_Invoices_ALL

88: Procedure Update_Unrelease_Invoices ( P_Invoice_Set_ID in number,
89: P_User_ID in number) is
90: BEGIN
91:
92: UPDATE PA_Draft_Invoices_ALL
93: SET Released_Date = NULL,
94: Released_by_person_id = NULL,
95: RA_Invoice_Number = NULL,
96: Invoice_Date = NULL,

Line 158: FROM PA_Draft_Invoices_ALL

154: CREATION_DATE, CREATED_BY, REQUEST_ID, WARNING_MESSAGE
155: )
156: SELECT Project_ID, Draft_Invoice_Num, sysdate, P_User_ID,
157: sysdate, P_User_ID, P_Request_ID, l_error_message
158: FROM PA_Draft_Invoices_ALL
159: WHERE Invoice_Set_ID = P_Invoice_Set_ID;
160:
161: END IF;
162:

Line 604: FROM pa_draft_invoices_all cm, pa_draft_invoices_all i

600: /* Crediting Inv Date should be greater than Inv date */
601: l_dummy := 0;
602: SELECT COUNT(*)
603: INTO l_dummy
604: FROM pa_draft_invoices_all cm, pa_draft_invoices_all i
605: WHERE cm.project_id = P_Project_ID
606: AND cm.draft_invoice_num = P_Draft_Invoice_Num
607: AND cm.project_id = i.project_id
608: AND i.draft_invoice_num = cm.draft_invoice_num_credited

Line 633: FROM pa_draft_invoices_all

629: /* Check lower Invoice numbers have been released */
630: l_dummy := 0;
631: SELECT count(*)
632: INTO l_dummy
633: FROM pa_draft_invoices_all
634: WHERE project_id = P_Project_ID
635: AND draft_invoice_num < P_Draft_Invoice_Num
636: AND released_date is null
637: AND nvl(generation_error_flag, 'N') = 'N';

Line 649: FROM PA_DRAFT_INVOICES_ALL

645: /* Added for bug 5924290 to get the invoice status. If released then 1 else 0 */
646: begin
647: SELECT 1
648: into l_dummy
649: FROM PA_DRAFT_INVOICES_ALL
650: WHERE PROJECT_ID =P_Project_ID
651: AND DRAFT_INVOICE_NUM = P_Draft_Invoice_Num
652: AND RELEASED_DATE IS NOT NULL;
653: exception

Line 719: FROM pa_draft_invoices_all

715: l_dummy := 0;
716:
717: SELECT count(*)
718: INTO l_dummy
719: FROM pa_draft_invoices_all
720: WHERE project_id = P_Project_ID
721: AND draft_invoice_num < P_Draft_Invoice_Num
722: AND released_date is null
723: AND nvl(generation_error_flag, 'N') = 'Y';

Line 774: FROM PA_Draft_Invoices_ALL i

770: l_dummy := 0;
771:
772: SELECT count(*)
773: INTO l_dummy
774: FROM PA_Draft_Invoices_ALL i
775: WHERE i.invoice_set_id = P_Invoice_Set_ID
776: AND i.customer_bill_split not in (0, 100)
777: AND ( ( (i.approved_date is not null)
778: AND EXISTS ( SELECT 'APPROVED ERROR'

Line 986: l_Credit_memo_reason_code pa_draft_invoices_all.credit_memo_reason_Code%TYPE;

982:
983: l_ra_invoice_num varchar2(20);
984: l_tmp_ra_invoice_num varchar2(20);
985: l_ra_invoice_date date;
986: l_Credit_memo_reason_code pa_draft_invoices_all.credit_memo_reason_Code%TYPE;
987:
988: /* Cursor for Select All Unapproved invoices created in This Run */
989: CURSOR UNAPP_INV_CUR is
990: SELECT i.project_id,

Line 1618: pa_draft_invoices_all INV,

1614: INV.invoice_date,
1615: PROJ.Carrying_Out_Organization_ID
1616: FROM pa_implementations IMP,
1617: fnd_languages BASELANG,
1618: pa_draft_invoices_all INV,
1619: pa_projects PROJ
1620: WHERE INV.project_id = p_project_id
1621: AND INV.draft_invoice_num = p_draft_invoice_num
1622: AND BASELANG.installed_flag = 'B'

Line 1627: l_invoice_date pa_draft_invoices_all.invoice_date%TYPE;

1623: AND PROJ.project_id = p_project_id;
1624: l_business_group_id pa_implementations.business_group_id%TYPE;
1625: l_org_st_ver_id pa_implementations.proj_org_structure_version_id%TYPE;
1626: l_base_language fnd_languages.language_code%TYPE;
1627: l_invoice_date pa_draft_invoices_all.invoice_date%TYPE;
1628: l_carry_out_org_id pa_projects.Carrying_Out_Organization_ID%TYPE;
1629:
1630: x_trx_type VARCHAR2(10);
1631: x_cm_trx_type VARCHAR2(10);