DBA Data[Home] [Help]

APPS.DPP_BPEL_UPDATEEXECDTLS dependencies on DPP_EXECUTIONDETAILS_PVT_DPP4

Line 56: RETURN DPP_EXECUTIONDETAILS_PVT_DPP4 IS

52: aPlsqlItem.UPDATE_STATUS := aSqlItem.UPDATE_STATUS;
53: RETURN aPlsqlItem;
54: END SQL_TO_PL6;
55: FUNCTION PL_TO_SQL5(aPlsqlItem DPP_EXECUTIONDETAILS_PVT.DPP_STATUS_UPDATE_TBL_TYPE)
56: RETURN DPP_EXECUTIONDETAILS_PVT_DPP4 IS
57: aSqlItem DPP_EXECUTIONDETAILS_PVT_DPP4;
58: BEGIN
59: -- initialize the table
60: aSqlItem := DPP_EXECUTIONDETAILS_PVT_DPP4();

Line 57: aSqlItem DPP_EXECUTIONDETAILS_PVT_DPP4;

53: RETURN aPlsqlItem;
54: END SQL_TO_PL6;
55: FUNCTION PL_TO_SQL5(aPlsqlItem DPP_EXECUTIONDETAILS_PVT.DPP_STATUS_UPDATE_TBL_TYPE)
56: RETURN DPP_EXECUTIONDETAILS_PVT_DPP4 IS
57: aSqlItem DPP_EXECUTIONDETAILS_PVT_DPP4;
58: BEGIN
59: -- initialize the table
60: aSqlItem := DPP_EXECUTIONDETAILS_PVT_DPP4();
61: aSqlItem.EXTEND(aPlsqlItem.COUNT);

Line 60: aSqlItem := DPP_EXECUTIONDETAILS_PVT_DPP4();

56: RETURN DPP_EXECUTIONDETAILS_PVT_DPP4 IS
57: aSqlItem DPP_EXECUTIONDETAILS_PVT_DPP4;
58: BEGIN
59: -- initialize the table
60: aSqlItem := DPP_EXECUTIONDETAILS_PVT_DPP4();
61: aSqlItem.EXTEND(aPlsqlItem.COUNT);
62: FOR I IN aPlsqlItem.FIRST..aPlsqlItem.LAST LOOP
63: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL6(aPlsqlItem(I));
64: END LOOP;

Line 67: FUNCTION SQL_TO_PL5(aSqlItem DPP_EXECUTIONDETAILS_PVT_DPP4)

63: aSqlItem(I + 1 - aPlsqlItem.FIRST) := PL_TO_SQL6(aPlsqlItem(I));
64: END LOOP;
65: RETURN aSqlItem;
66: END PL_TO_SQL5;
67: FUNCTION SQL_TO_PL5(aSqlItem DPP_EXECUTIONDETAILS_PVT_DPP4)
68: RETURN DPP_EXECUTIONDETAILS_PVT.DPP_STATUS_UPDATE_TBL_TYPE IS
69: aPlsqlItem DPP_EXECUTIONDETAILS_PVT.DPP_STATUS_UPDATE_TBL_TYPE;
70: BEGIN
71: FOR I IN 1..aSqlItem.COUNT LOOP

Line 79: P_EXE_UPDATE_REC IN OUT NOCOPY DPP_EXECUTIONDETAILS_PVT_DPP_,P_STATUS_UPDATE_TBL IN OUT NOCOPY DPP_EXECUTIONDETAILS_PVT_DPP4) IS

75: END SQL_TO_PL5;
76:
77: PROCEDURE DPP_EXECUTIONDETAILS_PVT$UPDA (P_API_VERSION NUMBER,P_INIT_MSG_LIST VARCHAR2,P_COMMIT VARCHAR2,P_VALIDATION_LEVEL NUMBER,
78: X_RETURN_STATUS OUT NOCOPY VARCHAR2,X_MSG_COUNT OUT NOCOPY NUMBER,X_MSG_DATA OUT NOCOPY VARCHAR2,
79: P_EXE_UPDATE_REC IN OUT NOCOPY DPP_EXECUTIONDETAILS_PVT_DPP_,P_STATUS_UPDATE_TBL IN OUT NOCOPY DPP_EXECUTIONDETAILS_PVT_DPP4) IS
80: P_EXE_UPDATE_REC_ APPS.DPP_EXECUTIONDETAILS_PVT.DPP_EXE_UPDATE_REC_TYPE;
81: P_STATUS_UPDATE_TBL_ APPS.DPP_EXECUTIONDETAILS_PVT.DPP_STATUS_UPDATE_TBL_TYPE;
82: BEGIN
83: P_EXE_UPDATE_REC_ := DPP_BPEL_UPDATEEXECDTLS.SQL_TO_PL4(P_EXE_UPDATE_REC);