60: RETURN l_org_id;
61: END;
62: FUNCTION PL_TO_SQL_HEAD_REC
63: (
64: aPlsqlItem BOM_BO_PUB.BOM_HEAD_REC_TYPE)
65: RETURN BOM_BO_PUB_BOM_HEAD_REC_TYPE
66: IS
67: aSqlItem BOM_BO_PUB_BOM_HEAD_REC_TYPE;
68: BEGIN
61: END;
62: FUNCTION PL_TO_SQL_HEAD_REC
63: (
64: aPlsqlItem BOM_BO_PUB.BOM_HEAD_REC_TYPE)
65: RETURN BOM_BO_PUB_BOM_HEAD_REC_TYPE
66: IS
67: aSqlItem BOM_BO_PUB_BOM_HEAD_REC_TYPE;
68: BEGIN
69: -- initialize the object
63: (
64: aPlsqlItem BOM_BO_PUB.BOM_HEAD_REC_TYPE)
65: RETURN BOM_BO_PUB_BOM_HEAD_REC_TYPE
66: IS
67: aSqlItem BOM_BO_PUB_BOM_HEAD_REC_TYPE;
68: BEGIN
69: -- initialize the object
70: aSqlItem := BOM_BO_PUB_BOM_HEAD_REC_TYPE(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
71: aSqlItem.ASSEMBLY_ITEM_NAME := aPlsqlItem.ASSEMBLY_ITEM_NAME;
66: IS
67: aSqlItem BOM_BO_PUB_BOM_HEAD_REC_TYPE;
68: BEGIN
69: -- initialize the object
70: aSqlItem := BOM_BO_PUB_BOM_HEAD_REC_TYPE(NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
71: aSqlItem.ASSEMBLY_ITEM_NAME := aPlsqlItem.ASSEMBLY_ITEM_NAME;
72: aSqlItem.ORGANIZATION_ID := Get_Org_Id(aPlsqlItem.ORGANIZATION_CODE);
73: aSqlItem.ALTERNATE_BOM_CODE := aPlsqlItem.ALTERNATE_BOM_CODE;
74: aSqlItem.COMMON_ASSEMBLY_ITEM_NAME := aPlsqlItem.COMMON_ASSEMBLY_ITEM_NAME;
101: RETURN aSqlItem;
102: END PL_TO_SQL_HEAD_REC;
103: FUNCTION SQL_TO_PL_HEAD_REC
104: (
105: aSqlItem BOM_BO_PUB_BOM_HEAD_REC_TYPE)
106: RETURN BOM_BO_PUB.BOM_HEAD_REC_TYPE
107: IS
108: aPlsqlItem BOM_BO_PUB.BOM_HEAD_REC_TYPE;
109: BEGIN
102: END PL_TO_SQL_HEAD_REC;
103: FUNCTION SQL_TO_PL_HEAD_REC
104: (
105: aSqlItem BOM_BO_PUB_BOM_HEAD_REC_TYPE)
106: RETURN BOM_BO_PUB.BOM_HEAD_REC_TYPE
107: IS
108: aPlsqlItem BOM_BO_PUB.BOM_HEAD_REC_TYPE;
109: BEGIN
110: aPlsqlItem.ASSEMBLY_ITEM_NAME := aSqlItem.ASSEMBLY_ITEM_NAME;
104: (
105: aSqlItem BOM_BO_PUB_BOM_HEAD_REC_TYPE)
106: RETURN BOM_BO_PUB.BOM_HEAD_REC_TYPE
107: IS
108: aPlsqlItem BOM_BO_PUB.BOM_HEAD_REC_TYPE;
109: BEGIN
110: aPlsqlItem.ASSEMBLY_ITEM_NAME := aSqlItem.ASSEMBLY_ITEM_NAME;
111: aPlsqlItem.ORGANIZATION_CODE := Get_Org_Code(aSqlItem.ORGANIZATION_ID);
112: aPlsqlItem.ALTERNATE_BOM_CODE := aSqlItem.ALTERNATE_BOM_CODE;