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 3728: GMO_UTILITIES.GET_WHO_COLUMNS

3724: BEGIN
3725:
3726: L_API_NAME := 'SEND_INSTANCE_ACKN';
3727:
3728: GMO_UTILITIES.GET_WHO_COLUMNS
3729: (
3730: X_CREATION_DATE => L_CREATION_DATE,
3731: X_CREATED_BY => L_CREATED_BY,
3732: X_LAST_UPDATE_DATE => L_LAST_UPDATE_DATE,

Line 4038: GMO_UTILITIES.GET_WHO_COLUMNS

4034: BEGIN
4035:
4036: L_API_NAME := 'SEND_TASK_ACKN';
4037:
4038: GMO_UTILITIES.GET_WHO_COLUMNS
4039: (
4040: X_CREATION_DATE => L_CREATION_DATE,
4041: X_CREATED_BY => L_CREATED_BY,
4042: X_LAST_UPDATE_DATE => L_LAST_UPDATE_DATE,

Line 4343: GMO_UTILITIES.GET_WHO_COLUMNS

4339:
4340: BEGIN
4341:
4342: L_API_NAME := 'COMPLETE_OPTIONAL_INSTR';
4343: GMO_UTILITIES.GET_WHO_COLUMNS
4344: (
4345: X_CREATION_DATE => L_CREATION_DATE,
4346: X_CREATED_BY => L_CREATED_BY,
4347: X_LAST_UPDATE_DATE => L_LAST_UPDATE_DATE,

Line 4575: GMO_UTILITIES.GET_WHO_COLUMNS

4571: BEGIN
4572:
4573: L_API_NAME := 'CAPTURE_OPERATOR_RESPONSE';
4574:
4575: GMO_UTILITIES.GET_WHO_COLUMNS
4576: (
4577: X_CREATION_DATE => L_CREATION_DATE,
4578: X_CREATED_BY => L_CREATED_BY,
4579: X_LAST_UPDATE_DATE => L_LAST_UPDATE_DATE,

Line 4664: GMO_UTILITIES.GET_WHO_COLUMNS

4660: BEGIN
4661:
4662: L_API_NAME := 'INSERT_ERECORD_DETAILS';
4663:
4664: GMO_UTILITIES.GET_WHO_COLUMNS
4665: (
4666: X_CREATION_DATE => L_CREATION_DATE,
4667: X_CREATED_BY => L_CREATED_BY,
4668: X_LAST_UPDATE_DATE => L_LAST_UPDATE_DATE,

Line 4794: GMO_UTILITIES.GET_WHO_COLUMNS

4790: BEGIN
4791:
4792: L_API_NAME := 'CREATE_TEMPORARY_INSTANCES';
4793:
4794: GMO_UTILITIES.GET_WHO_COLUMNS
4795: (
4796: X_CREATION_DATE => L_CREATION_DATE,
4797: X_CREATED_BY => L_CREATED_BY,
4798: X_LAST_UPDATE_DATE => L_LAST_UPDATE_DATE,

Line 5095: GMO_UTILITIES.GET_WHO_COLUMNS

5091:
5092: RETURN;
5093: END; -- Validation Block
5094:
5095: GMO_UTILITIES.GET_WHO_COLUMNS
5096: (
5097: X_CREATION_DATE => L_CREATION_DATE,
5098: X_CREATED_BY => L_CREATED_BY,
5099: X_LAST_UPDATE_DATE => L_LAST_UPDATE_DATE,

Line 5594: GMO_UTILITIES.GET_WHO_COLUMNS

5590: L_COUNT NUMBER;
5591:
5592: BEGIN
5593:
5594: GMO_UTILITIES.GET_WHO_COLUMNS
5595: (
5596: X_CREATION_DATE => L_CREATION_DATE,
5597: X_CREATED_BY => L_CREATED_BY,
5598: X_LAST_UPDATE_DATE => L_LAST_UPDATE_DATE,

Line 5696: GMO_UTILITIES.GET_WHO_COLUMNS

5692: AND INSTRUCTION_PROCESS_ID = P_INSTRUCTION_PROCESS_ID;
5693:
5694: IF(SQL%ROWCOUNT = 0 ) THEN
5695:
5696: GMO_UTILITIES.GET_WHO_COLUMNS
5697: (
5698: X_CREATION_DATE => L_CREATION_DATE,
5699: X_CREATED_BY => L_CREATED_BY,
5700: X_LAST_UPDATE_DATE => L_LAST_UPDATE_DATE,

Line 6047: GMO_UTILITIES.GET_WHO_COLUMNS

6043: INVALID_PROCESS_ERR exception;
6044: INVALID_PROCESS_INSTR_ERR exception;
6045:
6046: BEGIN
6047: GMO_UTILITIES.GET_WHO_COLUMNS
6048: (
6049: X_CREATION_DATE => L_CREATION_DATE,
6050: X_CREATED_BY => L_CREATED_BY,
6051: X_LAST_UPDATE_DATE => L_LAST_UPDATE_DATE,

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

6295: AND LK2.LOOKUP_CODE = INSTRVL.INSTR_ACKN_TYPE)
6296: AS INSTRUCTION_ACKN_TYPE,
6297: decode(INSTR.INSTR_STATUS,GMO_CONSTANTS_GRP.G_INSTR_STATUS_PENDING,
6298: NULL,
6299: GMO_UTILITIES.GET_USER_DISPLAY_NAME(INSTR.LAST_UPDATED_BY))
6300: AS PERFORMED_BY,
6301: INSTR.LAST_UPDATE_DATE LAST_UPDATE_DATE,
6302: INSTR.COMMENTS COMMENTS,
6303: (SELECT