DBA Data[Home] [Help]

APPS.OKE_DEFAULTING_PKG dependencies on OKE_DELIVERABLE_PVT

Line 62: l_del_rec oke_deliverable_pvt.del_rec_type;

58: , X_Msg_Data OUT NOCOPY VARCHAR2
59: , X_Counter OUT NOCOPY NUMBER ) IS
60:
61: l_api_version CONSTANT NUMBER := 1;
62: l_del_rec oke_deliverable_pvt.del_rec_type;
63: l_del_tbl oke_deliverable_pvt.del_tbl_type;
64: l_api_name CONSTANT VARCHAR2(30) := 'DEFAULT_DELIVERABLES';
65:
66: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

Line 63: l_del_tbl oke_deliverable_pvt.del_tbl_type;

59: , X_Counter OUT NOCOPY NUMBER ) IS
60:
61: l_api_version CONSTANT NUMBER := 1;
62: l_del_rec oke_deliverable_pvt.del_rec_type;
63: l_del_tbl oke_deliverable_pvt.del_tbl_type;
64: l_api_name CONSTANT VARCHAR2(30) := 'DEFAULT_DELIVERABLES';
65:
66: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
67: l_buy_or_sell VARCHAR2(1);

Line 929: L_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;

925:
926: L_Api_Name CONSTANT VARCHAR2(30) := 'Create_New_L';
927: L_Api_Version CONSTANT NUMBER := 1;
928: L_Return_Status VARCHAR2(1) := OKE_API.G_Ret_Sts_Success;
929: L_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
930: X_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
931: L_Ship_From_Org_ID NUMBER;
932: L_Ship_From_Location_ID NUMBER;
933: L_Ship_To_Org_ID NUMBER;

Line 930: X_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;

926: L_Api_Name CONSTANT VARCHAR2(30) := 'Create_New_L';
927: L_Api_Version CONSTANT NUMBER := 1;
928: L_Return_Status VARCHAR2(1) := OKE_API.G_Ret_Sts_Success;
929: L_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
930: X_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
931: L_Ship_From_Org_ID NUMBER;
932: L_Ship_From_Location_ID NUMBER;
933: L_Ship_To_Org_ID NUMBER;
934: L_Ship_To_Location_ID NUMBER;

Line 1178: X_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;

1174:
1175: L_Api_Name CONSTANT VARCHAR2(30) := 'Create_New_L';
1176: L_Api_Verson CONSTANT NUMBER := 1;
1177: L_Return_Status VARCHAR2(1) := OKE_API.G_Ret_Sts_Success;
1178: X_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1179: L_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1180: L_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1181: X_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1182: L_Counter NUMBER;

Line 1179: L_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;

1175: L_Api_Name CONSTANT VARCHAR2(30) := 'Create_New_L';
1176: L_Api_Verson CONSTANT NUMBER := 1;
1177: L_Return_Status VARCHAR2(1) := OKE_API.G_Ret_Sts_Success;
1178: X_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1179: L_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1180: L_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1181: X_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1182: L_Counter NUMBER;
1183:

Line 1180: L_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;

1176: L_Api_Verson CONSTANT NUMBER := 1;
1177: L_Return_Status VARCHAR2(1) := OKE_API.G_Ret_Sts_Success;
1178: X_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1179: L_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1180: L_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1181: X_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1182: L_Counter NUMBER;
1183:
1184: cursor new_c(p_id NUMBER) is

Line 1181: X_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;

1177: L_Return_Status VARCHAR2(1) := OKE_API.G_Ret_Sts_Success;
1178: X_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1179: L_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1180: L_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1181: X_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1182: L_Counter NUMBER;
1183:
1184: cursor new_c(p_id NUMBER) is
1185: select l.k_line_id,

Line 1328: L_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;

1324:
1325: L_Api_Name CONSTANT VARCHAR2(30) := 'Update_Line';
1326: L_Api_Version CONSTANT NUMBER := 1;
1327: L_Return_Status VARCHAR2(1) := OKE_API.G_Ret_Sts_Success;
1328: L_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1329: L_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1330: X_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1331: X_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1332: L_Counter NUMBER;

Line 1329: L_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;

1325: L_Api_Name CONSTANT VARCHAR2(30) := 'Update_Line';
1326: L_Api_Version CONSTANT NUMBER := 1;
1327: L_Return_Status VARCHAR2(1) := OKE_API.G_Ret_Sts_Success;
1328: L_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1329: L_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1330: X_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1331: X_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1332: L_Counter NUMBER;
1333: L_Direction VARCHAR2(30);

Line 1330: X_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;

1326: L_Api_Version CONSTANT NUMBER := 1;
1327: L_Return_Status VARCHAR2(1) := OKE_API.G_Ret_Sts_Success;
1328: L_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1329: L_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1330: X_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1331: X_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1332: L_Counter NUMBER;
1333: L_Direction VARCHAR2(30);
1334: L_Ship_From_Org_ID NUMBER;

Line 1331: X_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;

1327: L_Return_Status VARCHAR2(1) := OKE_API.G_Ret_Sts_Success;
1328: L_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1329: L_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1330: X_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1331: X_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1332: L_Counter NUMBER;
1333: L_Direction VARCHAR2(30);
1334: L_Ship_From_Org_ID NUMBER;
1335: L_Ship_From_Location_ID NUMBER;

Line 1564: L_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;

1560:
1561: L_Api_Name CONSTANT VARCHAR2(30) := 'Update_Batch';
1562: L_Api_Verson CONSTANT NUMBER := 1;
1563: L_Return_Status VARCHAR2(1) := OKE_API.G_Ret_Sts_Success;
1564: L_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1565: L_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1566: X_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1567: X_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1568: L_Counter NUMBER;

Line 1565: L_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;

1561: L_Api_Name CONSTANT VARCHAR2(30) := 'Update_Batch';
1562: L_Api_Verson CONSTANT NUMBER := 1;
1563: L_Return_Status VARCHAR2(1) := OKE_API.G_Ret_Sts_Success;
1564: L_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1565: L_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1566: X_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1567: X_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1568: L_Counter NUMBER;
1569: L_Deliverable_ID NUMBER;

Line 1566: X_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;

1562: L_Api_Verson CONSTANT NUMBER := 1;
1563: L_Return_Status VARCHAR2(1) := OKE_API.G_Ret_Sts_Success;
1564: L_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1565: L_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1566: X_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1567: X_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1568: L_Counter NUMBER;
1569: L_Deliverable_ID NUMBER;
1570: L_Msg_Data VARCHAR2(2000);

Line 1567: X_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;

1563: L_Return_Status VARCHAR2(1) := OKE_API.G_Ret_Sts_Success;
1564: L_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1565: L_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1566: X_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1567: X_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1568: L_Counter NUMBER;
1569: L_Deliverable_ID NUMBER;
1570: L_Msg_Data VARCHAR2(2000);
1571: L_Msg_Count NUMBER;