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 1156: X_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;

1152:
1153: L_Api_Name CONSTANT VARCHAR2(30) := 'Create_New_L';
1154: L_Api_Verson CONSTANT NUMBER := 1;
1155: L_Return_Status VARCHAR2(1) := OKE_API.G_Ret_Sts_Success;
1156: X_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1157: L_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1158: L_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1159: X_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1160: L_Counter NUMBER;

Line 1157: L_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;

1153: L_Api_Name CONSTANT VARCHAR2(30) := 'Create_New_L';
1154: L_Api_Verson CONSTANT NUMBER := 1;
1155: L_Return_Status VARCHAR2(1) := OKE_API.G_Ret_Sts_Success;
1156: X_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1157: L_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1158: L_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1159: X_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1160: L_Counter NUMBER;
1161:

Line 1158: L_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;

1154: L_Api_Verson CONSTANT NUMBER := 1;
1155: L_Return_Status VARCHAR2(1) := OKE_API.G_Ret_Sts_Success;
1156: X_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1157: L_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1158: L_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1159: X_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1160: L_Counter NUMBER;
1161:
1162: cursor new_c(p_id NUMBER) is

Line 1159: X_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;

1155: L_Return_Status VARCHAR2(1) := OKE_API.G_Ret_Sts_Success;
1156: X_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1157: L_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1158: L_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1159: X_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1160: L_Counter NUMBER;
1161:
1162: cursor new_c(p_id NUMBER) is
1163: select l.k_line_id,

Line 1306: L_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;

1302:
1303: L_Api_Name CONSTANT VARCHAR2(30) := 'Update_Line';
1304: L_Api_Version CONSTANT NUMBER := 1;
1305: L_Return_Status VARCHAR2(1) := OKE_API.G_Ret_Sts_Success;
1306: L_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1307: L_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1308: X_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1309: X_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1310: L_Counter NUMBER;

Line 1307: L_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;

1303: L_Api_Name CONSTANT VARCHAR2(30) := 'Update_Line';
1304: L_Api_Version CONSTANT NUMBER := 1;
1305: L_Return_Status VARCHAR2(1) := OKE_API.G_Ret_Sts_Success;
1306: L_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1307: L_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1308: X_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1309: X_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1310: L_Counter NUMBER;
1311: L_Direction VARCHAR2(30);

Line 1308: X_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;

1304: L_Api_Version CONSTANT NUMBER := 1;
1305: L_Return_Status VARCHAR2(1) := OKE_API.G_Ret_Sts_Success;
1306: L_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1307: L_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1308: X_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1309: X_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1310: L_Counter NUMBER;
1311: L_Direction VARCHAR2(30);
1312: L_Ship_From_Org_ID NUMBER;

Line 1309: X_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;

1305: L_Return_Status VARCHAR2(1) := OKE_API.G_Ret_Sts_Success;
1306: L_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1307: L_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1308: X_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1309: X_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1310: L_Counter NUMBER;
1311: L_Direction VARCHAR2(30);
1312: L_Ship_From_Org_ID NUMBER;
1313: L_Ship_From_Location_ID NUMBER;

Line 1542: L_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;

1538:
1539: L_Api_Name CONSTANT VARCHAR2(30) := 'Update_Batch';
1540: L_Api_Verson CONSTANT NUMBER := 1;
1541: L_Return_Status VARCHAR2(1) := OKE_API.G_Ret_Sts_Success;
1542: L_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1543: L_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1544: X_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1545: X_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1546: L_Counter NUMBER;

Line 1543: L_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;

1539: L_Api_Name CONSTANT VARCHAR2(30) := 'Update_Batch';
1540: L_Api_Verson CONSTANT NUMBER := 1;
1541: L_Return_Status VARCHAR2(1) := OKE_API.G_Ret_Sts_Success;
1542: L_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1543: L_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1544: X_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1545: X_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1546: L_Counter NUMBER;
1547: L_Deliverable_ID NUMBER;

Line 1544: X_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;

1540: L_Api_Verson CONSTANT NUMBER := 1;
1541: L_Return_Status VARCHAR2(1) := OKE_API.G_Ret_Sts_Success;
1542: L_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1543: L_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1544: X_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1545: X_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1546: L_Counter NUMBER;
1547: L_Deliverable_ID NUMBER;
1548: L_Msg_Data VARCHAR2(2000);

Line 1545: X_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;

1541: L_Return_Status VARCHAR2(1) := OKE_API.G_Ret_Sts_Success;
1542: L_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1543: L_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1544: X_Del_Rec OKE_DELIVERABLE_PVT.Del_Rec_Type;
1545: X_Del_Tbl OKE_DELIVERABLE_PVT.Del_Tbl_Type;
1546: L_Counter NUMBER;
1547: L_Deliverable_ID NUMBER;
1548: L_Msg_Data VARCHAR2(2000);
1549: L_Msg_Count NUMBER;