APPS.OE_INVOICE_PUB dependencies on RA_INTERFACE_LINES_ALL

Line 2775: INSERT INTO RA_INTERFACE_LINES_ALL

2771: BEGIN
2772: IF l_debug_level > 0 THEN
2773: oe_debug_pub.add( 'ENTERING INSERT_LINE ( ) PROCEDURE' , 1 ) ;
2774: END IF;
2775: INSERT INTO RA_INTERFACE_LINES_ALL
2776: (CREATED_BY
2777: ,CREATION_DATE
2778: ,LAST_UPDATED_BY
2779: ,LAST_UPDATE_DATE

Line 3348: update_sql_stmt := 'UPDATE RA_INTERFACE_LINES_ALL

3344: AND p_interface_line_rec.promised_commitment_amount IS NOT NULL THEN
3345: IF l_debug_level > 0 THEN
3346: oe_debug_pub.add( 'BUILD UPDATE STATEMENT WITH PROMISED COMMITMENT AMOUNT' , 1 ) ;
3347: END IF;
3348: update_sql_stmt := 'UPDATE RA_INTERFACE_LINES_ALL
3349: SET PROMISED_COMMITMENT_AMOUNT = :1
3350: WHERE ROWID = :r1';
3351: IF l_debug_level > 0 THEN
3352: oe_debug_pub.add( 'EXECUTING UPDATE STMT FOR PROMISED_COMMITMENT_AMOUNT' , 1 ) ;

Line 3364: update_sql_stmt1 := 'UPDATE RA_INTERFACE_LINES_ALL

3360: IF p_interface_line_rec.payment_set_id IS NOT NULL THEN
3361: IF l_debug_level > 0 THEN
3362: oe_debug_pub.add( 'BUILD UPDATE STATEMENT WITH PAYMENT_SET_ID' , 1 ) ;
3363: END IF;
3364: update_sql_stmt1 := 'UPDATE RA_INTERFACE_LINES_ALL
3365: SET PAYMENT_SET_ID = :2
3366: WHERE ROWID = :r2';
3367: IF l_debug_level > 0 THEN
3368: oe_debug_pub.add( 'EXECUTING UPDATE STMT FOR PAYMENT_SET_ID: '||P_INTERFACE_LINE_REC.PAYMENT_SET_ID , 1 ) ;

Line 3382: err_msg := 'Error while inserting to RA_INTERFACE_LINES_ALL :\n '|| SQLERRM;

3378: oe_debug_pub.add( 'EXIT INSERT_LINE ( ) PROCEDURE' , 1 ) ;
3379: END IF;
3380: EXCEPTION
3381: WHEN OTHERS THEN
3382: err_msg := 'Error while inserting to RA_INTERFACE_LINES_ALL :\n '|| SQLERRM;
3383: IF l_debug_level > 0 THEN
3384: oe_debug_pub.add( ERR_MSG || ' SQLCODE: '||TO_CHAR ( SQLCODE ) , 1 ) ;
3385: END IF;
3386: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 5532: FROM ra_interface_lines_all

5528: ,p_x_charges_rec => l_charges_rec);
5529:
5530: SELECT nvl(max(interface_line_attribute5),0) --Bug 3338492
5531: INTO l_count1
5532: FROM ra_interface_lines_all
5533: WHERE interface_line_context = 'ORDER ENTRY'
5534: AND interface_line_attribute1 = l_charges_rec.INTERFACE_LINE_ATTRIBUTE1
5535: AND interface_line_attribute2 = l_charges_rec.INTERFACE_LINE_ATTRIBUTE2
5536: AND interface_line_attribute6 = l_charges_rec.INTERFACE_LINE_ATTRIBUTE6

Line 6091: FROM ra_interface_lines_all

6087: oe_debug_pub.add( 'THIS LINE WAS INTERFACED ATLEAST ONCE BEFORE' , 5 ) ;
6088: END IF;
6089: SELECT count(*)
6090: INTO l_count1
6091: FROM ra_interface_lines_all
6092: WHERE interface_line_context = 'ORDER ENTRY'
6093: AND interface_line_attribute1 = p_x_interface_line_rec.INTERFACE_LINE_ATTRIBUTE1
6094: AND interface_line_attribute2 = p_x_interface_line_rec.INTERFACE_LINE_ATTRIBUTE2
6095: AND interface_line_attribute6= to_char(p_line_rec.line_id)

Line 7825: FROM ra_interface_lines_all

7821: oe_debug_pub.add( 'ENTER UPDATE_NUMBERS ( ) PROCEDURE' , 5 ) ;
7822: END IF;
7823: SELECT count(*)
7824: INTO l_count
7825: FROM ra_interface_lines_all
7826: WHERE request_id = -1 * p_id;
7827:
7828: IF l_count = 0 THEN
7829: IF l_debug_level > 0 THEN

Line 7859: ' From RA_INTERFACE_LINES_ALL L' ||

7855: oe_debug_pub.add( 'POSITION 2-1' ) ;
7856: END IF;
7857: grp_stmt := 'Select ' || select_col || ' group_cols,' ||
7858: ' l.interface_line_attribute3, ROWID ' ||
7859: ' From RA_INTERFACE_LINES_ALL L' ||
7860: ' Where trx_number is NULL' ||
7861: ' And request_id = :p' ||
7862: ' Order by ' || group_col_clause ||
7863: ' , l.interface_line_attribute3, l.org_id' ;

Line 7922: Update RA_INTERFACE_LINES_ALL

7918: END IF;
7919: IF l_debug_level > 0 THEN
7920: oe_debug_pub.add( 'TRANSACTION NUMBER IS : '|| INV_NUM , 5 ) ;
7921: END IF;
7922: Update RA_INTERFACE_LINES_ALL
7923: set trx_number = substr(inv_num,1,20) -- substr(inv_num,20)--inv_num --bug#7592350 -- Bug 8216166
7924: where rowid = chartorowid(this_rowid);
7925: END LOOP;
7926: CLOSE del_cursor;

Line 7930: update ra_interface_lines_all

7926: CLOSE del_cursor;
7927: IF l_debug_level > 0 THEN
7928: oe_debug_pub.add( 'SETTING REQUEST ID TO NULL' , 5 ) ;
7929: END IF;
7930: update ra_interface_lines_all
7931: set request_id=null
7932: where request_id = -1 * p_id;
7933: x_return_status := FND_API.G_RET_STS_SUCCESS;
7934: IF l_debug_level > 0 THEN