APPS.CSI_INSTANCE_PARTIES_VLD_PVT dependencies on CSI_I_ASSETS

Line 1511: SELECT CSI_I_ASSETS_S.nextval

1507:
1508: l_inst_asset_id NUMBER;
1509:
1510: BEGIN
1511: SELECT CSI_I_ASSETS_S.nextval
1512: INTO l_inst_asset_id
1513: FROM sys.dual;
1514:
1515: RETURN l_inst_asset_id;

Line 1522: /* exists in csi_i_assets */

1518:
1519: /*-----------------------------------------------------------*/
1520: /* Procedure name: Is_Inst_assetID_exists */
1521: /* Description : Check if the instance asset id */
1522: /* exists in csi_i_assets */
1523: /*-----------------------------------------------------------*/
1524:
1525: FUNCTION Is_Inst_assetID_exists
1526:

Line 1536: FROM csi_i_assets

1532: l_return_value BOOLEAN := TRUE;
1533: BEGIN
1534: SELECT 'x'
1535: INTO l_dummy
1536: FROM csi_i_assets
1537: WHERE instance_asset_id = p_instance_asset_id ;
1538:
1539: IF ( p_stack_err_msg = TRUE ) THEN
1540: FND_MESSAGE.SET_NAME('CSI','CSI_API_INV_INST_ASSET_ID');

Line 1626: SELECT CSI_I_ASSETS_H_S.nextval

1622:
1623: l_inst_asset_hist_id NUMBER;
1624:
1625: BEGIN
1626: SELECT CSI_I_ASSETS_H_S.nextval
1627: INTO l_inst_asset_hist_id
1628: FROM sys.dual;
1629: RETURN l_inst_asset_hist_id;
1630: END gen_inst_asset_hist_id;