DBA Data[Home] [Help]

APPS.OE_INVOICE_PUB dependencies on INV_LE_TIMEZONE_PUB

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

3637: oe_debug_pub.add( 'ENTER LINE PREPARE_SALESCREDIT_REC ( ) PROCEDURE' , 5 ) ;
3638: END IF;
3639:
3640: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
3641: x_interface_scredit_rec.CREATION_DATE := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(sysdate,p_interface_line_rec.org_id);
3642: x_interface_scredit_rec.LAST_UPDATE_DATE := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(sysdate,p_interface_line_rec.org_id);
3643: ELSE
3644: x_interface_scredit_rec.CREATION_DATE := sysdate;
3645: x_interface_scredit_rec.LAST_UPDATE_DATE := sysdate;

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

3638: END IF;
3639:
3640: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
3641: x_interface_scredit_rec.CREATION_DATE := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(sysdate,p_interface_line_rec.org_id);
3642: x_interface_scredit_rec.LAST_UPDATE_DATE := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(sysdate,p_interface_line_rec.org_id);
3643: ELSE
3644: x_interface_scredit_rec.CREATION_DATE := sysdate;
3645: x_interface_scredit_rec.LAST_UPDATE_DATE := sysdate;
3646: END IF;

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

3718: oe_debug_pub.add( 'ENTER HEADER PREPARE_SALESCREDIT_REC ( ) PROCEDURE ' , 5 ) ;
3719: END IF;
3720:
3721: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
3722: x_interface_scredit_rec.CREATION_DATE := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(sysdate,p_interface_line_rec.org_id);
3723: x_interface_scredit_rec.LAST_UPDATE_DATE := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(sysdate,p_interface_line_rec.org_id);
3724: ELSE
3725: x_interface_scredit_rec.CREATION_DATE := sysdate;
3726: x_interface_scredit_rec.LAST_UPDATE_DATE := sysdate;

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

3719: END IF;
3720:
3721: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
3722: x_interface_scredit_rec.CREATION_DATE := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(sysdate,p_interface_line_rec.org_id);
3723: x_interface_scredit_rec.LAST_UPDATE_DATE := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(sysdate,p_interface_line_rec.org_id);
3724: ELSE
3725: x_interface_scredit_rec.CREATION_DATE := sysdate;
3726: x_interface_scredit_rec.LAST_UPDATE_DATE := sysdate;
3727: END IF;

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

3802: oe_debug_pub.add( 'SALES_CREDIT_TYPE_ID'||X_INTERFACE_SCREDIT_REC.SALES_CREDIT_TYPE_ID ) ;
3803: END IF;
3804:
3805: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
3806: x_interface_scredit_rec.CREATION_DATE := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(sysdate,p_interface_line_rec.org_id);
3807: x_interface_scredit_rec.LAST_UPDATE_DATE := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(sysdate,p_interface_line_rec.org_id);
3808: ELSE
3809: x_interface_scredit_rec.CREATION_DATE := sysdate;
3810: x_interface_scredit_rec.LAST_UPDATE_DATE := sysdate;

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

3803: END IF;
3804:
3805: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110510' THEN
3806: x_interface_scredit_rec.CREATION_DATE := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(sysdate,p_interface_line_rec.org_id);
3807: x_interface_scredit_rec.LAST_UPDATE_DATE := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(sysdate,p_interface_line_rec.org_id);
3808: ELSE
3809: x_interface_scredit_rec.CREATION_DATE := sysdate;
3810: x_interface_scredit_rec.LAST_UPDATE_DATE := sysdate;
3811: END IF;

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

4408: oe_debug_pub.add( 'Returning from prepare_contingencies - no contingency');
4409: END IF;
4410: RETURN;
4411: END IF;
4412: x_interface_conts_rec.CREATION_DATE := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(sysdate,p_interface_line_rec.org_id);
4413: x_interface_conts_rec.LAST_UPDATE_DATE:= INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(sysdate,p_interface_line_rec.org_id);
4414: x_interface_conts_rec.CREATED_BY := p_interface_line_rec.created_by;
4415: x_interface_conts_rec.LAST_UPDATED_BY := p_interface_line_rec.last_updated_by;
4416: x_interface_conts_rec.INTERFACE_LINE_CONTEXT := p_interface_line_rec.INTERFACE_LINE_CONTEXT;

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

4409: END IF;
4410: RETURN;
4411: END IF;
4412: x_interface_conts_rec.CREATION_DATE := INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(sysdate,p_interface_line_rec.org_id);
4413: x_interface_conts_rec.LAST_UPDATE_DATE:= INV_LE_TIMEZONE_PUB.Get_Le_Day_Time_For_Ou(sysdate,p_interface_line_rec.org_id);
4414: x_interface_conts_rec.CREATED_BY := p_interface_line_rec.created_by;
4415: x_interface_conts_rec.LAST_UPDATED_BY := p_interface_line_rec.last_updated_by;
4416: x_interface_conts_rec.INTERFACE_LINE_CONTEXT := p_interface_line_rec.INTERFACE_LINE_CONTEXT;
4417: x_interface_conts_rec.INTERFACE_LINE_ATTRIBUTE1 := p_interface_line_rec.INTERFACE_LINE_ATTRIBUTE1;

Line 4440: 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);

4436: x_interface_conts_rec.COMPLETED_FLAG := 'Y';
4437: END IF;
4438: /* commenting out because AR does not support expiration date on ar_interface_conts_all at this point of time. See bug# 5026580
4439: IF x_interface_conts_rec.EXPIRATION_DATE IS NOT NULL THEN
4440: 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);
4441: x_interface_conts_rec.COMPLETED_FLAG := 'Y';
4442: ELSE -- bug# 5049677
4443: x_interface_conts_rec.expiration_days := nvl(p_line_rec.REVREC_EXPIRATION_DAYS, l_expiration_days);
4444: END IF; */

Line 7692: 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);

7688:
7689: IF oe_code_control.code_release_level >= '110510' THEN
7690: IF p_line_rec.org_id IS NOT NULL THEN
7691: IF p_x_interface_line_rec.ship_date_actual IS NOT NULL THEN
7692: 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);
7693: END IF;
7694: IF p_x_interface_line_rec.creation_date IS NOT NULL THEN
7695: 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);
7696: END IF;

Line 7695: 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);

7691: IF p_x_interface_line_rec.ship_date_actual IS NOT NULL THEN
7692: 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);
7693: END IF;
7694: IF p_x_interface_line_rec.creation_date IS NOT NULL THEN
7695: 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);
7696: END IF;
7697: IF p_x_interface_line_rec.last_update_date IS NOT NULL THEN
7698: 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);
7699: END IF;

Line 7698: 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);

7694: IF p_x_interface_line_rec.creation_date IS NOT NULL THEN
7695: 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);
7696: END IF;
7697: IF p_x_interface_line_rec.last_update_date IS NOT NULL THEN
7698: 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);
7699: END IF;
7700: IF p_x_interface_line_rec.GL_Date IS NOT NULL THEN
7701: 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);
7702: END IF;

Line 7701: 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);

7697: IF p_x_interface_line_rec.last_update_date IS NOT NULL THEN
7698: 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);
7699: END IF;
7700: IF p_x_interface_line_rec.GL_Date IS NOT NULL THEN
7701: 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);
7702: END IF;
7703: IF p_x_interface_line_rec.conversion_date IS NOT NULL THEN
7704: 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);
7705: END IF;

Line 7704: 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);

7700: IF p_x_interface_line_rec.GL_Date IS NOT NULL THEN
7701: 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);
7702: END IF;
7703: IF p_x_interface_line_rec.conversion_date IS NOT NULL THEN
7704: 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);
7705: END IF;
7706: IF p_x_interface_line_rec.sales_order_date IS NOT NULL THEN
7707: 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);
7708: END IF;

Line 7707: 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);

7703: IF p_x_interface_line_rec.conversion_date IS NOT NULL THEN
7704: 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);
7705: END IF;
7706: IF p_x_interface_line_rec.sales_order_date IS NOT NULL THEN
7707: 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);
7708: END IF;
7709: IF p_x_interface_line_rec.rule_start_date IS NOT NULL THEN
7710: 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);
7711: END IF;

Line 7710: 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);

7706: IF p_x_interface_line_rec.sales_order_date IS NOT NULL THEN
7707: 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);
7708: END IF;
7709: IF p_x_interface_line_rec.rule_start_date IS NOT NULL THEN
7710: 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);
7711: END IF;
7712: IF p_x_interface_line_rec.rule_end_date IS NOT NULL THEN
7713: 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);
7714: END IF;

Line 7713: 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);

7709: IF p_x_interface_line_rec.rule_start_date IS NOT NULL THEN
7710: 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);
7711: END IF;
7712: IF p_x_interface_line_rec.rule_end_date IS NOT NULL THEN
7713: 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);
7714: END IF;
7715: IF p_x_interface_line_rec.trx_date IS NOT NULL THEN
7716: 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);
7717: END IF;

Line 7716: 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);

7712: IF p_x_interface_line_rec.rule_end_date IS NOT NULL THEN
7713: 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);
7714: END IF;
7715: IF p_x_interface_line_rec.trx_date IS NOT NULL THEN
7716: 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);
7717: END IF;
7718: END IF;
7719: END IF;
7720: