APPS.CZ_DEVELOPER_UTILS_PVT dependencies on CZ_PS_PROP_VALS

Line 1056: INSERT INTO CZ_PS_PROP_VALS(

1052: );
1053:
1054: -- copy ps node property values, if any
1055:
1056: INSERT INTO CZ_PS_PROP_VALS(
1057: PS_NODE_ID
1058: ,PROPERTY_ID
1059: ,DATA_VALUE
1060: ,DELETED_FLAG

Line 1081: FROM CZ_PS_PROP_VALS

1077: ,EFF_MASK
1078: ,CHECKOUT_USER
1079: ,NULL
1080: ,DATA_NUM_VALUE
1081: FROM CZ_PS_PROP_VALS
1082: WHERE PS_NODE_ID=l_index
1083: AND DELETED_FLAG='0';
1084:
1085: -- Bug 12567226

Line 1088: FROM cz_properties prop, cz_ps_prop_vals propval

1084:
1085: -- Bug 12567226
1086: -- Create new text if the type is translateable text
1087: FOR pspropval IN (SELECT propval.property_id, propval.data_num_value
1088: FROM cz_properties prop, cz_ps_prop_vals propval
1089: WHERE prop.property_id = propval.property_id
1090: AND propval.ps_node_id = l_new_node_id
1091: AND prop.data_type=8
1092: AND propval.deleted_flag = 0

Line 1103: UPDATE cz_ps_prop_vals

1099: IF l_new_intl_text_id = -1 THEN
1100: RAISE NO_TXT_FOUND_EXCP;
1101: END IF;
1102:
1103: UPDATE cz_ps_prop_vals
1104: SET data_num_value = l_new_intl_text_id
1105: WHERE property_id= pspropval.property_id
1106: AND ps_node_id = l_new_node_id;
1107:

Line 8072: FROM cz_ps_prop_vals psp,

8068: AND cz_rp_entries.deleted_flag = '0';
8069:
8070: SELECT devl_project_id BULK COLLECT INTO l_devl_project_tbl
8071: FROM (SELECT devl_project_id
8072: FROM cz_ps_prop_vals psp,
8073: cz_ps_nodes ps
8074: WHERE psp.deleted_flag = '0'
8075: AND ps.deleted_flag = '0'
8076: AND ps.ps_node_id = psp.ps_node_id