11: )
12: IS
13: BEGIN
14: x_creation_date := sysdate;
15: x_created_by := fnd_global.user_id();
16: x_last_update_date := sysdate;
17: x_last_updated_by := fnd_global.user_id();
18: x_last_update_login := fnd_global.login_id();
19: END GET_WHO_COLUMNS;
13: BEGIN
14: x_creation_date := sysdate;
15: x_created_by := fnd_global.user_id();
16: x_last_update_date := sysdate;
17: x_last_updated_by := fnd_global.user_id();
18: x_last_update_login := fnd_global.login_id();
19: END GET_WHO_COLUMNS;
20:
21:
14: x_creation_date := sysdate;
15: x_created_by := fnd_global.user_id();
16: x_last_update_date := sysdate;
17: x_last_updated_by := fnd_global.user_id();
18: x_last_update_login := fnd_global.login_id();
19: END GET_WHO_COLUMNS;
20:
21:
22:
142: SELECT oav.organization_code,
143: oav.organization_name
144: FROM org_access_view oav
145: WHERE oav.organization_id = P_ORG_ID
146: AND oav.responsibility_id = fnd_global.resp_id
147: and oav.resp_application_id = fnd_global.resp_appl_id;
148:
149: BEGIN
150: OPEN get_org_details;
143: oav.organization_name
144: FROM org_access_view oav
145: WHERE oav.organization_id = P_ORG_ID
146: AND oav.responsibility_id = fnd_global.resp_id
147: and oav.resp_application_id = fnd_global.resp_appl_id;
148:
149: BEGIN
150: OPEN get_org_details;
151: FETCH get_org_details into X_ORG_CODE, X_ORG_NAME;