DBA Data[Home] [Help]

APPS.OE_INVOICE_PUB dependencies on INV_LE_TIMEZONE_PUB

Line 3412: x_interface_scredit_rec.CREATION_DATE := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(sysdate,p_interface_line_rec.org_id);

3408: oe_debug_pub.add( 'ENTER LINE PREPARE_SALESCREDIT_REC ( ) PROCEDURE' , 5 ) ;
3409: END IF;
3410:
3411: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
3412: x_interface_scredit_rec.CREATION_DATE := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(sysdate,p_interface_line_rec.org_id);
3413: x_interface_scredit_rec.LAST_UPDATE_DATE := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(sysdate,p_interface_line_rec.org_id);
3414: ELSE
3415: x_interface_scredit_rec.CREATION_DATE := sysdate;
3416: x_interface_scredit_rec.LAST_UPDATE_DATE := sysdate;

Line 3413: x_interface_scredit_rec.LAST_UPDATE_DATE := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(sysdate,p_interface_line_rec.org_id);

3409: END IF;
3410:
3411: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
3412: x_interface_scredit_rec.CREATION_DATE := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(sysdate,p_interface_line_rec.org_id);
3413: x_interface_scredit_rec.LAST_UPDATE_DATE := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(sysdate,p_interface_line_rec.org_id);
3414: ELSE
3415: x_interface_scredit_rec.CREATION_DATE := sysdate;
3416: x_interface_scredit_rec.LAST_UPDATE_DATE := sysdate;
3417: END IF;

Line 3493: x_interface_scredit_rec.CREATION_DATE := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(sysdate,p_interface_line_rec.org_id);

3489: oe_debug_pub.add( 'ENTER HEADER PREPARE_SALESCREDIT_REC ( ) PROCEDURE ' , 5 ) ;
3490: END IF;
3491:
3492: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
3493: x_interface_scredit_rec.CREATION_DATE := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(sysdate,p_interface_line_rec.org_id);
3494: x_interface_scredit_rec.LAST_UPDATE_DATE := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(sysdate,p_interface_line_rec.org_id);
3495: ELSE
3496: x_interface_scredit_rec.CREATION_DATE := sysdate;
3497: x_interface_scredit_rec.LAST_UPDATE_DATE := sysdate;

Line 3494: x_interface_scredit_rec.LAST_UPDATE_DATE := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(sysdate,p_interface_line_rec.org_id);

3490: END IF;
3491:
3492: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
3493: x_interface_scredit_rec.CREATION_DATE := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(sysdate,p_interface_line_rec.org_id);
3494: x_interface_scredit_rec.LAST_UPDATE_DATE := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(sysdate,p_interface_line_rec.org_id);
3495: ELSE
3496: x_interface_scredit_rec.CREATION_DATE := sysdate;
3497: x_interface_scredit_rec.LAST_UPDATE_DATE := sysdate;
3498: END IF;

Line 3577: x_interface_scredit_rec.CREATION_DATE := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(sysdate,p_interface_line_rec.org_id);

3573: oe_debug_pub.add( 'SALES_CREDIT_TYPE_ID'||X_INTERFACE_SCREDIT_REC.SALES_CREDIT_TYPE_ID ) ;
3574: END IF;
3575:
3576: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
3577: x_interface_scredit_rec.CREATION_DATE := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(sysdate,p_interface_line_rec.org_id);
3578: x_interface_scredit_rec.LAST_UPDATE_DATE := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(sysdate,p_interface_line_rec.org_id);
3579: ELSE
3580: x_interface_scredit_rec.CREATION_DATE := sysdate;
3581: x_interface_scredit_rec.LAST_UPDATE_DATE := sysdate;

Line 3578: x_interface_scredit_rec.LAST_UPDATE_DATE := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(sysdate,p_interface_line_rec.org_id);

3574: END IF;
3575:
3576: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
3577: x_interface_scredit_rec.CREATION_DATE := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(sysdate,p_interface_line_rec.org_id);
3578: x_interface_scredit_rec.LAST_UPDATE_DATE := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(sysdate,p_interface_line_rec.org_id);
3579: ELSE
3580: x_interface_scredit_rec.CREATION_DATE := sysdate;
3581: x_interface_scredit_rec.LAST_UPDATE_DATE := sysdate;
3582: END IF;

Line 4183: x_interface_conts_rec.CREATION_DATE := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(sysdate,p_interface_line_rec.org_id);

4179: oe_debug_pub.add( 'Returning from prepare_contingencies - no contingency');
4180: END IF;
4181: RETURN;
4182: END IF;
4183: x_interface_conts_rec.CREATION_DATE := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(sysdate,p_interface_line_rec.org_id);
4184: x_interface_conts_rec.LAST_UPDATE_DATE:= INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(sysdate,p_interface_line_rec.org_id);
4185: x_interface_conts_rec.CREATED_BY := p_interface_line_rec.created_by;
4186: x_interface_conts_rec.LAST_UPDATED_BY := p_interface_line_rec.last_updated_by;
4187: x_interface_conts_rec.INTERFACE_LINE_CONTEXT := p_interface_line_rec.INTERFACE_LINE_CONTEXT;

