DBA Data[Home] [Help]

APPS.CSM_SR_ATTRIBUTES_PKG dependencies on CSM_VARCHAR_LIST

Line 7: p_COL_NAME_LIST IN CSM_VARCHAR_LIST,

3: error EXCEPTION;
4:
5: PROCEDURE APPLY_SR_LINK_INSERT
6: (p_HA_PAYLOAD_ID IN NUMBER,
7: p_COL_NAME_LIST IN CSM_VARCHAR_LIST,
8: p_COL_VALUE_LIST IN CSM_VARCHAR_LIST,
9: x_RETURN_STATUS OUT NOCOPY VARCHAR2,
10: X_Error_Message Out Nocopy Varchar2
11: )

Line 8: p_COL_VALUE_LIST IN CSM_VARCHAR_LIST,

4:
5: PROCEDURE APPLY_SR_LINK_INSERT
6: (p_HA_PAYLOAD_ID IN NUMBER,
7: p_COL_NAME_LIST IN CSM_VARCHAR_LIST,
8: p_COL_VALUE_LIST IN CSM_VARCHAR_LIST,
9: x_RETURN_STATUS OUT NOCOPY VARCHAR2,
10: X_Error_Message Out Nocopy Varchar2
11: )
12: AS

Line 140: p_COL_NAME_LIST IN CSM_VARCHAR_LIST,

136: ---sr link update
137:
138: PROCEDURE APPLY_SR_LINK_UPDATE
139: (p_HA_PAYLOAD_ID IN NUMBER,
140: p_COL_NAME_LIST IN CSM_VARCHAR_LIST,
141: p_COL_VALUE_LIST IN CSM_VARCHAR_LIST,
142: x_RETURN_STATUS OUT NOCOPY VARCHAR2,
143: X_Error_Message Out Nocopy Varchar2
144: )

Line 141: p_COL_VALUE_LIST IN CSM_VARCHAR_LIST,

137:
138: PROCEDURE APPLY_SR_LINK_UPDATE
139: (p_HA_PAYLOAD_ID IN NUMBER,
140: p_COL_NAME_LIST IN CSM_VARCHAR_LIST,
141: p_COL_VALUE_LIST IN CSM_VARCHAR_LIST,
142: x_RETURN_STATUS OUT NOCOPY VARCHAR2,
143: X_Error_Message Out Nocopy Varchar2
144: )
145: AS

Line 286: p_COL_NAME_LIST IN CSM_VARCHAR_LIST,

282: --sr link update ends
283: --sr link delete starts
284: PROCEDURE APPLY_SR_LINK_DELETE
285: (p_HA_PAYLOAD_ID IN NUMBER,
286: p_COL_NAME_LIST IN CSM_VARCHAR_LIST,
287: p_COL_VALUE_LIST IN CSM_VARCHAR_LIST,
288: x_RETURN_STATUS OUT NOCOPY VARCHAR2,
289: X_Error_Message Out Nocopy Varchar2
290: )

Line 287: p_COL_VALUE_LIST IN CSM_VARCHAR_LIST,

283: --sr link delete starts
284: PROCEDURE APPLY_SR_LINK_DELETE
285: (p_HA_PAYLOAD_ID IN NUMBER,
286: p_COL_NAME_LIST IN CSM_VARCHAR_LIST,
287: p_COL_VALUE_LIST IN CSM_VARCHAR_LIST,
288: x_RETURN_STATUS OUT NOCOPY VARCHAR2,
289: X_Error_Message Out Nocopy Varchar2
290: )
291: AS

Line 359: p_Col_Name_List In Csm_Varchar_List,

355: --sr link delete ends
356: --SR Attributes insert
357: PROCEDURE APPLY_SR_ATTR_INSERT
358: (p_HA_PAYLOAD_ID IN NUMBER,
359: p_Col_Name_List In Csm_Varchar_List,
360: p_COL_VALUE_LIST IN CSM_VARCHAR_LIST,
361: x_RETURN_STATUS OUT NOCOPY VARCHAR2,
362: X_Error_Message Out Nocopy Varchar2
363: )

Line 360: p_COL_VALUE_LIST IN CSM_VARCHAR_LIST,

356: --SR Attributes insert
357: PROCEDURE APPLY_SR_ATTR_INSERT
358: (p_HA_PAYLOAD_ID IN NUMBER,
359: p_Col_Name_List In Csm_Varchar_List,
360: p_COL_VALUE_LIST IN CSM_VARCHAR_LIST,
361: x_RETURN_STATUS OUT NOCOPY VARCHAR2,
362: X_Error_Message Out Nocopy Varchar2
363: )
364: AS

Line 519: p_Col_Name_List In Csm_Varchar_List,

