eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_SR_EVENT_PKG dependencies on CSI_IEA_VALUES

Line 466: CURSOR l_csi_iea_values_ins_csr(p_instance_id IN NUMBER)

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

Line 469: FROM csi_iea_values attrval,

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

Line 507: FOR r_csi_iea_values_ins_rec IN l_csi_iea_values_ins_csr(p_instance_id) LOOP

503:
504: END LOOP;
505:
506: -- process inserts of additional attributes
507: FOR r_csi_iea_values_ins_rec IN l_csi_iea_values_ins_csr(p_instance_id) LOOP
508: CSM_ACC_PKG.Insert_Acc
509: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
510: ,P_ACC_TABLE_NAME => g_acc_table_name1
511: ,P_SEQ_NAME => g_acc_sequence_name1

Line 513: ,P_PK1_NUM_VALUE => r_csi_iea_values_ins_rec.attribute_value_id

509: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
510: ,P_ACC_TABLE_NAME => g_acc_table_name1
511: ,P_SEQ_NAME => g_acc_sequence_name1
512: ,P_PK1_NAME => g_pk1_name1
513: ,P_PK1_NUM_VALUE => r_csi_iea_values_ins_rec.attribute_value_id
514: ,P_USER_ID => p_user_id
515: );
516: END LOOP;
517:

Line 731: CURSOR l_csi_iea_values_del_csr(p_instance_id IN NUMBER)

727: AND NVL(cii.active_end_date, p_transaction_date)
728: ;
729:
730: -- get additional IB attributes if existing to delete
731: CURSOR l_csi_iea_values_del_csr(p_instance_id IN NUMBER)
732: IS
733: SELECT attrval.attribute_value_id
734: FROM csi_iea_values attrval,
735: csi_i_extended_attribs attr

Line 734: FROM csi_iea_values attrval,

730: -- get additional IB attributes if existing to delete
731: CURSOR l_csi_iea_values_del_csr(p_instance_id IN NUMBER)
732: IS
733: SELECT attrval.attribute_value_id
734: FROM csi_iea_values attrval,
735: csi_i_extended_attribs attr
736: WHERE attrval.instance_id = p_instance_id
737: AND attrval.attribute_id = attr.attribute_id
738: AND SYSDATE BETWEEN NVL(attrval.active_start_date, SYSDATE) AND NVL(attrval.active_end_date, SYSDATE)

Line 771: FOR r_csi_iea_values_del_rec IN l_csi_iea_values_del_csr(p_instance_id) LOOP

767: l_return_status);
768: END LOOP;
769:
770: -- process deletes of additional attributes
771: FOR r_csi_iea_values_del_rec IN l_csi_iea_values_del_csr(p_instance_id) LOOP
772: CSM_ACC_PKG.Delete_acc
773: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
774: ,P_ACC_TABLE_NAME => g_acc_table_name1
775: ,P_PK1_NAME => g_pk1_name1

Line 776: ,P_PK1_NUM_VALUE => r_csi_iea_values_del_rec.attribute_value_id

772: CSM_ACC_PKG.Delete_acc
773: ( P_PUBLICATION_ITEM_NAMES => g_publication_item_name1
774: ,P_ACC_TABLE_NAME => g_acc_table_name1
775: ,P_PK1_NAME => g_pk1_name1
776: ,P_PK1_NUM_VALUE => r_csi_iea_values_del_rec.attribute_value_id
777: ,P_USER_ID => p_user_id
778: );
779: END LOOP;
780: