DBA Data[Home] [Help]

APPS.EDR_EINITIALS_PVT dependencies on FND_TABLE_OF_VARCHAR2_255

Line 8: P_PARAM_NAMES IN FND_TABLE_OF_VARCHAR2_255,

4: --This procedure is aimed at fetching the workflow attribtues values for the
5: --specified attribute names associated with the item type and item key.
6: PROCEDURE GET_WF_ATTRIBUTES(P_ITEMTYPE IN VARCHAR2,
7: P_ITEMKEY IN VARCHAR2,
8: P_PARAM_NAMES IN FND_TABLE_OF_VARCHAR2_255,
9: X_PARAM_VALUES OUT NOCOPY FND_TABLE_OF_VARCHAR2_255)
10:
11: IS
12:

Line 9: X_PARAM_VALUES OUT NOCOPY FND_TABLE_OF_VARCHAR2_255)

5: --specified attribute names associated with the item type and item key.
6: PROCEDURE GET_WF_ATTRIBUTES(P_ITEMTYPE IN VARCHAR2,
7: P_ITEMKEY IN VARCHAR2,
8: P_PARAM_NAMES IN FND_TABLE_OF_VARCHAR2_255,
9: X_PARAM_VALUES OUT NOCOPY FND_TABLE_OF_VARCHAR2_255)
10:
11: IS
12:
13: L_PARAM_VALUE VARCHAR2(4000);

Line 17: X_PARAM_VALUES := FND_TABLE_OF_VARCHAR2_255();

13: L_PARAM_VALUE VARCHAR2(4000);
14:
15: BEGIN
16:
17: X_PARAM_VALUES := FND_TABLE_OF_VARCHAR2_255();
18:
19: --For each parameter specified obtain the parameter value.
20: FOR i IN 1..P_PARAM_NAMES.COUNT LOOP
21: X_PARAM_VALUES.EXTEND;

Line 50: P_PARAM_NAMES IN FND_TABLE_OF_VARCHAR2_255,

46: --This procedure is used to obtain the e-record details associated with the specified workflow item type
47: --and item key.
48: PROCEDURE GET_ERECORD_DETAILS(P_ITEMTYPE IN VARCHAR2,
49: P_ITEMKEY IN VARCHAR2,
50: P_PARAM_NAMES IN FND_TABLE_OF_VARCHAR2_255,
51: X_PARAM_VALUES OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
52: X_ERECORD_TEXT OUT NOCOPY CLOB)
53: IS
54:

Line 51: X_PARAM_VALUES OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,

47: --and item key.
48: PROCEDURE GET_ERECORD_DETAILS(P_ITEMTYPE IN VARCHAR2,
49: P_ITEMKEY IN VARCHAR2,
50: P_PARAM_NAMES IN FND_TABLE_OF_VARCHAR2_255,
51: X_PARAM_VALUES OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
52: X_ERECORD_TEXT OUT NOCOPY CLOB)
53: IS
54:
55: L_COUNT NUMBER;

Line 92: P_PARAM_NAMES IN FND_TABLE_OF_VARCHAR2_255,

88:
89:
90: --This procedure is used to obtain the e-record details associated with the specified ERES process ID.
91: PROCEDURE GET_ERECORD_DETAILS(P_PROCESS_ID IN VARCHAR2,
92: P_PARAM_NAMES IN FND_TABLE_OF_VARCHAR2_255,
93: X_ITEMTYPE OUT NOCOPY VARCHAR2,
94: X_ITEMKEY OUT NOCOPY VARCHAR2,
95: X_PARAM_VALUES OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
96: X_ERECORD_COUNT OUT NOCOPY NUMBER,

Line 95: X_PARAM_VALUES OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,

91: PROCEDURE GET_ERECORD_DETAILS(P_PROCESS_ID IN VARCHAR2,
92: P_PARAM_NAMES IN FND_TABLE_OF_VARCHAR2_255,
93: X_ITEMTYPE OUT NOCOPY VARCHAR2,
94: X_ITEMKEY OUT NOCOPY VARCHAR2,
95: X_PARAM_VALUES OUT NOCOPY FND_TABLE_OF_VARCHAR2_255,
96: X_ERECORD_COUNT OUT NOCOPY NUMBER,
97: X_ESIGN_COMPLETED OUT NOCOPY VARCHAR2,
98: X_ERECORD_TEXT OUT NOCOPY CLOB)
99: IS