515:
516: --SR Attributes UPDATE
517: PROCEDURE APPLY_SR_ATTR_UPDATE
518: (p_HA_PAYLOAD_ID IN NUMBER,
519: p_Col_Name_List In Csm_Varchar_List,
520: p_COL_VALUE_LIST IN CSM_VARCHAR_LIST,
521: x_RETURN_STATUS OUT NOCOPY VARCHAR2,
522: X_Error_Message Out Nocopy Varchar2
523: )

Line 520: p_COL_VALUE_LIST IN CSM_VARCHAR_LIST,

516: --SR Attributes UPDATE
517: PROCEDURE APPLY_SR_ATTR_UPDATE
518: (p_HA_PAYLOAD_ID IN NUMBER,
519: p_Col_Name_List In Csm_Varchar_List,
520: p_COL_VALUE_LIST IN CSM_VARCHAR_LIST,
521: x_RETURN_STATUS OUT NOCOPY VARCHAR2,
522: X_Error_Message Out Nocopy Varchar2
523: )
524: AS

Line 683: p_Col_Name_List In Csm_Varchar_List,

679:
680: --SR Attributes DELETE
681: PROCEDURE APPLY_SR_ATTR_DELETE
682: (p_HA_PAYLOAD_ID IN NUMBER,
683: p_Col_Name_List In Csm_Varchar_List,
684: p_COL_VALUE_LIST IN CSM_VARCHAR_LIST,
685: x_RETURN_STATUS OUT NOCOPY VARCHAR2,
686: X_Error_Message Out Nocopy Varchar2
687: )

Line 684: p_COL_VALUE_LIST IN CSM_VARCHAR_LIST,

680: --SR Attributes DELETE
681: PROCEDURE APPLY_SR_ATTR_DELETE
682: (p_HA_PAYLOAD_ID IN NUMBER,
683: p_Col_Name_List In Csm_Varchar_List,
684: p_COL_VALUE_LIST IN CSM_VARCHAR_LIST,
685: x_RETURN_STATUS OUT NOCOPY VARCHAR2,
686: X_Error_Message Out Nocopy Varchar2
687: )
688: AS

Line 740: P_COL_NAME_LIST IN CSM_VARCHAR_LIST,

736: END APPLY_SR_ATTR_DELETE;
737:
738: PROCEDURE APPLY_HA_ATTR_CHANGES
739: (p_HA_PAYLOAD_ID IN NUMBER,
740: P_COL_NAME_LIST IN CSM_VARCHAR_LIST,
741: p_COL_VALUE_LIST IN CSM_VARCHAR_LIST,
742: p_dml_type IN VARCHAR2,
743: x_RETURN_STATUS OUT NOCOPY VARCHAR2,
744: x_ERROR_MESSAGE OUT NOCOPY VARCHAR2

Line 741: p_COL_VALUE_LIST IN CSM_VARCHAR_LIST,

737:
738: PROCEDURE APPLY_HA_ATTR_CHANGES
739: (p_HA_PAYLOAD_ID IN NUMBER,
740: P_COL_NAME_LIST IN CSM_VARCHAR_LIST,
741: p_COL_VALUE_LIST IN CSM_VARCHAR_LIST,
742: p_dml_type IN VARCHAR2,
743: x_RETURN_STATUS OUT NOCOPY VARCHAR2,
744: x_ERROR_MESSAGE OUT NOCOPY VARCHAR2
745: )IS

Line 799: P_COL_NAME_LIST IN CSM_VARCHAR_LIST,

795: END APPLY_HA_ATTR_CHANGES;
796:
797: PROCEDURE APPLY_HA_LINK_CHANGES
798: (p_HA_PAYLOAD_ID IN NUMBER,
799: P_COL_NAME_LIST IN CSM_VARCHAR_LIST,
800: p_COL_VALUE_LIST IN CSM_VARCHAR_LIST,
801: p_dml_type IN VARCHAR2,
802: x_RETURN_STATUS OUT NOCOPY VARCHAR2,
803: x_ERROR_MESSAGE OUT NOCOPY VARCHAR2

Line 800: p_COL_VALUE_LIST IN CSM_VARCHAR_LIST,

796:
797: PROCEDURE APPLY_HA_LINK_CHANGES
798: (p_HA_PAYLOAD_ID IN NUMBER,
799: P_COL_NAME_LIST IN CSM_VARCHAR_LIST,
800: p_COL_VALUE_LIST IN CSM_VARCHAR_LIST,
801: p_dml_type IN VARCHAR2,
802: x_RETURN_STATUS OUT NOCOPY VARCHAR2,
803: x_ERROR_MESSAGE OUT NOCOPY VARCHAR2
804: )IS