DBA Data[Home] [Help]

APPS.PA_INVOICE_XFER dependencies on RA_INTERFACE_DISTRIBUTIONS

Line 110: insert it into table RA_INTERFACE_DISTRIBUTIONS as ORG_ID.

106: /* l_rnd_amt := P_Proj_line_amt - l_func_line; bug 4074354 */
107: l_rnd_amt := l_func_line - P_Proj_line_amt;
108:
109: /** Shared services changes: get org id from org context, and
110: insert it into table RA_INTERFACE_DISTRIBUTIONS as ORG_ID.
111: **/
112: l_org_id := MO_GLOBAL.get_current_org_id;
113:
114: /**

Line 119: INSERT INTO RA_INTERFACE_DISTRIBUTIONS

115: Insert Single Account rounding amount in Interface Distribution
116: **/
117: IF l_rnd_amt <> 0
118: THEN
119: INSERT INTO RA_INTERFACE_DISTRIBUTIONS
120: ( ACCOUNT_CLASS, ACCTD_AMOUNT,AMOUNT,PERCENT,
121: CODE_COMBINATION_ID, INTERFACE_LINE_ATTRIBUTE1,
122: INTERFACE_LINE_ATTRIBUTE2, INTERFACE_LINE_ATTRIBUTE3,
123: INTERFACE_LINE_ATTRIBUTE4, INTERFACE_LINE_ATTRIBUTE5,

Line 135: INSERT INTO RA_INTERFACE_DISTRIBUTIONS

131: P_Interface_attr6, P_Interface_attr7,
132: P_Interface_attr8, P_Batch_Src,
133: FND_GLOBAL.USER_ID,SYSDATE,FND_GLOBAL.USER_ID,SYSDATE,FND_GLOBAL.USER_ID, /* Bug # 2244810 */
134: l_org_id);
135: INSERT INTO RA_INTERFACE_DISTRIBUTIONS
136: ( ACCOUNT_CLASS, ACCTD_AMOUNT,AMOUNT,PERCENT,
137: CODE_COMBINATION_ID, INTERFACE_LINE_ATTRIBUTE1,
138: INTERFACE_LINE_ATTRIBUTE2, INTERFACE_LINE_ATTRIBUTE3,
139: INTERFACE_LINE_ATTRIBUTE4, INTERFACE_LINE_ATTRIBUTE5,

Line 271: insert it into table RA_INTERFACE_DISTRIBUTIONS as ORG_ID.

267: l_rnd_UBR := P_Prj_ubr_amt - l_func_UBR;
268: l_rnd_UER := P_Prj_uer_amt - l_func_UER;
269:
270: /** Shared services changes: get org id from org context, and
271: insert it into table RA_INTERFACE_DISTRIBUTIONS as ORG_ID.
272: **/
273: l_org_id := MO_GLOBAL.get_current_org_id;
274:
275: /**

Line 283: INSERT INTO RA_INTERFACE_DISTRIBUTIONS

279: Shared services changes: Insert the org ID
280: **/
281: IF l_rnd_UBR <> 0
282: THEN
283: INSERT INTO RA_INTERFACE_DISTRIBUTIONS
284: ( ACCOUNT_CLASS, ACCTD_AMOUNT,AMOUNT,PERCENT,
285: CODE_COMBINATION_ID, INTERFACE_LINE_ATTRIBUTE1,
286: INTERFACE_LINE_ATTRIBUTE2, INTERFACE_LINE_ATTRIBUTE3,
287: INTERFACE_LINE_ATTRIBUTE4, INTERFACE_LINE_ATTRIBUTE5,

Line 310: INSERT INTO RA_INTERFACE_DISTRIBUTIONS

306: Shared services changes: Insert the org ID
307: **/
308: IF l_rnd_UER <> 0
309: THEN
310: INSERT INTO RA_INTERFACE_DISTRIBUTIONS
311: ( ACCOUNT_CLASS, ACCTD_AMOUNT,AMOUNT,PERCENT,
312: CODE_COMBINATION_ID, INTERFACE_LINE_ATTRIBUTE1,
313: INTERFACE_LINE_ATTRIBUTE2, INTERFACE_LINE_ATTRIBUTE3,
314: INTERFACE_LINE_ATTRIBUTE4, INTERFACE_LINE_ATTRIBUTE5,

Line 333: INSERT INTO RA_INTERFACE_DISTRIBUTIONS

329: Shared services changes: Insert the org ID
330: **/
331: IF (l_rnd_UBR + l_rnd_UER) <> 0
332: THEN
333: INSERT INTO RA_INTERFACE_DISTRIBUTIONS
334: ( ACCOUNT_CLASS, ACCTD_AMOUNT,AMOUNT,PERCENT,
335: CODE_COMBINATION_ID, INTERFACE_LINE_ATTRIBUTE1,
336: INTERFACE_LINE_ATTRIBUTE2, INTERFACE_LINE_ATTRIBUTE3,
337: INTERFACE_LINE_ATTRIBUTE4, INTERFACE_LINE_ATTRIBUTE5,

Line 503: insert it into table RA_INTERFACE_DISTRIBUTIONS as ORG_ID.

499:
500: BEGIN
501:
502: /** Shared services changes: get org id from org context, and
503: insert it into table RA_INTERFACE_DISTRIBUTIONS as ORG_ID.
504: **/
505: l_org_id := MO_GLOBAL.get_current_org_id;
506:
507: /* For Write-off of Regular Invoice and InterCompany Invoice,the entry

Line 542: INSERT INTO RA_Interface_Distributions

538: X_Acct_amt => l_acct_amt);
539:
540: /* Insert the Write-off/Intercompany accounting */
541: /* Shared services changes: Insert the org ID */
542: INSERT INTO RA_Interface_Distributions
543: (
544: Account_Class, Amount, Percent, Code_Combination_ID,
545: Interface_Line_Attribute1, Interface_Line_Attribute2,
546: Interface_Line_Attribute3, Interface_Line_Attribute4,

Line 618: INSERT INTO RA_Interface_Distributions

614: P_Draft_inv_num => P_Inv_Num,
615: X_Acct_amt => l_acct_amt);
616:
617: /* Shared services changes: Insert the org ID */
618: INSERT INTO RA_Interface_Distributions
619: (
620: Account_Class, Amount, Percent, Code_Combination_ID,
621: Interface_Line_Attribute1, Interface_Line_Attribute2,
622: Interface_Line_Attribute3, Interface_Line_Attribute4,

Line 660: INSERT INTO RA_Interface_Distributions

656: /* Insert UBR entry for each lines */
657: /* Shared services changes: Insert the org ID */
658: IF (nvl(cur_get_line_info.INV_UBR,0) <> 0 or PA_BILLING.GETINVOICENZ = 'Y') /* Added Additonal condition for BUG 8666892 */
659: THEN
660: INSERT INTO RA_Interface_Distributions
661: (
662: Account_Class, Amount, Percent, Code_Combination_ID,
663: Interface_Line_Attribute1, Interface_Line_Attribute2,
664: Interface_Line_Attribute3, Interface_Line_Attribute4,

Line 695: INSERT INTO RA_Interface_Distributions

691: /* Insert UER entry for each lines */
692: /* Shared services changes: Insert the org ID */
693: IF (l_inv_uer <> 0 or PA_BILLING.GETINVOICENZ = 'Y') /* Added Additonal condition for BUG 8666892 */
694: THEN
695: INSERT INTO RA_Interface_Distributions
696: (
697: Account_Class, Amount, Percent, Code_Combination_ID,
698: Interface_Line_Attribute1, Interface_Line_Attribute2,
699: Interface_Line_Attribute3, Interface_Line_Attribute4,

Line 776: INSERT INTO RA_Interface_Distributions

772: AND I.TRX_NUMBER = P_Trx_Num;
773:
774: /* Insert the Receivable Accounting for the Invoice */
775: /* Shared services changes: Insert the org ID */
776: INSERT INTO RA_Interface_Distributions
777: (
778: Account_Class, Amount, Percent, Code_Combination_ID,
779: Interface_Line_Attribute1, Interface_Line_Attribute2,
780: Interface_Line_Attribute3, Interface_Line_Attribute4,