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

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 189: FROM pa_draft_invoices i

185: Cursor Credit_Memo_exist is
186: SELECT 'Y'
187: FROM dual
188: WHERE EXISTS(SELECT draft_invoice_num
189: FROM pa_draft_invoices i
190: WHERE i.project_id = P_Project_ID
191: AND i.draft_invoice_num = P_Draft_Invoice_Num
192: AND i.draft_invoice_num_credited IS NOT NULL);
193:

Line 270: l_customer_id pa_draft_invoices_v.customer_id%TYPE;

266: P_Draft_Invoice_Num in number,
267: P_Validation_Level in varchar2,
268: X_Error_Message_Code out NOCOPY varchar2 ) is --File.Sql.39 bug 4440895
269:
270: l_customer_id pa_draft_invoices_v.customer_id%TYPE;
271: l_generation_error_flag pa_draft_invoices_v.generation_error_flag%TYPE;
272: l_approved_date pa_draft_invoices_v.approved_date%TYPE;
273: l_project_status_code pa_draft_invoices_v.project_status_code%TYPE;
274: l_dummy number;

Line 271: l_generation_error_flag pa_draft_invoices_v.generation_error_flag%TYPE;

267: P_Validation_Level in varchar2,
268: X_Error_Message_Code out NOCOPY varchar2 ) is --File.Sql.39 bug 4440895
269:
270: l_customer_id pa_draft_invoices_v.customer_id%TYPE;
271: l_generation_error_flag pa_draft_invoices_v.generation_error_flag%TYPE;
272: l_approved_date pa_draft_invoices_v.approved_date%TYPE;
273: l_project_status_code pa_draft_invoices_v.project_status_code%TYPE;
274: l_dummy number;
275: l_err_msg_code varchar2(30);

Line 272: l_approved_date pa_draft_invoices_v.approved_date%TYPE;

268: X_Error_Message_Code out NOCOPY varchar2 ) is --File.Sql.39 bug 4440895
269:
270: l_customer_id pa_draft_invoices_v.customer_id%TYPE;
271: l_generation_error_flag pa_draft_invoices_v.generation_error_flag%TYPE;
272: l_approved_date pa_draft_invoices_v.approved_date%TYPE;
273: l_project_status_code pa_draft_invoices_v.project_status_code%TYPE;
274: l_dummy number;
275: l_err_msg_code varchar2(30);
276:

Line 273: l_project_status_code pa_draft_invoices_v.project_status_code%TYPE;

269:
270: l_customer_id pa_draft_invoices_v.customer_id%TYPE;
271: l_generation_error_flag pa_draft_invoices_v.generation_error_flag%TYPE;
272: l_approved_date pa_draft_invoices_v.approved_date%TYPE;
273: l_project_status_code pa_draft_invoices_v.project_status_code%TYPE;
274: l_dummy number;
275: l_err_msg_code varchar2(30);
276:
277:

Line 278: /* Bug#4940211 - Performance Issue for calling the pa_draft_invoices_v

274: l_dummy number;
275: l_err_msg_code varchar2(30);
276:
277:
278: /* Bug#4940211 - Performance Issue for calling the pa_draft_invoices_v
279: Fix : commented the old code and Geting
280: the value from pa_project_all and pa_draft_invoices table
281:
282: Cursor Inv_Cur is

Line 280: the value from pa_project_all and pa_draft_invoices table

276:
277:
278: /* Bug#4940211 - Performance Issue for calling the pa_draft_invoices_v
279: Fix : commented the old code and Geting
280: the value from pa_project_all and pa_draft_invoices table
281:
282: Cursor Inv_Cur is
283: SELECT i.customer_id, i.generation_error_flag,
284: i.approved_date , i.project_status_code

Line 285: FROM pa_draft_invoices_v i

281:
282: Cursor Inv_Cur is
283: SELECT i.customer_id, i.generation_error_flag,
284: i.approved_date , i.project_status_code
285: FROM pa_draft_invoices_v i
286: WHERE i.project_id = P_Project_ID
287: AND i.draft_invoice_num = P_Draft_Invoice_Num;
288: */
289:

Line 293: FROM pa_draft_invoices i,

