APPS.PA_INVOICE_XFER dependencies on PA_DRAFT_INVOICE_ITEMS

Line 73: UPDATE PA_DRAFT_INVOICE_ITEMS

69: Then
70:
71: /** Update the lines Acct amount same as project currency amount **/
72:
73: UPDATE PA_DRAFT_INVOICE_ITEMS
74: /* MCB2 change
75: SET ACCT_AMOUNT = AMOUNT,
76: */
77: SET ACCT_AMOUNT = PROJFUNC_BILL_AMOUNT,

Line 158: UPDATE PA_DRAFT_INVOICE_ITEMS

154:
155: /** Update Invoice line with line amount,rounding amount
156: **/
157:
158: UPDATE PA_DRAFT_INVOICE_ITEMS
159: SET ACCT_AMOUNT = l_func_line,
160: ROUNDING_AMOUNT = l_rnd_amt
161: Where PROJECT_ID = P_PROJECT_ID
162: and DRAFT_INVOICE_NUM = P_DRAFT_INV_NUM

Line 232: UPDATE PA_DRAFT_INVOICE_ITEMS

228: Then
229:
230: /** Update the lines Acct amount same as project currency amount **/
231:
232: UPDATE PA_DRAFT_INVOICE_ITEMS
233: /* MCB2 change
234: SET ACCT_AMOUNT = AMOUNT,
235: */
236: SET ACCT_AMOUNT = PROJFUNC_BILL_AMOUNT,

Line 356: UPDATE PA_DRAFT_INVOICE_ITEMS

352: /** Update Invoice line with line amount,rounding amount,UBR Rounding
353: ,UER rounding amount in accounting currency.
354: **/
355:
356: UPDATE PA_DRAFT_INVOICE_ITEMS
357: SET ACCT_AMOUNT = l_func_line,
358: /* MCB2 change
359: ROUNDING_AMOUNT = l_func_line - AMOUNT,
360: */

Line 417: PA_DRAFT_INVOICE_ITEMS DII

413: DII.PROJFUNC_BILL_AMOUNT Proj_line_amt,
414: Decode(P_Transfer_Mode,'INTERCOMPANY',
415: DII.CC_REV_CODE_COMBINATION_ID,P_WO_Ccid) rev_ccid
416: FROM RA_INTERFACE_LINES I,
417: PA_DRAFT_INVOICE_ITEMS DII
418: WHERE I.INTERFACE_LINE_ATTRIBUTE1||'' = P_Project_Num
419: AND rtrim(ltrim(I.INTERFACE_LINE_ATTRIBUTE2)) =
420: rtrim(ltrim(to_char(P_Inv_Num)))
421: -- AND I.INTERFACE_LINE_CONTEXT = P_Batch_Src -- Performance Bug 2695303

Line 482: FROM PA_DRAFT_INVOICE_ITEMS DII

478: (nvl(DII.UNEARNED_REVENUE_CR,0)) PRJ_UER,
479: dii.invoice_line_type, /* Retention Enhancement */
480: dii.projfunc_bill_amount,
481: dii.inv_amount
482: FROM PA_DRAFT_INVOICE_ITEMS DII
483: WHERE DII.PROJECT_ID = P_Project_Id
484: AND DII.DRAFT_INVOICE_NUM = P_Inv_Num
485: AND DII.LINE_NUM = to_number(l_line_num);
486:

Line 980: -- FROM PA_DRAFT_INVOICE_ITEMS DII

976: --
977: -- /* Calculate the Original Invoice Amount in PA */
978: -- SELECT SUM(DII.AMOUNT)
979: -- INTO PA_ORIG_INV_AMT
980: -- FROM PA_DRAFT_INVOICE_ITEMS DII
981: -- WHERE DII.PROJECT_ID = P_Project_Id
982: -- AND DII.DRAFT_INVOICE_NUM = cur_get_inv_info.orig_inv_num;
983: --
984: -- /* Calculate the original Invoice amount in AR */

Line 1003: -- FROM PA_DRAFT_INVOICE_ITEMS DII

999: --
1000: -- /* Calculate the Invoice Amount of the Crediting Invoice */
1001: -- SELECT SUM(DII.AMOUNT)
1002: -- INTO PA_CM_INV_AMT
1003: -- FROM PA_DRAFT_INVOICE_ITEMS DII
1004: -- WHERE DII.PROJECT_ID = P_Project_Id
1005: -- AND DII.DRAFT_INVOICE_NUM = cur_get_inv_info.cm_inv_num;
1006: --
1007: -- /* Calculate the prorated value of the crediting Invoice */

Line 1082: FROM PA_DRAFT_INVOICE_ITEMS DII

1078: IF cur_get_inv_info.CM_CAN_FLAG = 'Y'
1079: THEN
1080: SELECT SUM(DII.AMOUNT) /SUM(DII.INV_AMOUNT)
1081: INTO l_rate
1082: FROM PA_DRAFT_INVOICE_ITEMS DII
1083: WHERE DII.PROJECT_ID = P_Project_Id
1084: AND DII.DRAFT_INVOICE_NUM = cur_get_inv_info.cm_inv_num;
1085:
1086: PA_EXCHG_TYPE :='User';