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;
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');
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;
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;
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);
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));
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: --
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));
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: --
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: --
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:
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;
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: --
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;
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: --
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));
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: --
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
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';