Line 4184: x_interface_conts_rec.LAST_UPDATE_DATE:= INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(sysdate,p_interface_line_rec.org_id);

4180: END IF;
4181: RETURN;
4182: END IF;
4183: x_interface_conts_rec.CREATION_DATE := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(sysdate,p_interface_line_rec.org_id);
4184: x_interface_conts_rec.LAST_UPDATE_DATE:= INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(sysdate,p_interface_line_rec.org_id);
4185: x_interface_conts_rec.CREATED_BY := p_interface_line_rec.created_by;
4186: x_interface_conts_rec.LAST_UPDATED_BY := p_interface_line_rec.last_updated_by;
4187: x_interface_conts_rec.INTERFACE_LINE_CONTEXT := p_interface_line_rec.INTERFACE_LINE_CONTEXT;
4188: x_interface_conts_rec.INTERFACE_LINE_ATTRIBUTE1 := p_interface_line_rec.INTERFACE_LINE_ATTRIBUTE1;

Line 4211: x_interface_conts_rec.EXPIRATION_DATE := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(x_interface_conts_rec.EXPIRATION_DATE,p_line_rec.org_id);

4207: x_interface_conts_rec.COMPLETED_FLAG := 'Y';
4208: END IF;
4209: /* commenting out because AR does not support expiration date on ar_interface_conts_all at this point of time. See bug# 5026580
4210: IF x_interface_conts_rec.EXPIRATION_DATE IS NOT NULL THEN
4211: x_interface_conts_rec.EXPIRATION_DATE := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(x_interface_conts_rec.EXPIRATION_DATE,p_line_rec.org_id);
4212: x_interface_conts_rec.COMPLETED_FLAG := 'Y';
4213: ELSE -- bug# 5049677
4214: x_interface_conts_rec.expiration_days := nvl(p_line_rec.REVREC_EXPIRATION_DAYS, l_expiration_days);
4215: END IF; */

Line 7404: p_x_interface_line_rec.ship_date_actual := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(p_x_interface_line_rec.ship_date_actual,p_line_rec.org_id);

7400:
7401: IF oe_code_control.code_release_level >= '110510' THEN
7402: IF p_line_rec.org_id IS NOT NULL THEN
7403: IF p_x_interface_line_rec.ship_date_actual IS NOT NULL THEN
7404: p_x_interface_line_rec.ship_date_actual := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(p_x_interface_line_rec.ship_date_actual,p_line_rec.org_id);
7405: END IF;
7406: IF p_x_interface_line_rec.creation_date IS NOT NULL THEN
7407: p_x_interface_line_rec.creation_date := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(p_x_interface_line_rec.creation_date,p_line_rec.org_id);
7408: END IF;

Line 7407: p_x_interface_line_rec.creation_date := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(p_x_interface_line_rec.creation_date,p_line_rec.org_id);

7403: IF p_x_interface_line_rec.ship_date_actual IS NOT NULL THEN
7404: p_x_interface_line_rec.ship_date_actual := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(p_x_interface_line_rec.ship_date_actual,p_line_rec.org_id);
7405: END IF;
7406: IF p_x_interface_line_rec.creation_date IS NOT NULL THEN
7407: p_x_interface_line_rec.creation_date := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(p_x_interface_line_rec.creation_date,p_line_rec.org_id);
7408: END IF;
7409: IF p_x_interface_line_rec.last_update_date IS NOT NULL THEN
7410: p_x_interface_line_rec.last_update_date := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(p_x_interface_line_rec.last_update_date,p_line_rec.org_id);
7411: END IF;

Line 7410: p_x_interface_line_rec.last_update_date := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(p_x_interface_line_rec.last_update_date,p_line_rec.org_id);

7406: IF p_x_interface_line_rec.creation_date IS NOT NULL THEN
7407: p_x_interface_line_rec.creation_date := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(p_x_interface_line_rec.creation_date,p_line_rec.org_id);
7408: END IF;
7409: IF p_x_interface_line_rec.last_update_date IS NOT NULL THEN
7410: p_x_interface_line_rec.last_update_date := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(p_x_interface_line_rec.last_update_date,p_line_rec.org_id);
7411: END IF;
7412: IF p_x_interface_line_rec.GL_Date IS NOT NULL THEN
7413: p_x_interface_line_rec.GL_Date := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(p_x_interface_line_rec.GL_Date,p_line_rec.org_id);
7414: END IF;

Line 7413: p_x_interface_line_rec.GL_Date := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(p_x_interface_line_rec.GL_Date,p_line_rec.org_id);

7409: IF p_x_interface_line_rec.last_update_date IS NOT NULL THEN
7410: p_x_interface_line_rec.last_update_date := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(p_x_interface_line_rec.last_update_date,p_line_rec.org_id);
7411: END IF;
7412: IF p_x_interface_line_rec.GL_Date IS NOT NULL THEN
7413: p_x_interface_line_rec.GL_Date := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(p_x_interface_line_rec.GL_Date,p_line_rec.org_id);
7414: END IF;
7415: IF p_x_interface_line_rec.conversion_date IS NOT NULL THEN
7416: p_x_interface_line_rec.conversion_date := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(p_x_interface_line_rec.conversion_date,p_line_rec.org_id);
7417: END IF;

Line 7416: p_x_interface_line_rec.conversion_date := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(p_x_interface_line_rec.conversion_date,p_line_rec.org_id);

7412: IF p_x_interface_line_rec.GL_Date IS NOT NULL THEN
7413: p_x_interface_line_rec.GL_Date := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(p_x_interface_line_rec.GL_Date,p_line_rec.org_id);
7414: END IF;
7415: IF p_x_interface_line_rec.conversion_date IS NOT NULL THEN
7416: p_x_interface_line_rec.conversion_date := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(p_x_interface_line_rec.conversion_date,p_line_rec.org_id);
7417: END IF;
7418: IF p_x_interface_line_rec.sales_order_date IS NOT NULL THEN
7419: p_x_interface_line_rec.sales_order_date := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(p_x_interface_line_rec.sales_order_date,p_line_rec.org_id);
7420: END IF;

Line 7419: p_x_interface_line_rec.sales_order_date := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(p_x_interface_line_rec.sales_order_date,p_line_rec.org_id);

7415: IF p_x_interface_line_rec.conversion_date IS NOT NULL THEN
7416: p_x_interface_line_rec.conversion_date := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(p_x_interface_line_rec.conversion_date,p_line_rec.org_id);
7417: END IF;
7418: IF p_x_interface_line_rec.sales_order_date IS NOT NULL THEN
7419: p_x_interface_line_rec.sales_order_date := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(p_x_interface_line_rec.sales_order_date,p_line_rec.org_id);
7420: END IF;
7421: IF p_x_interface_line_rec.rule_start_date IS NOT NULL THEN
7422: p_x_interface_line_rec.rule_start_date := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(p_x_interface_line_rec.rule_start_date,p_line_rec.org_id);
7423: END IF;

Line 7422: p_x_interface_line_rec.rule_start_date := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(p_x_interface_line_rec.rule_start_date,p_line_rec.org_id);

7418: IF p_x_interface_line_rec.sales_order_date IS NOT NULL THEN
7419: p_x_interface_line_rec.sales_order_date := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(p_x_interface_line_rec.sales_order_date,p_line_rec.org_id);
7420: END IF;
7421: IF p_x_interface_line_rec.rule_start_date IS NOT NULL THEN
7422: p_x_interface_line_rec.rule_start_date := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(p_x_interface_line_rec.rule_start_date,p_line_rec.org_id);
7423: END IF;
7424: IF p_x_interface_line_rec.rule_end_date IS NOT NULL THEN
7425: p_x_interface_line_rec.rule_end_date := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(p_x_interface_line_rec.rule_end_date,p_line_rec.org_id);
7426: END IF;

Line 7425: p_x_interface_line_rec.rule_end_date := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(p_x_interface_line_rec.rule_end_date,p_line_rec.org_id);

7421: IF p_x_interface_line_rec.rule_start_date IS NOT NULL THEN
7422: p_x_interface_line_rec.rule_start_date := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(p_x_interface_line_rec.rule_start_date,p_line_rec.org_id);
7423: END IF;
7424: IF p_x_interface_line_rec.rule_end_date IS NOT NULL THEN
7425: p_x_interface_line_rec.rule_end_date := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(p_x_interface_line_rec.rule_end_date,p_line_rec.org_id);
7426: END IF;
7427: IF p_x_interface_line_rec.trx_date IS NOT NULL THEN
7428: p_x_interface_line_rec.trx_date := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(p_x_interface_line_rec.trx_date,p_line_rec.org_id);
7429: END IF;

Line 7428: p_x_interface_line_rec.trx_date := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(p_x_interface_line_rec.trx_date,p_line_rec.org_id);

7424: IF p_x_interface_line_rec.rule_end_date IS NOT NULL THEN
7425: p_x_interface_line_rec.rule_end_date := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(p_x_interface_line_rec.rule_end_date,p_line_rec.org_id);
7426: END IF;
7427: IF p_x_interface_line_rec.trx_date IS NOT NULL THEN
7428: p_x_interface_line_rec.trx_date := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(p_x_interface_line_rec.trx_date,p_line_rec.org_id);
7429: END IF;
7430: END IF;
7431: END IF;
7432: