APPS.GMO_INSTRUCTION_PVT dependencies on GMO_UTILITIES

Line 189: GMO_UTILITIES.GET_WHO_COLUMNS

185: fetch L_IS_VALID_PROCESS_CSR into L_VALID_PROCESS;
186: close L_IS_VALID_PROCESS_CSR;
187: END IF;
188:
189: GMO_UTILITIES.GET_WHO_COLUMNS
190: (
191: X_CREATION_DATE => L_CREATION_DATE,
192: X_CREATED_BY => L_CREATED_BY,
193: X_LAST_UPDATE_DATE => L_LAST_UPDATE_DATE,

Line 1066: GMO_UTILITIES.GET_WHO_COLUMNS

1062: BEGIN
1063:
1064: L_API_NAME := 'CREATE_DEFN_FROM_DEFN';
1065:
1066: GMO_UTILITIES.GET_WHO_COLUMNS
1067: (
1068: X_CREATION_DATE => L_CREATION_DATE,
1069: X_CREATED_BY => L_CREATED_BY,
1070: X_LAST_UPDATE_DATE => L_LAST_UPDATE_DATE,

Line 1604: GMO_UTILITIES.GET_WHO_COLUMNS

1600: IF (L_CNT = 0) THEN
1601: RAISE L_ENTITY_INFO_NOTFOUND_ERR;
1602: END IF;
1603:
1604: GMO_UTILITIES.GET_WHO_COLUMNS
1605: (
1606: X_CREATION_DATE => L_CREATION_DATE,
1607: X_CREATED_BY => L_CREATED_BY,
1608: X_LAST_UPDATE_DATE => L_LAST_UPDATE_DATE,

Line 2335: GMO_UTILITIES.GET_WHO_COLUMNS

2331: BEGIN
2332:
2333: L_API_NAME := 'CREATE_INSTANCE_FROM_DEFN';
2334:
2335: GMO_UTILITIES.GET_WHO_COLUMNS
2336: (
2337: X_CREATION_DATE => L_CREATION_DATE,
2338: X_CREATED_BY => L_CREATED_BY,
2339: X_LAST_UPDATE_DATE => L_LAST_UPDATE_DATE,

Line 2753: GMO_UTILITIES.GET_WHO_COLUMNS

2749: L_MESG_TEXT VARCHAR2(1000);
2750:
2751: BEGIN
2752:
2753: GMO_UTILITIES.GET_WHO_COLUMNS
2754: (
2755: X_CREATION_DATE => L_CREATION_DATE,
2756: X_CREATED_BY => L_CREATED_BY,
2757: X_LAST_UPDATE_DATE => L_LAST_UPDATE_DATE,

Line 3722: GMO_UTILITIES.GET_WHO_COLUMNS

3718: BEGIN
3719:
3720: L_API_NAME := 'SEND_INSTANCE_ACKN';
3721:
3722: GMO_UTILITIES.GET_WHO_COLUMNS
3723: (
3724: X_CREATION_DATE => L_CREATION_DATE,
3725: X_CREATED_BY => L_CREATED_BY,
3726: X_LAST_UPDATE_DATE => L_LAST_UPDATE_DATE,

Line 4016: GMO_UTILITIES.GET_WHO_COLUMNS

4012: BEGIN
4013:
4014: L_API_NAME := 'SEND_TASK_ACKN';
4015:
4016: GMO_UTILITIES.GET_WHO_COLUMNS
4017: (
4018: X_CREATION_DATE => L_CREATION_DATE,
4019: X_CREATED_BY => L_CREATED_BY,
4020: X_LAST_UPDATE_DATE => L_LAST_UPDATE_DATE,

Line 4321: GMO_UTILITIES.GET_WHO_COLUMNS

4317:
4318: BEGIN
4319:
4320: L_API_NAME := 'COMPLETE_OPTIONAL_INSTR';
4321: GMO_UTILITIES.GET_WHO_COLUMNS
4322: (
4323: X_CREATION_DATE => L_CREATION_DATE,
4324: X_CREATED_BY => L_CREATED_BY,
4325: X_LAST_UPDATE_DATE => L_LAST_UPDATE_DATE,

Line 4553: GMO_UTILITIES.GET_WHO_COLUMNS

4549: BEGIN
4550:
4551: L_API_NAME := 'CAPTURE_OPERATOR_RESPONSE';
4552:
4553: GMO_UTILITIES.GET_WHO_COLUMNS
4554: (
4555: X_CREATION_DATE => L_CREATION_DATE,
4556: X_CREATED_BY => L_CREATED_BY,
4557: X_LAST_UPDATE_DATE => L_LAST_UPDATE_DATE,

Line 4642: GMO_UTILITIES.GET_WHO_COLUMNS

4638: BEGIN
4639:
4640: L_API_NAME := 'INSERT_ERECORD_DETAILS';
4641:
4642: GMO_UTILITIES.GET_WHO_COLUMNS
4643: (
4644: X_CREATION_DATE => L_CREATION_DATE,
4645: X_CREATED_BY => L_CREATED_BY,
4646: X_LAST_UPDATE_DATE => L_LAST_UPDATE_DATE,

Line 4772: GMO_UTILITIES.GET_WHO_COLUMNS

4768: BEGIN
4769:
4770: L_API_NAME := 'CREATE_TEMPORARY_INSTANCES';
4771:
4772: GMO_UTILITIES.GET_WHO_COLUMNS
4773: (
4774: X_CREATION_DATE => L_CREATION_DATE,
4775: X_CREATED_BY => L_CREATED_BY,
4776: X_LAST_UPDATE_DATE => L_LAST_UPDATE_DATE,

Line 5073: GMO_UTILITIES.GET_WHO_COLUMNS

5069:
5070: RETURN;
5071: END; -- Validation Block
5072:
5073: GMO_UTILITIES.GET_WHO_COLUMNS
5074: (
5075: X_CREATION_DATE => L_CREATION_DATE,
5076: X_CREATED_BY => L_CREATED_BY,
5077: X_LAST_UPDATE_DATE => L_LAST_UPDATE_DATE,

Line 5572: GMO_UTILITIES.GET_WHO_COLUMNS

5568: L_COUNT NUMBER;
5569:
5570: BEGIN
5571:
5572: GMO_UTILITIES.GET_WHO_COLUMNS
5573: (
5574: X_CREATION_DATE => L_CREATION_DATE,
5575: X_CREATED_BY => L_CREATED_BY,
5576: X_LAST_UPDATE_DATE => L_LAST_UPDATE_DATE,

Line 5674: GMO_UTILITIES.GET_WHO_COLUMNS

5670: AND INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID;
5671:
5672: IF(SQL%ROWCOUNT = 0 ) THEN
5673:
5674: GMO_UTILITIES.GET_WHO_COLUMNS
5675: (
5676: X_CREATION_DATE => L_CREATION_DATE,
5677: X_CREATED_BY => L_CREATED_BY,
5678: X_LAST_UPDATE_DATE => L_LAST_UPDATE_DATE,

Line 6025: GMO_UTILITIES.GET_WHO_COLUMNS

6021: INVALID_PROCESS_ERR exception;
6022: INVALID_PROCESS_INSTR_ERR exception;
6023:
6024: BEGIN
6025: GMO_UTILITIES.GET_WHO_COLUMNS
6026: (
6027: X_CREATION_DATE => L_CREATION_DATE,
6028: X_CREATED_BY => L_CREATED_BY,
6029: X_LAST_UPDATE_DATE => L_LAST_UPDATE_DATE,

Line 6276: GMO_UTILITIES.GET_USER_DISPLAY_NAME(INSTR.LAST_UPDATED_BY))

6272: AND LK2.LOOKUP_CODE = INSTRVL.INSTR_ACKN_TYPE)
6273: AS INSTRUCTION_ACKN_TYPE,
6274: decode(INSTR.INSTR_STATUS,GMO_CONSTANTS_GRP.G_INSTR_STATUS_PENDING,
6275: NULL,
6276: GMO_UTILITIES.GET_USER_DISPLAY_NAME(INSTR.LAST_UPDATED_BY))
6277: AS PERFORMED_BY,
6278: INSTR.LAST_UPDATE_DATE LAST_UPDATE_DATE,
6279: INSTR.COMMENTS COMMENTS,
6280: (SELECT