DBA Data[Home] [Help]

APPS.OE_CNCL_ORDER_IMPORT_PVT dependencies on FND_GLOBAL

Line 3033: l_header_rec.created_by := FND_GLOBAL.USER_ID;

3029: --
3030: OE_CNCL_Util.Convert_Miss_To_Null(l_header_rec);
3031: --
3032: l_header_rec.creation_date := SYSDATE;
3033: l_header_rec.created_by := FND_GLOBAL.USER_ID;
3034: -- bug 4002850, removed quotes around 1.0 below
3035: l_header_rec.version_number := nvl(l_header_rec.version_number,1.0);
3036: l_header_rec.last_updated_by := FND_GLOBAL.USER_ID;
3037: l_header_rec.last_update_date := sysdate;

Line 3036: l_header_rec.last_updated_by := FND_GLOBAL.USER_ID;

3032: l_header_rec.creation_date := SYSDATE;
3033: l_header_rec.created_by := FND_GLOBAL.USER_ID;
3034: -- bug 4002850, removed quotes around 1.0 below
3035: l_header_rec.version_number := nvl(l_header_rec.version_number,1.0);
3036: l_header_rec.last_updated_by := FND_GLOBAL.USER_ID;
3037: l_header_rec.last_update_date := sysdate;
3038: l_header_rec.booked_flag := nvl(l_header_rec.booked_flag, 'Y');
3039: l_header_rec.order_category_code :=
3040: nvl(l_header_rec.order_category_code, 'MIXED');

Line 3045: oe_debug_pub.add( 'USER ID IS '|| FND_GLOBAL.USER_ID ) ;

3041: l_header_rec.open_flag := 'N';
3042: l_header_rec.flow_status_code := 'CLOSED';
3043: --
3044: IF l_debug_level > 0 THEN
3045: oe_debug_pub.add( 'USER ID IS '|| FND_GLOBAL.USER_ID ) ;
3046: END IF;
3047: IF l_debug_level > 0 THEN
3048: oe_debug_pub.add( 'RESP ID IS '|| FND_GLOBAL.RESP_ID ) ;
3049: END IF;

Line 3048: oe_debug_pub.add( 'RESP ID IS '|| FND_GLOBAL.RESP_ID ) ;

3044: IF l_debug_level > 0 THEN
3045: oe_debug_pub.add( 'USER ID IS '|| FND_GLOBAL.USER_ID ) ;
3046: END IF;
3047: IF l_debug_level > 0 THEN
3048: oe_debug_pub.add( 'RESP ID IS '|| FND_GLOBAL.RESP_ID ) ;
3049: END IF;
3050: IF l_debug_level > 0 THEN
3051: oe_debug_pub.add( 'APPL ID IS '|| FND_GLOBAL.RESP_APPL_ID ) ;
3052: END IF;

Line 3051: oe_debug_pub.add( 'APPL ID IS '|| FND_GLOBAL.RESP_APPL_ID ) ;

3047: IF l_debug_level > 0 THEN
3048: oe_debug_pub.add( 'RESP ID IS '|| FND_GLOBAL.RESP_ID ) ;
3049: END IF;
3050: IF l_debug_level > 0 THEN
3051: oe_debug_pub.add( 'APPL ID IS '|| FND_GLOBAL.RESP_APPL_ID ) ;
3052: END IF;
3053:
3054: --
3055: OE_Header_Util.Insert_Row(l_header_rec);

Line 3119: l_header_scredit_tbl(I).created_by := FND_GLOBAL.USER_ID;

3115: --
3116: OE_CNCL_Util.Convert_Miss_To_Null(l_header_scredit_tbl(I));
3117: --
3118: l_header_scredit_tbl(I).creation_date := SYSDATE;
3119: l_header_scredit_tbl(I).created_by := FND_GLOBAL.USER_ID;
3120: l_header_scredit_tbl(I).last_updated_by := FND_GLOBAL.USER_ID;
3121: l_header_scredit_tbl(I).last_update_date := sysdate;
3122: --
3123: OE_Header_Scredit_Util.Insert_Row(l_header_scredit_tbl(I));

