APPS.CSM_SR_EVENT_PKG dependencies on CSI_IEA_VALUES

Line 469: CURSOR l_csi_iea_values_ins_csr(p_instance_id IN NUMBER)

465: AND NVL(cii.active_end_date, p_transaction_date)
466: ;
467:
468: -- get additional IB attributes if existing
469: CURSOR l_csi_iea_values_ins_csr(p_instance_id IN NUMBER)
470: IS
471: SELECT attrval.attribute_value_id
472: FROM csi_iea_values attrval,
473: csi_i_extended_attribs attr

Line 472: FROM csi_iea_values attrval,

468: -- get additional IB attributes if existing
469: CURSOR l_csi_iea_values_ins_csr(p_instance_id IN NUMBER)
470: IS
471: SELECT attrval.attribute_value_id
472: FROM csi_iea_values attrval,
473: csi_i_extended_attribs attr
474: WHERE attrval.instance_id = p_instance_id
475: AND attrval.attribute_id = attr.attribute_id
476: AND SYSDATE BETWEEN NVL(attrval.active_start_date, SYSDATE) AND NVL(attrval.active_end_date, SYSDATE)

Line 514: FOR r_csi_iea_values_ins_rec IN l_csi_iea_values_ins_csr(p_instance_id) LOOP

510:
511:
512: IF NOT l_htm5_user THEN
513: -- process inserts of additional attributes
514: FOR r_csi_iea_values_ins_rec IN l_csi_iea_values_ins_csr(p_instance_id) LOOP
515: CSM_ACC_PKG.Insert_Acc
516: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
517: ,P_ACC_TABLE_NAME => g_acc_table_name1
518: ,P_SEQ_NAME => g_acc_sequence_name1

Line 520: ,P_PK1_NUM_VALUE => r_csi_iea_values_ins_rec.attribute_value_id

516: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
517: ,P_ACC_TABLE_NAME => g_acc_table_name1
518: ,P_SEQ_NAME => g_acc_sequence_name1
519: ,P_PK1_NAME => g_pk1_name1
520: ,P_PK1_NUM_VALUE => r_csi_iea_values_ins_rec.attribute_value_id
521: ,P_USER_ID => p_user_id
522: );
523: END LOOP;
524: END IF;

Line 739: CURSOR l_csi_iea_values_del_csr(p_instance_id IN NUMBER)

735: where acc.relationship_id = cir.relationship_id
736: and acc.user_id=p_user_id);
737:
738: -- get additional IB attributes if existing to delete
739: CURSOR l_csi_iea_values_del_csr(p_instance_id IN NUMBER)
740: IS
741: SELECT attrval.attribute_value_id
742: FROM csi_iea_values attrval,
743: csi_i_extended_attribs attr

Line 742: FROM csi_iea_values attrval,

738: -- get additional IB attributes if existing to delete
739: CURSOR l_csi_iea_values_del_csr(p_instance_id IN NUMBER)
740: IS
741: SELECT attrval.attribute_value_id
742: FROM csi_iea_values attrval,
743: csi_i_extended_attribs attr
744: WHERE attrval.instance_id = p_instance_id
745: AND attrval.attribute_id = attr.attribute_id
746: AND EXISTS(SELECT 1 FROM CSM_CSI_ITEM_ATTR_ACC acc

Line 781: FOR r_csi_iea_values_del_rec IN l_csi_iea_values_del_csr(p_instance_id) LOOP

777: END LOOP;
778:
779: IF NOT l_htm5_user THEN
780: -- process deletes of additional attributes
781: FOR r_csi_iea_values_del_rec IN l_csi_iea_values_del_csr(p_instance_id) LOOP
782: CSM_ACC_PKG.Delete_acc
783: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
784: ,P_ACC_TABLE_NAME => g_acc_table_name1
785: ,P_PK1_NAME => g_pk1_name1

Line 786: ,P_PK1_NUM_VALUE => r_csi_iea_values_del_rec.attribute_value_id

782: CSM_ACC_PKG.Delete_acc
783: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
784: ,P_ACC_TABLE_NAME => g_acc_table_name1
785: ,P_PK1_NAME => g_pk1_name1
786: ,P_PK1_NUM_VALUE => r_csi_iea_values_del_rec.attribute_value_id
787: ,P_USER_ID => p_user_id
788: );
789: END LOOP;
790: END IF;