DBA Data[Home] [Help]

APPS.CSI_T_VLDN_ROUTINES_PVT dependencies on CSI_I_PARTIES

Line 462: /* validate instance party id from csi_i_parties */

458: x_return_status := fnd_api.g_ret_sts_error;
459:
460: END validate_ii_rltns_type_code;
461:
462: /* validate instance party id from csi_i_parties */
463: PROCEDURE validate_instance_party_id(
464: p_instance_id IN number,
465: p_instance_party_id IN number,
466: x_return_status OUT NOCOPY VARCHAR2)

Line 473: FROM csi_i_parties

469: BEGIN
470:
471: SELECT 'X'
472: INTO v_found
473: FROM csi_i_parties
474: WHERE instance_id = p_instance_id
475: AND instance_party_id = p_instance_party_id;
476:
477: x_return_status := fnd_api.g_ret_sts_success;

Line 1260: FROM csi_i_parties

1256: l_csi_instance_id csi_t_party_details.instance_party_id%TYPE;
1257:
1258: CURSOR csi_pty_cur(p_csi_instance_id IN NUMBER) IS
1259: SELECT instance_party_id
1260: FROM csi_i_parties
1261: WHERE instance_id = p_csi_instance_id
1262: AND relationship_type_code = 'OWNER';
1263:
1264: BEGIN