1027: -- ----------------------------------------------------------------------------
1028: -- Assign user_id and login_id to the local variables
1029: -- ----------------------------------------------------------------------------
1030:
1031: g_user_id := fnd_global.user_id;
1032: g_login_id := fnd_global.login_id;
1033: put_debug_msg (
1034: ' Retrieved the instance code :'
1035: || g_instance_code
1028: -- Assign user_id and login_id to the local variables
1029: -- ----------------------------------------------------------------------------
1030:
1031: g_user_id := fnd_global.user_id;
1032: g_login_id := fnd_global.login_id;
1033: put_debug_msg (
1034: ' Retrieved the instance code :'
1035: || g_instance_code
1036: );
1103: put_debug_msg (l_stmt);
1104: OPEN cv FOR l_stmt USING g_object_name;
1105: FETCH cv INTO l_elementid;
1106: CLOSE cv;
1107: l_conc_id := fnd_global.conc_request_id;
1108: cid := DBMS_SQL.open_cursor;
1109: /* Insert into the Detail */
1110: l_stmt :=
1111: 'INSERT INTO EDW_Push_Detail_Log@'