DBA Data[Home] [Help]

APPS.PATC dependencies on PA_MOAC_UTILS

Line 1138: We using pa_moac_utils.get_current_org_id;

1134: /* Modified the following select statement for bug 3620355
1135: select to_number(SUBSTR(USERENV('CLIENT_INFO'),1,10)) into l_prvdr_org_id from dual; */
1136: /* Begin Bug 5214766
1137: We no longer use client info to get the operating_unit in r12 due to MOAC being introduced.
1138: We using pa_moac_utils.get_current_org_id;
1139: select to_number(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' '
1140: ,NULL ,SUBSTRB(USERENV('CLIENT_INFO'),1,10))) into l_prvdr_org_id from dual;
1141: */
1142: l_prvdr_org_id := pa_moac_utils.get_current_org_id;

Line 1142: l_prvdr_org_id := pa_moac_utils.get_current_org_id;

1138: We using pa_moac_utils.get_current_org_id;
1139: select to_number(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' '
1140: ,NULL ,SUBSTRB(USERENV('CLIENT_INFO'),1,10))) into l_prvdr_org_id from dual;
1141: */
1142: l_prvdr_org_id := pa_moac_utils.get_current_org_id;
1143: /* End bug 5214766*/ /*14621140 - Added a closing brace here other wise get pa date was not getting called*/
1144:
1145: /* Added for bug 15953273 */
1146: IF l_prvdr_org_id IS NULL THEN