APPS.OE_SYS_PARAMETERS_PVT dependencies on AR_SYSTEM_PARAMETERS_ALL

Line 129: l_AR_Sys_Param_Rec AR_SYSTEM_PARAMETERS_ALL%ROWTYPE;

125: SELECT NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1), ' ',
126: NULL, SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)
127: FROM DUAL;
128: */
129: l_AR_Sys_Param_Rec AR_SYSTEM_PARAMETERS_ALL%ROWTYPE;
130: l_table_index BINARY_INTEGER;
131:
132: --
133: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 453: RETURN AR_SYSTEM_PARAMETERS_ALL%ROWTYPE

449: */
450:
451: FUNCTION Get_AR_Sys_Params
452: (p_org_id IN NUMBER DEFAULT NULL)
453: RETURN AR_SYSTEM_PARAMETERS_ALL%ROWTYPE
454: IS
455: l_AR_Sys_Param_Rec AR_SYSTEM_PARAMETERS_ALL%ROWTYPE;
456: l_org_id NUMBER;
457: l_chk_clt_info NUMBER;

Line 455: l_AR_Sys_Param_Rec AR_SYSTEM_PARAMETERS_ALL%ROWTYPE;

451: FUNCTION Get_AR_Sys_Params
452: (p_org_id IN NUMBER DEFAULT NULL)
453: RETURN AR_SYSTEM_PARAMETERS_ALL%ROWTYPE
454: IS
455: l_AR_Sys_Param_Rec AR_SYSTEM_PARAMETERS_ALL%ROWTYPE;
456: l_org_id NUMBER;
457: l_chk_clt_info NUMBER;
458:
459: --

Line 517: FROM AR_SYSTEM_PARAMETERS_ALL

513: /* MOAC_SQL_CHANGE */
514: SELECT *
515: INTO
516: l_AR_Sys_Param_Rec
517: FROM AR_SYSTEM_PARAMETERS_ALL
518: WHERE org_id = l_org_id;
519: /*
520: WHERE NVL(ORG_ID,NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1 ,1),' ',
521: NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) =