289:
290: Cursor Inv_cur is
291: SELECT i.customer_id, i.generation_error_flag,
292: i.approved_date, prj.project_status_code project_status_code
293: FROM pa_draft_invoices i,
294: pa_projects_all prj
295: WHERE prj.project_id = P_Project_ID
296: AND i.project_id = prj.project_id
297: AND i.draft_invoice_num = P_Draft_Invoice_Num;

Line 401: l_RA_Invoice_Num pa_draft_invoices_v.RA_Invoice_Number%TYPE;

397:
398: l_dummy number;
399: l_customer_id number;
400: l_err_msg_code varchar2(30);
401: l_RA_Invoice_Num pa_draft_invoices_v.RA_Invoice_Number%TYPE;
402: l_status number;
403: l_bill_to number;
404: l_ship_to number;
405: l_Error_Message_Code VARCHAR2(80):=NULL;

Line 407: l_invoice_category pa_draft_invoices_v.invoice_category%TYPE;

403: l_bill_to number;
404: l_ship_to number;
405: l_Error_Message_Code VARCHAR2(80):=NULL;
406:
407: l_invoice_category pa_draft_invoices_v.invoice_category%TYPE;
408: l_bill_ship_to_customer_id number; /*Added for customer account relation enhancement*/
409: Cursor Imp_Cur is
410: SELECT user_defined_invoice_num_code, manual_invoice_num_type
411: FROM pa_implementations;

Line 449: FROM pa_draft_invoices INV, pa_agreements_all AGREE, /* fix bug 2082864 for MCB2 */

445: decode(nvl(PROJCUST.bill_another_project_flag,'N'),
446: 'Y', 'INTERNAL-INVOICE',
447: 'EXTERNAL-INVOICE'))
448: INTO l_customer_id,l_bill_ship_to_customer_id, l_bill_to, l_ship_to, l_invoice_category
449: FROM pa_draft_invoices INV, pa_agreements_all AGREE, /* fix bug 2082864 for MCB2 */
450: pa_project_customers PROJCUST,
451: pa_projects PROJ,
452: pa_project_types PROJTYPE
453: WHERE INV.project_id = P_Project_id

Line 513: FROM pa_draft_invoices

509: /* Fix for bug 2941112 */
510: BEGIN
511: SELECT nvl(draft_invoice_num_credited,0)
512: INTO l_draft_inv_num_cr
513: FROM pa_draft_invoices
514: WHERE project_id = p_project_id
515: AND draft_invoice_num = P_Draft_Invoice_Num;
516: EXCEPTION
517: WHEN NO_DATA_FOUND THEN

Line 530: -- FROM pa_draft_invoices di, ra_contacts rc

526: -- bug 4325231
527: -- SELECT null INTO l_dummy
528: -- FROM dual
529: -- WHERE EXISTS ( SELECT project_id
530: -- FROM pa_draft_invoices di, ra_contacts rc
531: -- WHERE di.project_id = p_project_id
532: -- AND di.draft_invoice_num = P_Draft_Invoice_Num
533: -- AND di.bill_to_contact_id = rc.contact_id
534: -- AND nvl(rc.status,'N') = 'A'

Line 539: FROM pa_draft_invoices di, hz_cust_account_roles rc

535: -- );
536: SELECT null INTO l_dummy
537: FROM dual
538: WHERE EXISTS ( SELECT project_id
539: FROM pa_draft_invoices di, hz_cust_account_roles rc
540: WHERE di.project_id = p_project_id
541: AND di.draft_invoice_num = P_Draft_Invoice_Num
542: AND di.bill_to_contact_id = rc.cust_account_role_id
543: AND nvl(rc.status,'N') = 'A'

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 672: FROM pa_draft_invoices i,

668:
669: l_dummy := 0;
670: SELECT count(*)
671: INTO l_dummy
672: FROM pa_draft_invoices i,
673: pa_projects p,
674: pa_project_types pt,
675: pa_agreements_all AGREE, /* fix bug 2082864 for MCB2 */
676: pa_project_customers PROJCUST

Line 679: FROM pa_draft_invoices x

675: pa_agreements_all AGREE, /* fix bug 2082864 for MCB2 */
676: pa_project_customers PROJCUST
677: WHERE i.ra_invoice_number = l_RA_Invoice_Num
678: AND NOT EXISTS ( SELECT 'x'
679: FROM pa_draft_invoices x
680: WHERE x.project_id = P_Project_ID
681: AND x.draft_invoice_num = P_Draft_Invoice_Num
682: AND x.project_id = i.project_id
683: AND x.draft_invoice_num = i.draft_invoice_num)

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 779: FROM pa_draft_invoices ia

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'
779: FROM pa_draft_invoices ia
780: WHERE ia.project_id = i.project_id
781: AND ia.invoice_set_id = i.invoice_set_id
782: AND ia.approved_date is null))
783: OR ( (i.released_date is not null)

Line 785: FROM pa_draft_invoices ir

781: AND ia.invoice_set_id = i.invoice_set_id
782: AND ia.approved_date is null))
783: OR ( (i.released_date is not null)
784: AND EXISTS ( SELECT 'RELEASED ERROR'
785: FROM pa_draft_invoices ir
786: WHERE ir.project_id = i.project_id
787: AND ir.invoice_set_id = i.invoice_set_id
788: AND ir.released_date is null)));
789:

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 1001: pa_draft_invoices i,

997: p.project_currency_code,
998: i.inv_currency_code,
999: sum(ii.inv_amount)
1000: FROM pa_projects p,
1001: pa_draft_invoices i,
1002: pa_draft_invoice_items ii
1003: WHERE p.project_id = i.project_id
1004: AND i.project_id = ii.project_id
1005: AND i.draft_invoice_num = ii.draft_invoice_num

Line 1034: pa_draft_invoices i,

1030: p.project_currency_code,
1031: i.inv_currency_code,
1032: sum(ii.inv_amount)
1033: FROM pa_projects p,
1034: pa_draft_invoices i,
1035: pa_draft_invoice_items ii
1036: WHERE p.project_id = i.project_id
1037: AND i.project_id = ii.project_id
1038: AND i.draft_invoice_num = ii.draft_invoice_num

Line 1059: FROM pa_draft_invoices i

1055: /* Cursor for Select All invoices Released in This Run */
1056: CURSOR RELEASED_INV_CUR is
1057: SELECT i.project_id,
1058: i.draft_invoice_num
1059: FROM pa_draft_invoices i
1060: WHERE i.request_id = P_Request_ID
1061: AND i.released_date is not null;
1062:
1063: BEGIN

Line 1441: from pa_draft_invoices

1437: /* Get the current record version number in draft invoice table */
1438:
1439: select record_version_number, last_credit_request_id
1440: into l_record_version_number, l_last_credit_request_id
1441: from pa_draft_invoices
1442: where project_id = p_project_id
1443: and draft_invoice_num = p_draft_invoice_num;
1444:
1445: /* Check that it matches the one passed by the calling process */

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);

Line 1679: FROM pa_draft_invoices i,

1675: /* Get the total credited amount for the selected invoice in Oracle Projects. */
1676:
1677: SELECT ABS(nvl(SUM(nvl(ii.inv_amount,0)),0))
1678: INTO l_tot_credited_amt
1679: FROM pa_draft_invoices i,
1680: pa_draft_invoice_items ii
1681: WHERE i.project_id = p_project_id
1682: AND ii.project_id = i.project_id
1683: AND ii.draft_invoice_num = i.draft_invoice_num

Line 2244: from pa_draft_invoice_items dii, pa_draft_invoices di

2240: to define the precision of the computed credit amount */
2241:
2242: select sum(dii.inv_amount), max(di.inv_currency_code)
2243: into l_inv_amount, l_inv_currency_code
2244: from pa_draft_invoice_items dii, pa_draft_invoices di
2245: where di.project_id = p_project_id
2246: and di.draft_invoice_num = p_draft_invoice_num
2247: and dii.project_id = di.project_id
2248: and dii.draft_invoice_num = di.draft_invoice_num

Line 2362: FROM pa_draft_invoices

2358: This SQL also ensures that the invoice does have RETENTION LINE */
2359:
2360: SELECT nvl(retention_percentage,0), inv_currency_code
2361: INTO l_retention_percentage, l_inv_currency_code
2362: FROM pa_draft_invoices
2363: WHERE project_id = p_project_id
2364: AND draft_invoice_num = p_draft_invoice_num
2365: AND EXISTS (select null from pa_draft_invoice_items
2366: WHERE project_id = p_project_id