43: G_last_update_date Date;
44: G_sysdate Date := sysdate;
45: -------------------------------------------------------------------------------
46:
47: g1_debug_mode varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
48:
49: PROCEDURE Get_Transfer_Price
50: (
51: p_module_name IN VARCHAR2,
2070: IF g1_debug_mode = 'Y' THEN
2071: pa_debug.write_file('LOG',pa_debug.G_Err_Stage);
2072: END IF;
2073:
2074: G_created_by := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
2075: G_last_update_login := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')), -1);
2076: G_last_updated_by := G_created_by;
2077: G_creation_date := G_sysdate;
2078: G_last_update_date := G_sysdate ;
2071: pa_debug.write_file('LOG',pa_debug.G_Err_Stage);
2072: END IF;
2073:
2074: G_created_by := nvl(TO_NUMBER(FND_PROFILE.VALUE('USER_ID')),-1);
2075: G_last_update_login := nvl(TO_NUMBER(FND_PROFILE.VALUE('LOGIN_ID')), -1);
2076: G_last_updated_by := G_created_by;
2077: G_creation_date := G_sysdate;
2078: G_last_update_date := G_sysdate ;
2079: