DBA Data[Home] [Help]

APPS.OE_CNCL_ORDER_IMPORT_PVT dependencies on FND_GLOBAL

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

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

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

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

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

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

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

3048: IF l_debug_level > 0 THEN
3049: oe_debug_pub.add( 'USER ID IS '|| FND_GLOBAL.USER_ID ) ;
3050: END IF;
3051: IF l_debug_level > 0 THEN
3052: oe_debug_pub.add( 'RESP ID IS '|| FND_GLOBAL.RESP_ID ) ;
3053: END IF;
3054: IF l_debug_level > 0 THEN
3055: oe_debug_pub.add( 'APPL ID IS '|| FND_GLOBAL.RESP_APPL_ID ) ;
3056: END IF;

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

3051: IF l_debug_level > 0 THEN
3052: oe_debug_pub.add( 'RESP ID IS '|| FND_GLOBAL.RESP_ID ) ;
3053: END IF;
3054: IF l_debug_level > 0 THEN
3055: oe_debug_pub.add( 'APPL ID IS '|| FND_GLOBAL.RESP_APPL_ID ) ;
3056: END IF;
3057:
3058: --
3059: OE_Header_Util.Insert_Row(l_header_rec);

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

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

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

3120: OE_CNCL_Util.Convert_Miss_To_Null(l_header_scredit_tbl(I));
3121: --
3122: l_header_scredit_tbl(I).creation_date := SYSDATE;
3123: l_header_scredit_tbl(I).created_by := FND_GLOBAL.USER_ID;
3124: l_header_scredit_tbl(I).last_updated_by := FND_GLOBAL.USER_ID;
3125: l_header_scredit_tbl(I).last_update_date := sysdate;
3126: --
3127: OE_Header_Scredit_Util.Insert_Row(l_header_scredit_tbl(I));
3128: --

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

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

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

3186: OE_CNCL_Util.Convert_Miss_To_Null(l_header_adj_tbl(I));
3187: --
3188: l_header_adj_tbl(I).creation_date := SYSDATE;
3189: l_header_adj_tbl(I).created_by := FND_GLOBAL.USER_ID;
3190: l_header_adj_tbl(I).last_updated_by := FND_GLOBAL.USER_ID;
3191: l_header_adj_tbl(I).last_update_date := sysdate;
3192: --
3193: OE_Header_Adj_Util.Insert_Row(l_header_adj_tbl(I));
3194: --

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

3335:
3336: l_line_tbl(I).flow_status_code := 'CLOSED';
3337:
3338: l_line_tbl(I).creation_date := SYSDATE;
3339: l_line_tbl(I).created_by := FND_GLOBAL.USER_ID;
3340: l_line_tbl(I).last_updated_by := FND_GLOBAL.USER_ID;
3341: l_line_tbl(I).last_update_date := SYSDATE;
3342:
3343: --

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

3336: l_line_tbl(I).flow_status_code := 'CLOSED';
3337:
3338: l_line_tbl(I).creation_date := SYSDATE;
3339: l_line_tbl(I).created_by := FND_GLOBAL.USER_ID;
3340: l_line_tbl(I).last_updated_by := FND_GLOBAL.USER_ID;
3341: l_line_tbl(I).last_update_date := SYSDATE;
3342:
3343: --
3344:

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

3426: --
3427: OE_CNCL_Util.Convert_Miss_To_Null(l_line_scredit_tbl(J));
3428: --
3429: l_line_scredit_tbl(J).creation_date := SYSDATE;
3430: l_line_scredit_tbl(J).created_by := FND_GLOBAL.USER_ID;
3431: l_line_scredit_tbl(J).last_updated_by := FND_GLOBAL.USER_ID;
3432: l_line_scredit_tbl(J).last_update_date := sysdate;
3433: --
3434: END IF;

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

3427: OE_CNCL_Util.Convert_Miss_To_Null(l_line_scredit_tbl(J));
3428: --
3429: l_line_scredit_tbl(J).creation_date := SYSDATE;
3430: l_line_scredit_tbl(J).created_by := FND_GLOBAL.USER_ID;
3431: l_line_scredit_tbl(J).last_updated_by := FND_GLOBAL.USER_ID;
3432: l_line_scredit_tbl(J).last_update_date := sysdate;
3433: --
3434: END IF;
3435: --

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

3454: --
3455: OE_CNCL_Util.Convert_Miss_To_Null(l_line_adj_tbl(K));
3456: --
3457: l_line_adj_tbl(K).creation_date := SYSDATE;
3458: l_line_adj_tbl(K).created_by := FND_GLOBAL.USER_ID;
3459: l_line_adj_tbl(K).last_updated_by := FND_GLOBAL.USER_ID;
3460: l_line_adj_tbl(K).last_update_date := sysdate;
3461: --
3462: END IF;

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

3455: OE_CNCL_Util.Convert_Miss_To_Null(l_line_adj_tbl(K));
3456: --
3457: l_line_adj_tbl(K).creation_date := SYSDATE;
3458: l_line_adj_tbl(K).created_by := FND_GLOBAL.USER_ID;
3459: l_line_adj_tbl(K).last_updated_by := FND_GLOBAL.USER_ID;
3460: l_line_adj_tbl(K).last_update_date := sysdate;
3461: --
3462: END IF;
3463: --

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

3567: --
3568: OE_CNCL_Util.Convert_Miss_To_Null(l_line_scredit_tbl(J));
3569: --
3570: l_line_scredit_tbl(J).creation_date := SYSDATE;
3571: l_line_scredit_tbl(J).created_by := FND_GLOBAL.USER_ID;
3572: l_line_scredit_tbl(J).last_updated_by := FND_GLOBAL.USER_ID;
3573: l_line_scredit_tbl(J).last_update_date := sysdate;
3574:
3575: OE_Line_Scredit_Util.Insert_Row(l_line_scredit_tbl(J));

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

3568: OE_CNCL_Util.Convert_Miss_To_Null(l_line_scredit_tbl(J));
3569: --
3570: l_line_scredit_tbl(J).creation_date := SYSDATE;
3571: l_line_scredit_tbl(J).created_by := FND_GLOBAL.USER_ID;
3572: l_line_scredit_tbl(J).last_updated_by := FND_GLOBAL.USER_ID;
3573: l_line_scredit_tbl(J).last_update_date := sysdate;
3574:
3575: OE_Line_Scredit_Util.Insert_Row(l_line_scredit_tbl(J));
3576: --

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

3636: --
3637: OE_CNCL_Util.Convert_Miss_To_Null(l_line_adj_tbl(K));
3638: --
3639: l_line_adj_tbl(K).creation_date := SYSDATE;
3640: l_line_adj_tbl(K).created_by := FND_GLOBAL.USER_ID;
3641: l_line_adj_tbl(K).last_updated_by := FND_GLOBAL.USER_ID;
3642: l_line_adj_tbl(K).last_update_date := SYSDATE;
3643: --
3644: -- JAUTOMO: TO DO

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

3637: OE_CNCL_Util.Convert_Miss_To_Null(l_line_adj_tbl(K));
3638: --
3639: l_line_adj_tbl(K).creation_date := SYSDATE;
3640: l_line_adj_tbl(K).created_by := FND_GLOBAL.USER_ID;
3641: l_line_adj_tbl(K).last_updated_by := FND_GLOBAL.USER_ID;
3642: l_line_adj_tbl(K).last_update_date := SYSDATE;
3643: --
3644: -- JAUTOMO: TO DO
3645: -- l_line_adj_tbl(K).update_flag := 'N';