APPS.OE_CANSRV dependencies on OE_CANSRV

Line 1: PACKAGE BODY OE_CANSRV AS

1: PACKAGE BODY OE_CANSRV AS
2: /* $Header: OECANSVB.pls 115.4 99/07/16 08:10:37 porting shi $ */
3:
4: ------------------------------------------------------------------------
5: -- procedure CHECK_LINE_INTERFACED

Line 88: OE_CANSRV.CHECK_ORDER_INT_RECS_EXIST(

84: RESULT1 NUMBER :='';
85: x BOOLEAN;
86: BEGIN
87:
88: OE_CANSRV.CHECK_ORDER_INT_RECS_EXIST(
89: V_LINE_ID, CONCURRENT_PROCESS_ID_TEMP, RESULT1);
90:
91: IF RESULT1 = 1 THEN
92: V_RESULT := 1;

Line 242: OE_CANSRV.CHECK_LINE_INTERFACED(LOOP_LINE_ID, CHECK_LINE_INTERFACE_RESULT);

238: LOOP_CUSTOMER_PRODUCT_ID := c1rec.customer_product_id;
239: LOOP_SERVICE_MASS_TXN_TEMP_ID := c1rec.service_mass_txn_temp_id;
240: LOOP_CP_SERVICE_ID := c1rec.cp_service_id;
241:
242: OE_CANSRV.CHECK_LINE_INTERFACED(LOOP_LINE_ID, CHECK_LINE_INTERFACE_RESULT);
243:
244: IF CHECK_LINE_INTERFACE_RESULT = 1 THEN
245: OE_CANSRV.CHECK_ORDER_INT_RECS_EXIST(LOOP_LINE_ID, V_CONCURRENT_PROCESS_ID,
246: CHECK_ORDER_INT_RECS_RESULT);

Line 245: OE_CANSRV.CHECK_ORDER_INT_RECS_EXIST(LOOP_LINE_ID, V_CONCURRENT_PROCESS_ID,

241:
242: OE_CANSRV.CHECK_LINE_INTERFACED(LOOP_LINE_ID, CHECK_LINE_INTERFACE_RESULT);
243:
244: IF CHECK_LINE_INTERFACE_RESULT = 1 THEN
245: OE_CANSRV.CHECK_ORDER_INT_RECS_EXIST(LOOP_LINE_ID, V_CONCURRENT_PROCESS_ID,
246: CHECK_ORDER_INT_RECS_RESULT);
247: END IF;
248:
249: IF CHECK_ORDER_INT_RECS_RESULT = 1 THEN

Line 250: OE_CANSRV.CHECK_ORDER_INT_NOT_IN_PROG(LOOP_LINE_ID, V_PRINT_ERR_MSG,

246: CHECK_ORDER_INT_RECS_RESULT);
247: END IF;
248:
249: IF CHECK_ORDER_INT_RECS_RESULT = 1 THEN
250: OE_CANSRV.CHECK_ORDER_INT_NOT_IN_PROG(LOOP_LINE_ID, V_PRINT_ERR_MSG,
251: V_CONCURRENT_PROCESS_ID, CHECK_ORDER_INT_NOT_RESULT);
252: ELSE
253: INSERT INTO CS_ORDERS_INTERFACE
254: ( ORDER_INTERFACE_ID

Line 276: OE_CANSRV.MAKE_DELETE_INT_RECS(LOOP_LINE_ID,LOOP_CUSTOMER_PRODUCT_ID,

272: );
273: END IF;
274:
275: IF CHECK_ORDER_INT_NOT_RESULT = 1 THEN
276: OE_CANSRV.MAKE_DELETE_INT_RECS(LOOP_LINE_ID,LOOP_CUSTOMER_PRODUCT_ID,
277: LOOP_CP_SERVICE_ID, V_LAST_UPDATED_BY, LOOP_SERVICE_MASS_TXN_TEMP_ID,
278: MAKE_DELETE_INT_RECS_RESULT);
279:
280: DELETE FROM CS_ORDERS_INTERFACE

Line 635: OE_CANSRV.CHECK_LINE_INTERFACED( V_LINE_ID,

631: CANCEL_LINE_RESULT NUMBER :='';
632:
633: BEGIN
634:
635: OE_CANSRV.CHECK_LINE_INTERFACED( V_LINE_ID,
636: CHK_LINE_INT_RESULT
637: );
638:
639: IF CHK_LINE_INT_RESULT = 0 THEN

Line 643: OE_CANSRV.CHECK_ORDER_INT_RECS_EXIST( V_LINE_ID,

639: IF CHK_LINE_INT_RESULT = 0 THEN
640: GOTO cancel_line;
641: END IF;
642:
643: OE_CANSRV.CHECK_ORDER_INT_RECS_EXIST( V_LINE_ID,
644: V_CONCURRENT_PROCESS_ID,
645: CHK_ORD_INT_RESULT
646: );
647: IF CHK_ORD_INT_RESULT = 0 THEN

Line 673: OE_CANSRV.CHECK_ORDER_INT_NOT_IN_PROG( V_LINE_ID,

669: GOTO cancel_line;
670: END IF;
671:
672:
673: OE_CANSRV.CHECK_ORDER_INT_NOT_IN_PROG( V_LINE_ID,
674: V_PRINT_ERR_MSG,
675: V_CONCURRENT_PROCESS_ID,
676: CHK_ORD_INT_NOT_RESULT
677: );

Line 679: OE_CANSRV.MAKE_DELETE_INT_RECS( V_LINE_ID,

675: V_CONCURRENT_PROCESS_ID,
676: CHK_ORD_INT_NOT_RESULT
677: );
678: IF CHK_ORD_INT_NOT_RESULT = 1 THEN
679: OE_CANSRV.MAKE_DELETE_INT_RECS( V_LINE_ID,
680: V_CUSTOMER_PRODUCT_ID,
681: V_CP_SERVICE_ID,
682: V_LAST_UPDATED_BY,
683: V_SERVICE_MASS_TXN_TEMP_ID,

Line 695: OE_CANSRV.CANCEL_SERVICE_CHILDREN( V_LINE_ID,

691: GOTO cancel_line;
692: END IF;
693:
694: <>
695: OE_CANSRV.CANCEL_SERVICE_CHILDREN( V_LINE_ID,
696: V_HEADER_ID,
697: V_CANCEL_CODE,
698: V_CANCEL_COMMENT,
699: V_FULL,

Line 712: OE_CANSRV.CANCEL_LINE( V_LINE_ID,

708: V_CONCURRENT_PROCESS_ID,
709: CANCEL_SRV_CHILD_RESULT
710: );
711:
712: OE_CANSRV.CANCEL_LINE( V_LINE_ID,
713: V_REQUESTED_CANCEL_QTY,
714: V_ORDERED_QUANTITY,
715: V_RECEIVED_QUANTITY,
716: V_S29,

Line 980: END OE_CANSRV;

976: WHERE HOLD_RELEASE_ID IS NULL
977: AND SOH.HOLD_SOURCE_ID = SHS.HOLD_SOURCE_ID);
978: END ALL_HOLDS;
979:
980: END OE_CANSRV;