1500: p_total_volume,
1501: p_weight_uom,
1502: p_volume_uom,
1503: SYSDATE,
1504: FND_GLOBAL.USER_ID,
1505: SYSDATE,
1506: FND_GLOBAL.USER_ID,
1507: FND_GLOBAL.LOGIN_ID,
1508: p_session_value);
1502: p_volume_uom,
1503: SYSDATE,
1504: FND_GLOBAL.USER_ID,
1505: SYSDATE,
1506: FND_GLOBAL.USER_ID,
1507: FND_GLOBAL.LOGIN_ID,
1508: p_session_value);
1509: ELSIF (p_action = 'UPDATE') THEN
1510:
1503: SYSDATE,
1504: FND_GLOBAL.USER_ID,
1505: SYSDATE,
1506: FND_GLOBAL.USER_ID,
1507: FND_GLOBAL.LOGIN_ID,
1508: p_session_value);
1509: ELSIF (p_action = 'UPDATE') THEN
1510:
1511: UPDATE FTE_TENDER_SNAPSHOT SET
1529: NULL,SESSION_VALUE,
1530: FND_API.G_MISS_CHAR,null,
1531: p_session_value),
1532: LAST_UPDATE_DATE = SYSDATE,
1533: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1534: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
1535: WHERE TRIP_ID = p_trip_id
1536: AND STOP_ID = p_stop_id
1537: AND LOAD_TENDER_NUMBER = p_tender_id;
1530: FND_API.G_MISS_CHAR,null,
1531: p_session_value),
1532: LAST_UPDATE_DATE = SYSDATE,
1533: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
1534: LAST_UPDATE_LOGIN = FND_GLOBAL.USER_ID
1535: WHERE TRIP_ID = p_trip_id
1536: AND STOP_ID = p_stop_id
1537: AND LOAD_TENDER_NUMBER = p_tender_id;
1538: ELSIF (p_action = 'DELETE') THEN
3275: x_exception_id => l_pdummy_exception_id ,
3276: p_logged_at_location_id => p_first_stop_location_id,
3277: p_exception_location_id => p_first_stop_location_id,
3278: p_logging_entity => 'SHIPPER',
3279: p_logging_entity_id => FND_GLOBAL.USER_ID,
3280: p_exception_name => l_pexception_name,
3281: p_message => l_pmsg,
3282: p_trip_id => p_tender_id
3283: );
3322: x_exception_id => l_ddummy_exception_id ,
3323: p_logged_at_location_id => p_last_stop_location_id,
3324: p_exception_location_id => p_last_stop_location_id,
3325: p_logging_entity => 'SHIPPER',
3326: p_logging_entity_id => FND_GLOBAL.USER_ID,
3327: p_exception_name => l_dexception_name,
3328: p_message => l_dmsg,
3329: p_trip_id => p_tender_id
3330: );
3796: p_value=> p_mbol_number,
3797: p_parameterlist=>l_parameter_list);
3798:
3799: wf_event.AddParameterToList(p_name=>'SHIPPER_NAME',
3800: p_value=> FND_GLOBAL.USER_NAME,
3801: p_parameterlist=>l_parameter_list);
3802:
3803: wf_event.AddParameterToList(p_name=> 'SHIPPER_USER_ID',
3804: p_value=> FND_GLOBAL.USER_ID,
3800: p_value=> FND_GLOBAL.USER_NAME,
3801: p_parameterlist=>l_parameter_list);
3802:
3803: wf_event.AddParameterToList(p_name=> 'SHIPPER_USER_ID',
3804: p_value=> FND_GLOBAL.USER_ID,
3805: p_parameterlist=>l_parameter_list);
3806:
3807: wf_event.AddParameterToList(p_name=> 'USER_ID',
3808: p_value=> FND_GLOBAL.USER_ID,
3804: p_value=> FND_GLOBAL.USER_ID,
3805: p_parameterlist=>l_parameter_list);
3806:
3807: wf_event.AddParameterToList(p_name=> 'USER_ID',
3808: p_value=> FND_GLOBAL.USER_ID,
3809: p_parameterlist=>l_parameter_list);
3810:
3811: wf_event.AddParameterToList(p_name=> 'RESPONSIBILITY_ID',
3812: p_value=> FND_GLOBAL.RESP_ID,
3808: p_value=> FND_GLOBAL.USER_ID,
3809: p_parameterlist=>l_parameter_list);
3810:
3811: wf_event.AddParameterToList(p_name=> 'RESPONSIBILITY_ID',
3812: p_value=> FND_GLOBAL.RESP_ID,
3813: p_parameterlist=>l_parameter_list);
3814:
3815: wf_event.AddParameterToList(p_name=> 'RESP_APPL_ID',
3816: p_value=> FND_GLOBAL.RESP_APPL_ID,
3812: p_value=> FND_GLOBAL.RESP_ID,
3813: p_parameterlist=>l_parameter_list);
3814:
3815: wf_event.AddParameterToList(p_name=> 'RESP_APPL_ID',
3816: p_value=> FND_GLOBAL.RESP_APPL_ID,
3817: p_parameterlist=>l_parameter_list);
3818:
3819:
3820: wf_event.AddParameterToList(p_name=> 'SHIPPER_RESP_ID',
3817: p_parameterlist=>l_parameter_list);
3818:
3819:
3820: wf_event.AddParameterToList(p_name=> 'SHIPPER_RESP_ID',
3821: p_value=> FND_GLOBAL.RESP_ID,
3822: p_parameterlist=>l_parameter_list);
3823:
3824:
3825: wf_event.AddParameterToList(p_name => 'CONTACT_PERFORMER',
4562: p_value => p_trip_info.trip_id,
4563: p_parameterlist => l_parameter_list);
4564:
4565: wf_event.AddParameterToList(p_name => 'CONTACT_USER_NAME',
4566: p_value => FND_GLOBAL.USER_NAME,
4567: p_parameterlist => l_parameter_list);
4568:
4569: wf_event.AddParameterToList(p_name => 'CONTACT_USER_ID',
4570: p_value => FND_GLOBAL.USER_ID,
4566: p_value => FND_GLOBAL.USER_NAME,
4567: p_parameterlist => l_parameter_list);
4568:
4569: wf_event.AddParameterToList(p_name => 'CONTACT_USER_ID',
4570: p_value => FND_GLOBAL.USER_ID,
4571: p_parameterlist => l_parameter_list);
4572:
4573:
4574: wf_event.AddParameterToList(p_name => 'CARRIER_REMARKS',