APPS.GMO_OC_TRANS_PKG dependencies on GMO_UTILITIES

Line 64: l_operator_name := GMO_UTILITIES.GET_USER_DISPLAY_NAME(operator_id);

60: OPEN GET_OBJECT;
61: FETCH GET_OBJECT INTO l_object;
62: CLOSE GET_OBJECT;
63: IF operator_id IS NOT NULL THEN
64: l_operator_name := GMO_UTILITIES.GET_USER_DISPLAY_NAME(operator_id);
65: END IF;
66:
67: l_argument_string := 'SELECT XMLELEMENT("OPERATORHISTORY", XMLCONCAT(XMLSEQUENCETYPE(
68: XMLTYPE(''''||:x||''''),

Line 92: GMO_UTILITIES.GET_USER_DISPLAY_NAME(oc_trans_hdr.USER_ID) Operator,

88: FND_MESSAGE.GET_STRING(oc_trans_hdr.user_key_label_product,oc_trans_hdr.USER_KEY_LABEL_TOKEN) User_Key_Label,
89: oc_trans_hdr.USER_KEY_VALUE User_Key_Value,
90: oc_trans_hdr.CREATION_DATE Transaction_Date,
91: oc_trans_hdr.USER_ID User_Id,
92: GMO_UTILITIES.GET_USER_DISPLAY_NAME(oc_trans_hdr.USER_ID) Operator,
93: oc_trans_hdr.OVERRIDER_ID Overrider_Id,
94: GMO_UTILITIES.GET_USER_DISPLAY_NAME(oc_trans_hdr.OVERRIDER_ID) Overrider,
95: oc_trans_hdr.COMMENTS comments,
96: oc_trans_hdr.ERECORD_ID ERecord_Id,

Line 94: GMO_UTILITIES.GET_USER_DISPLAY_NAME(oc_trans_hdr.OVERRIDER_ID) Overrider,

90: oc_trans_hdr.CREATION_DATE Transaction_Date,
91: oc_trans_hdr.USER_ID User_Id,
92: GMO_UTILITIES.GET_USER_DISPLAY_NAME(oc_trans_hdr.USER_ID) Operator,
93: oc_trans_hdr.OVERRIDER_ID Overrider_Id,
94: GMO_UTILITIES.GET_USER_DISPLAY_NAME(oc_trans_hdr.OVERRIDER_ID) Overrider,
95: oc_trans_hdr.COMMENTS comments,
96: oc_trans_hdr.ERECORD_ID ERecord_Id,
97: ( SELECT XMLAGG(XMLELEMENT("OPER_CERT_DTL",XMLFOREST(DECODE(oc_trans_dtl.QUALIFICATION_TYPE,1,
98: (select unique(name) from OTA_CERTIFICATIONS_VL where certification_id = oc_trans_dtl.QUALIFICATION_ID),2,