DBA Data[Home] [Help]

APPS.PA_R_PROJECT_RESOURCES_PVT dependencies on PA_RESOURCES_S

Line 1133: P_START_DATE IN PA_RESOURCES.START_DATE_ACTIVE%TYPE,

1129: PROCEDURE INSERT_INTO_PA(
1130: P_RESOURCE_TYPE_ID IN PA_RESOURCE_TYPES.RESOURCE_TYPE_ID%TYPE,
1131: P_CRM_RESOURCE_ID IN PA_RESOURCES.JTF_RESOURCE_ID%TYPE,
1132: X_RESOURCE_ID OUT NOCOPY PA_RESOURCES.RESOURCE_ID%TYPE, --File.Sql.39 bug 4440895
1133: P_START_DATE IN PA_RESOURCES.START_DATE_ACTIVE%TYPE,
1134: P_END_DATE IN PA_RESOURCES.END_DATE_ACTIVE%TYPE DEFAULT NULL,
1135: P_PERSON_ID IN PA_RESOURCE_TXN_ATTRIBUTES.PERSON_ID%TYPE DEFAULT NULL,
1136: P_NAME IN PA_RESOURCES.NAME%TYPE,
1137: P_PARTY_ID IN PA_RESOURCE_TXN_ATTRIBUTES.PARTY_ID%TYPE DEFAULT NULL,

Line 1185: Select pa_resources_s.nextval

1181: X_RETURN_STATUS := fnd_api.g_ret_sts_success;
1182:
1183: --Fetch unique resource_id from sequence.
1184: LOOP
1185: Select pa_resources_s.nextval
1186: into x_resource_id
1187: from dual;
1188:
1189: OPEN c_dup_resource_id(x_resource_id);