APPS.CSI_INSTANCE_PARTIES_VLD_PVT dependencies on CSI_I_VERSION_LABELS

Line 1443: SELECT CSI_I_VERSION_LABELS_S.nextval

1439:
1440: l_version_label_id NUMBER;
1441:
1442: BEGIN
1443: SELECT CSI_I_VERSION_LABELS_S.nextval
1444: INTO l_version_label_id
1445: FROM sys.dual;
1446: RETURN l_version_label_id;
1447: END gen_ver_label_id;

Line 1452: /* exists in csi_i_version_labels */

1448:
1449: /*-----------------------------------------------------------*/
1450: /* Procedure name: Is_Ver_labelID_exists */
1451: /* Description : Check if the version_label_id */
1452: /* exists in csi_i_version_labels */
1453: /*-----------------------------------------------------------*/
1454:
1455: FUNCTION Is_Ver_labelID_exists
1456: ( p_version_label_id IN NUMBER,

Line 1465: FROM csi_i_version_labels

1461: l_return_value BOOLEAN := TRUE;
1462: BEGIN
1463: SELECT 'x'
1464: INTO l_dummy
1465: FROM csi_i_version_labels
1466: WHERE version_label_id = p_version_label_id
1467: and ((active_end_date is null) OR (active_end_date >= sysdate));
1468: IF ( p_stack_err_msg = TRUE ) THEN
1469: FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_VER_LABEL_ID');

Line 1491: SELECT CSI_I_VERSION_LABELS_H_S.nextval

1487: RETURN NUMBER IS
1488: l_version_label_hist_id NUMBER;
1489:
1490: BEGIN
1491: SELECT CSI_I_VERSION_LABELS_H_S.nextval
1492: INTO l_version_label_hist_id
1493: FROM sys.dual;
1494:
1495: RETURN l_version_label_hist_id;