[Home] [Help]
3163: p_ieu_enum_type_uuid IN VARCHAR2 DEFAULT NULL,
3164: p_work_item_status IN VARCHAR2 DEFAULT NULL,
3165: p_user_id IN NUMBER DEFAULT NULL,
3166: p_login_id IN NUMBER DEFAULT NULL,
3167: p_audit_trail_rec IN SYSTEM.WR_AUDIT_TRAIL_NST,
3168: x_work_item_id OUT NOCOPY NUMBER,
3169: x_msg_count OUT NOCOPY NUMBER,
3170: x_msg_data OUT NOCOPY VARCHAR2,
3171: x_return_status OUT NOCOPY VARCHAR2) AS
3247: l_assct_ws_code VARCHAR2(50);
3248: L_LOG_DIST_FROM VARCHAR(100);
3249: L_LOG_DIST_TO VARCHAR2(100);
3250: l_return_status VARCHAR2(10);
3251: l_audit_trail_rec SYSTEM.WR_AUDIT_TRAIL_NST;
3252: l_prev_source_object_id NUMBER;
3253: l_prev_source_object_type_code VARCHAR2(30);
3254:
3255: l_audit_log_val VARCHAR2(100);
4123: if ( l_wr_item_list.count > 0)
4124: then
4125:
4126: l_event_key := null;
4127: l_audit_trail_rec := SYSTEM.WR_AUDIT_TRAIL_NST();
4128: l_audit_trail_rec.extend;
4129: l_audit_trail_rec(l_audit_trail_rec.LAST) := SYSTEM.WR_AUDIT_TRAIL_OBJ
4130: (l_action_key,
4131: l_event_key,
4463: p_application_id IN NUMBER DEFAULT NULL,
4464: p_work_item_status IN VARCHAR2 DEFAULT NULL,
4465: p_user_id IN NUMBER DEFAULT NULL,
4466: p_login_id IN NUMBER DEFAULT NULL,
4467: p_audit_trail_rec IN SYSTEM.WR_AUDIT_TRAIL_NST,
4468: x_msg_count OUT NOCOPY NUMBER,
4469: x_msg_data OUT NOCOPY VARCHAR2,
4470: x_return_status OUT NOCOPY VARCHAR2) AS
4471:
4568: L_LOG_DIST_FROM VARCHAR(100);
4569: L_LOG_DIST_TO VARCHAR2(100);
4570: l_return_status VARCHAR2(10);
4571:
4572: l_audit_trail_rec SYSTEM.WR_AUDIT_TRAIL_NST;
4573: l_prev_source_object_id NUMBER;
4574: l_prev_source_object_type_code VARCHAR2(30);
4575: l_audit_log_id NUMBER;
4576:
5681: end loop;
5682:
5683: if ( l_wr_item_list.count > 0)
5684: then
5685: l_audit_trail_rec := SYSTEM.WR_AUDIT_TRAIL_NST();
5686: l_audit_trail_rec.extend;
5687:
5688: if p_audit_trail_rec.count > 0
5689: then
6045: p_work_item_id IN NUMBER DEFAULT NULL,
6046: p_reschedule_time IN DATE DEFAULT NULL,
6047: p_user_id IN NUMBER DEFAULT NULL,
6048: p_login_id IN NUMBER DEFAULT NULL,
6049: -- p_audit_trail_rec IN SYSTEM.WR_AUDIT_TRAIL_NST,
6050: x_msg_count OUT NOCOPY NUMBER,
6051: x_msg_data OUT NOCOPY VARCHAR2,
6052: x_return_status OUT NOCOPY VARCHAR2) AS
6053:
6703: ( p_api_version IN NUMBER,
6704: p_init_msg_list IN VARCHAR2 DEFAULT NULL,
6705: p_commit IN VARCHAR2 DEFAULT NULL,
6706: p_ws_code IN VARCHAR2 DEFAULT NULL,
6707: p_audit_trail_rec IN SYSTEM.WR_AUDIT_TRAIL_NST,
6708: x_msg_count OUT NOCOPY NUMBER,
6709: x_msg_data OUT NOCOPY VARCHAR2,
6710: x_return_status OUT NOCOPY VARCHAR2) AS
6711:
7816: p_resource_id IN NUMBER,
7817: p_language IN VARCHAR2,
7818: p_source_lang IN VARCHAR2,
7819: p_ws_det_list IN IEU_UWQ_GET_NEXT_WORK_PVT.IEU_WS_DETAILS_LIST,
7820: p_audit_trail_rec IN SYSTEM.WR_AUDIT_TRAIL_NST,
7821: x_uwqm_workitem_data OUT NOCOPY IEU_FRM_PVT.T_IEU_MEDIA_DATA,
7822: x_msg_count OUT NOCOPY NUMBER,
7823: x_msg_data OUT NOCOPY VARCHAR2,
7824: x_return_status OUT NOCOPY VARCHAR2) IS
8390: ( p_api_version IN NUMBER,
8391: p_init_msg_list IN VARCHAR2 DEFAULT NULL,
8392: p_commit IN VARCHAR2 DEFAULT NULL,
8393: p_wr_item_list IN IEU_WR_PUB.IEU_WR_ITEM_LIST ,
8394: p_audit_trail_rec IN SYSTEM.WR_AUDIT_TRAIL_NST,
8395: x_msg_count OUT NOCOPY NUMBER,
8396: x_msg_data OUT NOCOPY VARCHAR2,
8397: x_return_status OUT NOCOPY VARCHAR2) AS
8398:
9691: p_commit IN VARCHAR2 DEFAULT NULL,
9692: p_workitem_obj_code IN VARCHAR2,
9693: p_workitem_pk_id IN NUMBER,
9694: p_application_id IN NUMBER DEFAULT NULL,
9695: p_audit_trail_rec IN SYSTEM.WR_AUDIT_TRAIL_NST DEFAULT NULL,
9696: x_msg_count OUT NOCOPY NUMBER,
9697: x_msg_data OUT NOCOPY VARCHAR2,
9698: x_return_status OUT NOCOPY VARCHAR2) AS
9699:
9751: L_LOG_DIST_FROM VARCHAR(100);
9752: L_LOG_DIST_TO VARCHAR2(100);
9753: l_return_status VARCHAR2(10);
9754:
9755: l_audit_trail_rec SYSTEM.WR_AUDIT_TRAIL_NST;
9756: l_prev_source_object_id NUMBER;
9757: l_prev_source_object_type_code VARCHAR2(30);
9758: l_audit_log_id NUMBER;
9759: