DBA Data[Home] [Help]

APPS.MST_WB_UTIL dependencies on DBMS_PIPE

Line 5963: DBMS_PIPE.PACK_MESSAGE('D|' || p_object_id || '|' || p_firm_status);

5959: l_status NUMBER;
5960: BEGIN
5961: --g_plan_id := p_plan_id;
5962: IF p_object_type = 1 THEN -- delivery
5963: DBMS_PIPE.PACK_MESSAGE('D|' || p_object_id || '|' || p_firm_status);
5964: ELSIF p_object_type = 2 THEN -- trip
5965: DBMS_PIPE.PACK_MESSAGE('T|' || p_object_id || '|' || p_firm_status);
5966: ELSIF p_object_type = 3 THEN -- cm trip
5967: DBMS_PIPE.PACK_MESSAGE('C|' || p_object_id || '|' || p_firm_status);

Line 5965: DBMS_PIPE.PACK_MESSAGE('T|' || p_object_id || '|' || p_firm_status);

5961: --g_plan_id := p_plan_id;
5962: IF p_object_type = 1 THEN -- delivery
5963: DBMS_PIPE.PACK_MESSAGE('D|' || p_object_id || '|' || p_firm_status);
5964: ELSIF p_object_type = 2 THEN -- trip
5965: DBMS_PIPE.PACK_MESSAGE('T|' || p_object_id || '|' || p_firm_status);
5966: ELSIF p_object_type = 3 THEN -- cm trip
5967: DBMS_PIPE.PACK_MESSAGE('C|' || p_object_id || '|' || p_firm_status);
5968: END IF;
5969: l_status := DBMS_PIPE.SEND_MESSAGE('MST_IP_' || p_plan_id, 0);

Line 5967: DBMS_PIPE.PACK_MESSAGE('C|' || p_object_id || '|' || p_firm_status);

5963: DBMS_PIPE.PACK_MESSAGE('D|' || p_object_id || '|' || p_firm_status);
5964: ELSIF p_object_type = 2 THEN -- trip
5965: DBMS_PIPE.PACK_MESSAGE('T|' || p_object_id || '|' || p_firm_status);
5966: ELSIF p_object_type = 3 THEN -- cm trip
5967: DBMS_PIPE.PACK_MESSAGE('C|' || p_object_id || '|' || p_firm_status);
5968: END IF;
5969: l_status := DBMS_PIPE.SEND_MESSAGE('MST_IP_' || p_plan_id, 0);
5970: END notify_engine;
5971:

Line 5969: l_status := DBMS_PIPE.SEND_MESSAGE('MST_IP_' || p_plan_id, 0);

5965: DBMS_PIPE.PACK_MESSAGE('T|' || p_object_id || '|' || p_firm_status);
5966: ELSIF p_object_type = 3 THEN -- cm trip
5967: DBMS_PIPE.PACK_MESSAGE('C|' || p_object_id || '|' || p_firm_status);
5968: END IF;
5969: l_status := DBMS_PIPE.SEND_MESSAGE('MST_IP_' || p_plan_id, 0);
5970: END notify_engine;
5971:
5972: PROCEDURE Update_Del_And_Rel_Trips(p_Plan_Id IN NUMBER,
5973: p_Trip_Id IN NUMBER,