Line 3120: l_header_scredit_tbl(I).last_updated_by := FND_GLOBAL.USER_ID;

3116: OE_CNCL_Util.Convert_Miss_To_Null(l_header_scredit_tbl(I));
3117: --
3118: l_header_scredit_tbl(I).creation_date := SYSDATE;
3119: l_header_scredit_tbl(I).created_by := FND_GLOBAL.USER_ID;
3120: l_header_scredit_tbl(I).last_updated_by := FND_GLOBAL.USER_ID;
3121: l_header_scredit_tbl(I).last_update_date := sysdate;
3122: --
3123: OE_Header_Scredit_Util.Insert_Row(l_header_scredit_tbl(I));
3124: --

Line 3185: l_header_adj_tbl(I).created_by := FND_GLOBAL.USER_ID;

3181: --
3182: OE_CNCL_Util.Convert_Miss_To_Null(l_header_adj_tbl(I));
3183: --
3184: l_header_adj_tbl(I).creation_date := SYSDATE;
3185: l_header_adj_tbl(I).created_by := FND_GLOBAL.USER_ID;
3186: l_header_adj_tbl(I).last_updated_by := FND_GLOBAL.USER_ID;
3187: l_header_adj_tbl(I).last_update_date := sysdate;
3188: --
3189: OE_Header_Adj_Util.Insert_Row(l_header_adj_tbl(I));

Line 3186: l_header_adj_tbl(I).last_updated_by := FND_GLOBAL.USER_ID;

3182: OE_CNCL_Util.Convert_Miss_To_Null(l_header_adj_tbl(I));
3183: --
3184: l_header_adj_tbl(I).creation_date := SYSDATE;
3185: l_header_adj_tbl(I).created_by := FND_GLOBAL.USER_ID;
3186: l_header_adj_tbl(I).last_updated_by := FND_GLOBAL.USER_ID;
3187: l_header_adj_tbl(I).last_update_date := sysdate;
3188: --
3189: OE_Header_Adj_Util.Insert_Row(l_header_adj_tbl(I));
3190: --

Line 3285: l_line_tbl(I).created_by := FND_GLOBAL.USER_ID;

3281:
3282: l_line_tbl(I).flow_status_code := 'CLOSED';
3283:
3284: l_line_tbl(I).creation_date := SYSDATE;
3285: l_line_tbl(I).created_by := FND_GLOBAL.USER_ID;
3286: l_line_tbl(I).last_updated_by := FND_GLOBAL.USER_ID;
3287: l_line_tbl(I).last_update_date := SYSDATE;
3288:
3289: --

Line 3286: l_line_tbl(I).last_updated_by := FND_GLOBAL.USER_ID;

3282: l_line_tbl(I).flow_status_code := 'CLOSED';
3283:
3284: l_line_tbl(I).creation_date := SYSDATE;
3285: l_line_tbl(I).created_by := FND_GLOBAL.USER_ID;
3286: l_line_tbl(I).last_updated_by := FND_GLOBAL.USER_ID;
3287: l_line_tbl(I).last_update_date := SYSDATE;
3288:
3289: --
3290:

Line 3376: l_line_scredit_tbl(J).created_by := FND_GLOBAL.USER_ID;

3372: --
3373: OE_CNCL_Util.Convert_Miss_To_Null(l_line_scredit_tbl(J));
3374: --
3375: l_line_scredit_tbl(J).creation_date := SYSDATE;
3376: l_line_scredit_tbl(J).created_by := FND_GLOBAL.USER_ID;
3377: l_line_scredit_tbl(J).last_updated_by := FND_GLOBAL.USER_ID;
3378: l_line_scredit_tbl(J).last_update_date := sysdate;
3379: --
3380: END IF;

Line 3377: l_line_scredit_tbl(J).last_updated_by := FND_GLOBAL.USER_ID;

3373: OE_CNCL_Util.Convert_Miss_To_Null(l_line_scredit_tbl(J));
3374: --
3375: l_line_scredit_tbl(J).creation_date := SYSDATE;
3376: l_line_scredit_tbl(J).created_by := FND_GLOBAL.USER_ID;
3377: l_line_scredit_tbl(J).last_updated_by := FND_GLOBAL.USER_ID;
3378: l_line_scredit_tbl(J).last_update_date := sysdate;
3379: --
3380: END IF;
3381: --

Line 3404: l_line_adj_tbl(K).created_by := FND_GLOBAL.USER_ID;

3400: --
3401: OE_CNCL_Util.Convert_Miss_To_Null(l_line_adj_tbl(K));
3402: --
3403: l_line_adj_tbl(K).creation_date := SYSDATE;
3404: l_line_adj_tbl(K).created_by := FND_GLOBAL.USER_ID;
3405: l_line_adj_tbl(K).last_updated_by := FND_GLOBAL.USER_ID;
3406: l_line_adj_tbl(K).last_update_date := sysdate;
3407: --
3408: END IF;

Line 3405: l_line_adj_tbl(K).last_updated_by := FND_GLOBAL.USER_ID;

3401: OE_CNCL_Util.Convert_Miss_To_Null(l_line_adj_tbl(K));
3402: --
3403: l_line_adj_tbl(K).creation_date := SYSDATE;
3404: l_line_adj_tbl(K).created_by := FND_GLOBAL.USER_ID;
3405: l_line_adj_tbl(K).last_updated_by := FND_GLOBAL.USER_ID;
3406: l_line_adj_tbl(K).last_update_date := sysdate;
3407: --
3408: END IF;
3409: --

Line 3502: l_line_scredit_tbl(J).created_by := FND_GLOBAL.USER_ID;

3498: --
3499: OE_CNCL_Util.Convert_Miss_To_Null(l_line_scredit_tbl(J));
3500: --
3501: l_line_scredit_tbl(J).creation_date := SYSDATE;
3502: l_line_scredit_tbl(J).created_by := FND_GLOBAL.USER_ID;
3503: l_line_scredit_tbl(J).last_updated_by := FND_GLOBAL.USER_ID;
3504: l_line_scredit_tbl(J).last_update_date := sysdate;
3505:
3506: OE_Line_Scredit_Util.Insert_Row(l_line_scredit_tbl(J));

Line 3503: l_line_scredit_tbl(J).last_updated_by := FND_GLOBAL.USER_ID;

3499: OE_CNCL_Util.Convert_Miss_To_Null(l_line_scredit_tbl(J));
3500: --
3501: l_line_scredit_tbl(J).creation_date := SYSDATE;
3502: l_line_scredit_tbl(J).created_by := FND_GLOBAL.USER_ID;
3503: l_line_scredit_tbl(J).last_updated_by := FND_GLOBAL.USER_ID;
3504: l_line_scredit_tbl(J).last_update_date := sysdate;
3505:
3506: OE_Line_Scredit_Util.Insert_Row(l_line_scredit_tbl(J));
3507: --

Line 3571: l_line_adj_tbl(K).created_by := FND_GLOBAL.USER_ID;

3567: --
3568: OE_CNCL_Util.Convert_Miss_To_Null(l_line_adj_tbl(K));
3569: --
3570: l_line_adj_tbl(K).creation_date := SYSDATE;
3571: l_line_adj_tbl(K).created_by := FND_GLOBAL.USER_ID;
3572: l_line_adj_tbl(K).last_updated_by := FND_GLOBAL.USER_ID;
3573: l_line_adj_tbl(K).last_update_date := SYSDATE;
3574: --
3575: -- JAUTOMO: TO DO

Line 3572: l_line_adj_tbl(K).last_updated_by := FND_GLOBAL.USER_ID;

3568: OE_CNCL_Util.Convert_Miss_To_Null(l_line_adj_tbl(K));
3569: --
3570: l_line_adj_tbl(K).creation_date := SYSDATE;
3571: l_line_adj_tbl(K).created_by := FND_GLOBAL.USER_ID;
3572: l_line_adj_tbl(K).last_updated_by := FND_GLOBAL.USER_ID;
3573: l_line_adj_tbl(K).last_update_date := SYSDATE;
3574: --
3575: -- JAUTOMO: TO DO
3576: -- l_line_adj_tbl(K).update_flag := 'N';