[Home] [Help]
4645: l_association_id ego_obj_ag_assocs_b.association_id%TYPE := null;
4646: l_return_status VARCHAR2(1);
4647: l_return_status2 VARCHAR2(1);
4648: l_locking_party_id NUMBER;
4649: l_lock_flag ego_object_lock.lock_flag%TYPE;
4650: l_user_name ego_user_v.party_name%TYPE;
4651:
4652:
4653: -- for error logging
5467:
5468: ---- Lock the draft version
5469: ----
5470: l_party_id := Get_party_id ( p_user_id => G_USER_ID);
5471: INSERT INTO EGO_OBJECT_LOCK
5472: ( lock_id,
5473: object_name,
5474: pk1_value,
5475: locking_party_id,
5478: creation_date,
5479: last_updated_by,
5480: last_update_date,
5481: last_update_login)
5482: VALUES ( EGO_OBJECT_LOCK_S.NEXTVAL,
5483: l_obj_name,
5484: p_item_catalog_id,
5485: l_party_id,
5486: 'L',
7470: l_proc_name CONSTANT VARCHAR2(30) := 'Sync_Draft_Version';
7471: l_msg_count NUMBER := 0;
7472: l_msg_data VARCHAR2(4000);
7473: l_entity_code VARCHAR2(30) := G_ENTITY_ICC_VERSION;
7474: l_locking_party_id ego_object_lock.locking_party_id%TYPE;
7475: l_lock_flag ego_object_lock.lock_flag%TYPE;
7476: e_stop_processing EXCEPTION;
7477: l_return_status VARCHAR2(1);
7478: l_return_msg VARCHAR2(2000);
7471: l_msg_count NUMBER := 0;
7472: l_msg_data VARCHAR2(4000);
7473: l_entity_code VARCHAR2(30) := G_ENTITY_ICC_VERSION;
7474: l_locking_party_id ego_object_lock.locking_party_id%TYPE;
7475: l_lock_flag ego_object_lock.lock_flag%TYPE;
7476: e_stop_processing EXCEPTION;
7477: l_return_status VARCHAR2(1);
7478: l_return_msg VARCHAR2(2000);
7479:
9346: IS
9347: CURSOR cur_seq_id
9348: IS
9349: SELECT MAX(l.lock_id) lock_id
9350: FROM EGO_OBJECT_LOCK l
9351: WHERE l.pk1_value = p_icc_id
9352: AND l.object_name = G_ENTITY_ICC_LOCK
9353: ;
9354: BEGIN