DBA Data[Home] [Help]

APPS.CSM_HA_PROCESS_PKG dependencies on CSM_VARCHAR_LIST

Line 23: PROCEDURE SET_CONTEXT( P_CON_NAME_LIST CSM_VARCHAR_LIST,

19: BEGIN
20: NULL;
21: END ENABLE_WF_ONAPPLY;
22:
23: PROCEDURE SET_CONTEXT( P_CON_NAME_LIST CSM_VARCHAR_LIST,
24: p_CON_VALUE_LIST CSM_VARCHAR_LIST,
25: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
26: X_ERROR_MESSAGE OUT NOCOPY VARCHAR2)
27: IS

Line 24: p_CON_VALUE_LIST CSM_VARCHAR_LIST,

20: NULL;
21: END ENABLE_WF_ONAPPLY;
22:
23: PROCEDURE SET_CONTEXT( P_CON_NAME_LIST CSM_VARCHAR_LIST,
24: p_CON_VALUE_LIST CSM_VARCHAR_LIST,
25: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
26: X_ERROR_MESSAGE OUT NOCOPY VARCHAR2)
27: IS
28: BEGIN

Line 50: X_COL_NAME_LIST OUT NOCOPY CSM_VARCHAR_LIST,

46: NULL;
47: END PROCESS_HA;
48:
49: PROCEDURE PARSE_XML(p_HA_PAYLOAD_ID IN NUMBER,
50: X_COL_NAME_LIST OUT NOCOPY CSM_VARCHAR_LIST,
51: X_COL_VALUE_LIST OUT NOCOPY CSM_VARCHAR_LIST,
52: X_CON_NAME_LIST OUT NOCOPY CSM_VARCHAR_LIST,
53: X_CON_VALUE_LIST OUT NOCOPY CSM_VARCHAR_LIST,
54: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 51: X_COL_VALUE_LIST OUT NOCOPY CSM_VARCHAR_LIST,

47: END PROCESS_HA;
48:
49: PROCEDURE PARSE_XML(p_HA_PAYLOAD_ID IN NUMBER,
50: X_COL_NAME_LIST OUT NOCOPY CSM_VARCHAR_LIST,
51: X_COL_VALUE_LIST OUT NOCOPY CSM_VARCHAR_LIST,
52: X_CON_NAME_LIST OUT NOCOPY CSM_VARCHAR_LIST,
53: X_CON_VALUE_LIST OUT NOCOPY CSM_VARCHAR_LIST,
54: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
55: x_ERROR_MESSAGE OUT NOCOPY VARCHAR2)

Line 52: X_CON_NAME_LIST OUT NOCOPY CSM_VARCHAR_LIST,

48:
49: PROCEDURE PARSE_XML(p_HA_PAYLOAD_ID IN NUMBER,
50: X_COL_NAME_LIST OUT NOCOPY CSM_VARCHAR_LIST,
51: X_COL_VALUE_LIST OUT NOCOPY CSM_VARCHAR_LIST,
52: X_CON_NAME_LIST OUT NOCOPY CSM_VARCHAR_LIST,
53: X_CON_VALUE_LIST OUT NOCOPY CSM_VARCHAR_LIST,
54: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
55: x_ERROR_MESSAGE OUT NOCOPY VARCHAR2)
56: AS

Line 53: X_CON_VALUE_LIST OUT NOCOPY CSM_VARCHAR_LIST,

49: PROCEDURE PARSE_XML(p_HA_PAYLOAD_ID IN NUMBER,
50: X_COL_NAME_LIST OUT NOCOPY CSM_VARCHAR_LIST,
51: X_COL_VALUE_LIST OUT NOCOPY CSM_VARCHAR_LIST,
52: X_CON_NAME_LIST OUT NOCOPY CSM_VARCHAR_LIST,
53: X_CON_VALUE_LIST OUT NOCOPY CSM_VARCHAR_LIST,
54: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
55: x_ERROR_MESSAGE OUT NOCOPY VARCHAR2)
56: AS
57: BEGIN

Line 71: FUNCTION GET_PK_VALUE (p_PK_NAME_LIST IN CSM_VARCHAR_LIST,

67:
68:
69:
70: --Private Api
71: FUNCTION GET_PK_VALUE (p_PK_NAME_LIST IN CSM_VARCHAR_LIST,
72: p_COL_NAME_LIST IN CSM_VARCHAR_LIST,
73: p_COL_VALUE_LIST IN CSM_VARCHAR_LIST)
74: RETURN VARCHAR2
75: IS

Line 72: p_COL_NAME_LIST IN CSM_VARCHAR_LIST,

68:
69:
70: --Private Api
71: FUNCTION GET_PK_VALUE (p_PK_NAME_LIST IN CSM_VARCHAR_LIST,
72: p_COL_NAME_LIST IN CSM_VARCHAR_LIST,
73: p_COL_VALUE_LIST IN CSM_VARCHAR_LIST)
74: RETURN VARCHAR2
75: IS
76: BEGIN

Line 73: p_COL_VALUE_LIST IN CSM_VARCHAR_LIST)

69:
70: --Private Api
71: FUNCTION GET_PK_VALUE (p_PK_NAME_LIST IN CSM_VARCHAR_LIST,
72: p_COL_NAME_LIST IN CSM_VARCHAR_LIST,
73: p_COL_VALUE_LIST IN CSM_VARCHAR_LIST)
74: RETURN VARCHAR2
75: IS
76: BEGIN
77: NULL;

Line 81: P_COL_NAME_LIST IN CSM_VARCHAR_LIST,P_COL_VALUE_LIST IN CSM_VARCHAR_LIST,

77: NULL;
78: END GET_PK_VALUE;
79:
80: PROCEDURE PROCESS_DIRECT_UPDATE(P_TABLE_NAME IN VARCHAR2,P_PK_VALUE IN VARCHAR2,
81: P_COL_NAME_LIST IN CSM_VARCHAR_LIST,P_COL_VALUE_LIST IN CSM_VARCHAR_LIST,
82: x_RETURN_STATUS OUT NOCOPY VARCHAR2 ,x_ERROR_MESSAGE OUT NOCOPY VARCHAR2)
83: IS
84: BEGIN
85: NULL;

Line 90: P_COL_NAME_LIST IN CSM_VARCHAR_LIST,

86: END PROCESS_DIRECT_UPDATE;
87:
88: --Private Api
89: PROCEDURE PROCESS_DIRECT_INSERT(P_TABLE_NAME IN VARCHAR2,P_PK_VALUE IN VARCHAR2,
90: P_COL_NAME_LIST IN CSM_VARCHAR_LIST,
91: P_COL_VALUE_LIST IN CSM_VARCHAR_LIST,
92: x_RETURN_STATUS OUT NOCOPY VARCHAR2 ,x_ERROR_MESSAGE OUT NOCOPY VARCHAR2)
93: IS
94: BEGIN

Line 91: P_COL_VALUE_LIST IN CSM_VARCHAR_LIST,

87:
88: --Private Api
89: PROCEDURE PROCESS_DIRECT_INSERT(P_TABLE_NAME IN VARCHAR2,P_PK_VALUE IN VARCHAR2,
90: P_COL_NAME_LIST IN CSM_VARCHAR_LIST,
91: P_COL_VALUE_LIST IN CSM_VARCHAR_LIST,
92: x_RETURN_STATUS OUT NOCOPY VARCHAR2 ,x_ERROR_MESSAGE OUT NOCOPY VARCHAR2)
93: IS
94: BEGIN
95: NULL;