APPS.GML_ORAKRP_XMLP_PKG dependencies on GML_ORAKRP_XMLP_PKG

Line 1: PACKAGE BODY GML_ORAKRP_XMLP_PKG AS

1: PACKAGE BODY GML_ORAKRP_XMLP_PKG AS
2: /* $Header: ORAKRPB.pls 120.0 2007/12/24 13:21:40 nchinnam noship $ */
3: FUNCTION LCHG_DESCCFFORMULA(LINE_ID IN NUMBER
4: ,ORDER_ID IN NUMBER) RETURN VARCHAR2 IS
5: FLD1 VARCHAR2(25);

Line 38: WHERE ORGN_CODE = GML_ORAKRP_XMLP_PKG.ORGN_CODE;

34: SELECT
35: ORGN_NAME
36: FROM
37: SY_ORGN_MST
38: WHERE ORGN_CODE = GML_ORAKRP_XMLP_PKG.ORGN_CODE;
39: BEGIN
40: P_CONC_REQUEST_ID := FND_GLOBAL.CONC_REQUEST_ID;
41: FROM_ORDER_DATE_1 := to_char(FROM_ORDER_DATE, 'DD-MON-YYYY');
42: TO_ORDER_DATE_1 := to_char(TO_ORDER_DATE, 'DD-MON-YYYY');

Line 56: WHERE ORGN_CODE = GML_ORAKRP_XMLP_PKG.ORGN_CODE;

52: ORGN_NAME
53: INTO CP_ORGN_NAME
54: FROM
55: SY_ORGN_MST
56: WHERE ORGN_CODE = GML_ORAKRP_XMLP_PKG.ORGN_CODE;
57: SELECT
58: USER_NAME
59: INTO CP_USER
60: FROM

Line 372: using ORDER_TYPE, O_NO, RELEASE_NO, GML_ORAKRP_XMLP_PKG.ORGN_CODE ;

368: EXECUTE IMMEDIATE
369: 'UPDATE OP_ORDR_HDR SET PRINT_COUNT=PRINT_COUNT+1,DATE_PRINTED=SYSDATE ' || 'WHERE ORDER_TYPE=:a ' ||
370: 'AND ORDER_NO = :b ' || 'AND RELEASE_NO=:c ' || 'AND ORGN_CODE=:d ' ||
371: 'AND PRINT_COUNT < ' || TO_CHAR(X_PRINT_COUNT)
372: using ORDER_TYPE, O_NO, RELEASE_NO, GML_ORAKRP_XMLP_PKG.ORGN_CODE ;
373: COMMIT;
374: RETURN NULL;
375: END UDATEFORMULA;
376:

Line 578: END GML_ORAKRP_XMLP_PKG;

574: BEGIN
575: RETURN CP_USER;
576: END CP_USER_P;
577:
578: END GML_ORAKRP_XMLP_PKG;
579: