348: END get_actual_move_ops;
349:
350: PROCEDURE get_osp_move_details
351: IS
352: l_transaction_type NUMBER := FND_API.G_MISS_NUM;
353: l_transaction_quantity NUMBER := FND_API.G_MISS_NUM;
354: l_primary_quantity NUMBER := FND_API.G_MISS_NUM;
355: l_fm_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
356: l_fm_intraop_step_type NUMBER := FND_API.G_MISS_NUM;
349:
350: PROCEDURE get_osp_move_details
351: IS
352: l_transaction_type NUMBER := FND_API.G_MISS_NUM;
353: l_transaction_quantity NUMBER := FND_API.G_MISS_NUM;
354: l_primary_quantity NUMBER := FND_API.G_MISS_NUM;
355: l_fm_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
356: l_fm_intraop_step_type NUMBER := FND_API.G_MISS_NUM;
357: l_fm_department_id NUMBER := FND_API.G_MISS_NUM;
350: PROCEDURE get_osp_move_details
351: IS
352: l_transaction_type NUMBER := FND_API.G_MISS_NUM;
353: l_transaction_quantity NUMBER := FND_API.G_MISS_NUM;
354: l_primary_quantity NUMBER := FND_API.G_MISS_NUM;
355: l_fm_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
356: l_fm_intraop_step_type NUMBER := FND_API.G_MISS_NUM;
357: l_fm_department_id NUMBER := FND_API.G_MISS_NUM;
358: l_to_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
351: IS
352: l_transaction_type NUMBER := FND_API.G_MISS_NUM;
353: l_transaction_quantity NUMBER := FND_API.G_MISS_NUM;
354: l_primary_quantity NUMBER := FND_API.G_MISS_NUM;
355: l_fm_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
356: l_fm_intraop_step_type NUMBER := FND_API.G_MISS_NUM;
357: l_fm_department_id NUMBER := FND_API.G_MISS_NUM;
358: l_to_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
359: l_to_intraop_step_type NUMBER := FND_API.G_MISS_NUM;
352: l_transaction_type NUMBER := FND_API.G_MISS_NUM;
353: l_transaction_quantity NUMBER := FND_API.G_MISS_NUM;
354: l_primary_quantity NUMBER := FND_API.G_MISS_NUM;
355: l_fm_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
356: l_fm_intraop_step_type NUMBER := FND_API.G_MISS_NUM;
357: l_fm_department_id NUMBER := FND_API.G_MISS_NUM;
358: l_to_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
359: l_to_intraop_step_type NUMBER := FND_API.G_MISS_NUM;
360: l_to_department_id NUMBER := FND_API.G_MISS_NUM;
353: l_transaction_quantity NUMBER := FND_API.G_MISS_NUM;
354: l_primary_quantity NUMBER := FND_API.G_MISS_NUM;
355: l_fm_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
356: l_fm_intraop_step_type NUMBER := FND_API.G_MISS_NUM;
357: l_fm_department_id NUMBER := FND_API.G_MISS_NUM;
358: l_to_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
359: l_to_intraop_step_type NUMBER := FND_API.G_MISS_NUM;
360: l_to_department_id NUMBER := FND_API.G_MISS_NUM;
361: l_correction_type NUMBER;
354: l_primary_quantity NUMBER := FND_API.G_MISS_NUM;
355: l_fm_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
356: l_fm_intraop_step_type NUMBER := FND_API.G_MISS_NUM;
357: l_fm_department_id NUMBER := FND_API.G_MISS_NUM;
358: l_to_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
359: l_to_intraop_step_type NUMBER := FND_API.G_MISS_NUM;
360: l_to_department_id NUMBER := FND_API.G_MISS_NUM;
361: l_correction_type NUMBER;
362: l_wip_entity_id NUMBER := FND_API.G_MISS_NUM;
355: l_fm_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
356: l_fm_intraop_step_type NUMBER := FND_API.G_MISS_NUM;
357: l_fm_department_id NUMBER := FND_API.G_MISS_NUM;
358: l_to_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
359: l_to_intraop_step_type NUMBER := FND_API.G_MISS_NUM;
360: l_to_department_id NUMBER := FND_API.G_MISS_NUM;
361: l_correction_type NUMBER;
362: l_wip_entity_id NUMBER := FND_API.G_MISS_NUM;
363: l_organization_id NUMBER := FND_API.G_MISS_NUM;
356: l_fm_intraop_step_type NUMBER := FND_API.G_MISS_NUM;
357: l_fm_department_id NUMBER := FND_API.G_MISS_NUM;
358: l_to_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
359: l_to_intraop_step_type NUMBER := FND_API.G_MISS_NUM;
360: l_to_department_id NUMBER := FND_API.G_MISS_NUM;
361: l_correction_type NUMBER;
362: l_wip_entity_id NUMBER := FND_API.G_MISS_NUM;
363: l_organization_id NUMBER := FND_API.G_MISS_NUM;
364: l_osp_op_seq NUMBER := FND_API.G_MISS_NUM;
358: l_to_operation_seq_num NUMBER := FND_API.G_MISS_NUM;
359: l_to_intraop_step_type NUMBER := FND_API.G_MISS_NUM;
360: l_to_department_id NUMBER := FND_API.G_MISS_NUM;
361: l_correction_type NUMBER;
362: l_wip_entity_id NUMBER := FND_API.G_MISS_NUM;
363: l_organization_id NUMBER := FND_API.G_MISS_NUM;
364: l_osp_op_seq NUMBER := FND_API.G_MISS_NUM;
365: l_line_id NUMBER := FND_API.G_MISS_NUM;
366: l_rep_sch_id NUMBER := FND_API.G_MISS_NUM;
359: l_to_intraop_step_type NUMBER := FND_API.G_MISS_NUM;
360: l_to_department_id NUMBER := FND_API.G_MISS_NUM;
361: l_correction_type NUMBER;
362: l_wip_entity_id NUMBER := FND_API.G_MISS_NUM;
363: l_organization_id NUMBER := FND_API.G_MISS_NUM;
364: l_osp_op_seq NUMBER := FND_API.G_MISS_NUM;
365: l_line_id NUMBER := FND_API.G_MISS_NUM;
366: l_rep_sch_id NUMBER := FND_API.G_MISS_NUM;
367: l_cur_op_seq NUMBER := FND_API.G_MISS_NUM;
360: l_to_department_id NUMBER := FND_API.G_MISS_NUM;
361: l_correction_type NUMBER;
362: l_wip_entity_id NUMBER := FND_API.G_MISS_NUM;
363: l_organization_id NUMBER := FND_API.G_MISS_NUM;
364: l_osp_op_seq NUMBER := FND_API.G_MISS_NUM;
365: l_line_id NUMBER := FND_API.G_MISS_NUM;
366: l_rep_sch_id NUMBER := FND_API.G_MISS_NUM;
367: l_cur_op_seq NUMBER := FND_API.G_MISS_NUM;
368: l_cur_qty_in_queue NUMBER := FND_API.G_MISS_NUM;
361: l_correction_type NUMBER;
362: l_wip_entity_id NUMBER := FND_API.G_MISS_NUM;
363: l_organization_id NUMBER := FND_API.G_MISS_NUM;
364: l_osp_op_seq NUMBER := FND_API.G_MISS_NUM;
365: l_line_id NUMBER := FND_API.G_MISS_NUM;
366: l_rep_sch_id NUMBER := FND_API.G_MISS_NUM;
367: l_cur_op_seq NUMBER := FND_API.G_MISS_NUM;
368: l_cur_qty_in_queue NUMBER := FND_API.G_MISS_NUM;
369: l_cur_qty_to_move NUMBER := FND_API.G_MISS_NUM;
362: l_wip_entity_id NUMBER := FND_API.G_MISS_NUM;
363: l_organization_id NUMBER := FND_API.G_MISS_NUM;
364: l_osp_op_seq NUMBER := FND_API.G_MISS_NUM;
365: l_line_id NUMBER := FND_API.G_MISS_NUM;
366: l_rep_sch_id NUMBER := FND_API.G_MISS_NUM;
367: l_cur_op_seq NUMBER := FND_API.G_MISS_NUM;
368: l_cur_qty_in_queue NUMBER := FND_API.G_MISS_NUM;
369: l_cur_qty_to_move NUMBER := FND_API.G_MISS_NUM;
370: l_next_op_seq NUMBER := FND_API.G_MISS_NUM;
363: l_organization_id NUMBER := FND_API.G_MISS_NUM;
364: l_osp_op_seq NUMBER := FND_API.G_MISS_NUM;
365: l_line_id NUMBER := FND_API.G_MISS_NUM;
366: l_rep_sch_id NUMBER := FND_API.G_MISS_NUM;
367: l_cur_op_seq NUMBER := FND_API.G_MISS_NUM;
368: l_cur_qty_in_queue NUMBER := FND_API.G_MISS_NUM;
369: l_cur_qty_to_move NUMBER := FND_API.G_MISS_NUM;
370: l_next_op_seq NUMBER := FND_API.G_MISS_NUM;
371: l_next_qty_in_queue NUMBER := FND_API.G_MISS_NUM;
364: l_osp_op_seq NUMBER := FND_API.G_MISS_NUM;
365: l_line_id NUMBER := FND_API.G_MISS_NUM;
366: l_rep_sch_id NUMBER := FND_API.G_MISS_NUM;
367: l_cur_op_seq NUMBER := FND_API.G_MISS_NUM;
368: l_cur_qty_in_queue NUMBER := FND_API.G_MISS_NUM;
369: l_cur_qty_to_move NUMBER := FND_API.G_MISS_NUM;
370: l_next_op_seq NUMBER := FND_API.G_MISS_NUM;
371: l_next_qty_in_queue NUMBER := FND_API.G_MISS_NUM;
372: l_next_qty_to_move NUMBER := FND_API.G_MISS_NUM;
365: l_line_id NUMBER := FND_API.G_MISS_NUM;
366: l_rep_sch_id NUMBER := FND_API.G_MISS_NUM;
367: l_cur_op_seq NUMBER := FND_API.G_MISS_NUM;
368: l_cur_qty_in_queue NUMBER := FND_API.G_MISS_NUM;
369: l_cur_qty_to_move NUMBER := FND_API.G_MISS_NUM;
370: l_next_op_seq NUMBER := FND_API.G_MISS_NUM;
371: l_next_qty_in_queue NUMBER := FND_API.G_MISS_NUM;
372: l_next_qty_to_move NUMBER := FND_API.G_MISS_NUM;
373: l_basis_type NUMBER := FND_API.G_MISS_NUM;
366: l_rep_sch_id NUMBER := FND_API.G_MISS_NUM;
367: l_cur_op_seq NUMBER := FND_API.G_MISS_NUM;
368: l_cur_qty_in_queue NUMBER := FND_API.G_MISS_NUM;
369: l_cur_qty_to_move NUMBER := FND_API.G_MISS_NUM;
370: l_next_op_seq NUMBER := FND_API.G_MISS_NUM;
371: l_next_qty_in_queue NUMBER := FND_API.G_MISS_NUM;
372: l_next_qty_to_move NUMBER := FND_API.G_MISS_NUM;
373: l_basis_type NUMBER := FND_API.G_MISS_NUM;
374: l_neg_qty_indicator boolean;
367: l_cur_op_seq NUMBER := FND_API.G_MISS_NUM;
368: l_cur_qty_in_queue NUMBER := FND_API.G_MISS_NUM;
369: l_cur_qty_to_move NUMBER := FND_API.G_MISS_NUM;
370: l_next_op_seq NUMBER := FND_API.G_MISS_NUM;
371: l_next_qty_in_queue NUMBER := FND_API.G_MISS_NUM;
372: l_next_qty_to_move NUMBER := FND_API.G_MISS_NUM;
373: l_basis_type NUMBER := FND_API.G_MISS_NUM;
374: l_neg_qty_indicator boolean;
375: BEGIN
368: l_cur_qty_in_queue NUMBER := FND_API.G_MISS_NUM;
369: l_cur_qty_to_move NUMBER := FND_API.G_MISS_NUM;
370: l_next_op_seq NUMBER := FND_API.G_MISS_NUM;
371: l_next_qty_in_queue NUMBER := FND_API.G_MISS_NUM;
372: l_next_qty_to_move NUMBER := FND_API.G_MISS_NUM;
373: l_basis_type NUMBER := FND_API.G_MISS_NUM;
374: l_neg_qty_indicator boolean;
375: BEGIN
376:
369: l_cur_qty_to_move NUMBER := FND_API.G_MISS_NUM;
370: l_next_op_seq NUMBER := FND_API.G_MISS_NUM;
371: l_next_qty_in_queue NUMBER := FND_API.G_MISS_NUM;
372: l_next_qty_to_move NUMBER := FND_API.G_MISS_NUM;
373: l_basis_type NUMBER := FND_API.G_MISS_NUM;
374: l_neg_qty_indicator boolean;
375: BEGIN
376:
377: l_wip_entity_id := g_OSP_rec.wip_entity_id;
586: RETURN NULL;
587:
588: EXCEPTION
589: WHEN OTHERS THEN
590: RETURN FND_API.G_MISS_NUM;
591:
592: END Get_Acct_Period;
593:
594: FUNCTION Get_Created_By_Name
608: RETURN NULL;
609:
610: EXCEPTION
611: WHEN OTHERS THEN
612: RETURN FND_API.G_MISS_CHAR;
613:
614: END Get_Created_By_Name;
615:
616: FUNCTION Get_Created_By
629: RETURN NULL;
630:
631: EXCEPTION
632: WHEN OTHERS THEN
633: RETURN FND_API.G_MISS_CHAR;
634:
635: END Get_Created_By;
636:
637: FUNCTION Get_Entity_Type
659: RETURN NULL;
660:
661: EXCEPTION
662: WHEN OTHERS THEN
663: RETURN FND_API.G_MISS_NUM;
664:
665: END Get_Entity_Type;
666:
667: FUNCTION Get_Fm_Department_Code
686: RETURN NULL;
687:
688: EXCEPTION
689: WHEN OTHERS THEN
690: RETURN FND_API.G_MISS_CHAR;
691:
692: END Get_Fm_Department_Code;
693:
694: FUNCTION Get_Fm_Department_Id
728: RETURN NULL;
729:
730: EXCEPTION
731: WHEN OTHERS THEN
732: RETURN FND_API.G_MISS_NUM;
733:
734: END Get_Fm_Department_Id;
735:
736: FUNCTION Get_Fm_Intraop_Step_Type
754: RETURN NULL;
755:
756: EXCEPTION
757: WHEN OTHERS THEN
758: RETURN FND_API.G_MISS_NUM;
759:
760: END Get_Fm_Intraop_Step_Type;
761:
762: FUNCTION Get_Fm_Operation
771: RETURN NULL;
772:
773: EXCEPTION
774: WHEN OTHERS THEN
775: RETURN FND_API.G_MISS_CHAR;
776:
777: END Get_Fm_Operation;
778:
779: FUNCTION Get_Fm_Operation_Seq_Num
798: RETURN NULL;
799:
800: EXCEPTION
801: WHEN OTHERS THEN
802: RETURN FND_API.G_MISS_NUM;
803:
804: END Get_Fm_Operation_Seq_Num;
805:
806: FUNCTION Get_Group
815: RETURN NULL;
816:
817: EXCEPTION
818: WHEN OTHERS THEN
819: RETURN FND_API.G_MISS_NUM;
820:
821: END Get_Group;
822:
823: FUNCTION Get_Kanban_Card
839: RETURN NULL;
840:
841: EXCEPTION
842: WHEN OTHERS THEN
843: RETURN FND_API.G_MISS_NUM;
844:
845: END Get_Kanban_Card;
846:
847: FUNCTION Get_Last_Updated_By_Name
860: RETURN NULL;
861:
862: EXCEPTION
863: WHEN OTHERS THEN
864: RETURN FND_API.G_MISS_CHAR;
865:
866: END Get_Last_Updated_By_Name;
867:
868: FUNCTION Get_Last_Update_Login
881: RETURN NULL;
882:
883: EXCEPTION
884: WHEN OTHERS THEN
885: RETURN FND_API.G_MISS_CHAR;
886:
887: END Get_Last_Update_Login;
888:
889: FUNCTION Get_Request_Id
902: RETURN NULL;
903:
904: EXCEPTION
905: WHEN OTHERS THEN
906: RETURN FND_API.G_MISS_CHAR;
907:
908: END Get_Request_Id;
909:
910: FUNCTION Get_Program_Id
923: RETURN NULL;
924:
925: EXCEPTION
926: WHEN OTHERS THEN
927: RETURN FND_API.G_MISS_CHAR;
928:
929: END Get_Program_Id;
930:
931: FUNCTION Get_Program_Application_Id
944: RETURN NULL;
945:
946: EXCEPTION
947: WHEN OTHERS THEN
948: RETURN FND_API.G_MISS_CHAR;
949:
950: END Get_Program_Application_Id;
951:
952: FUNCTION Get_Program_Update_Date
965: RETURN NULL;
966:
967: EXCEPTION
968: WHEN OTHERS THEN
969: RETURN FND_API.G_MISS_DATE;
970:
971: END Get_Program_Update_Date;
972:
973: FUNCTION Get_Last_Updated_By
986: RETURN NULL;
987:
988: EXCEPTION
989: WHEN OTHERS THEN
990: RETURN FND_API.G_MISS_CHAR;
991:
992: END Get_Last_Updated_By;
993:
994: FUNCTION Get_Line_Code
1015: RETURN NULL;
1016:
1017: EXCEPTION
1018: WHEN OTHERS THEN
1019: RETURN FND_API.G_MISS_CHAR;
1020:
1021: END Get_Line_Code;
1022:
1023: FUNCTION Get_Line_Id
1036: RETURN NULL;
1037:
1038: EXCEPTION
1039: WHEN OTHERS THEN
1040: RETURN FND_API.G_MISS_NUM;
1041:
1042: END Get_Line_Id;
1043:
1044: FUNCTION Get_Organization_Code
1062: RETURN NULL;
1063:
1064: EXCEPTION
1065: WHEN OTHERS THEN
1066: RETURN FND_API.G_MISS_CHAR;
1067:
1068: END Get_Organization_Code;
1069:
1070: FUNCTION Get_Organization_Id
1083: RETURN NULL;
1084:
1085: EXCEPTION
1086: WHEN OTHERS THEN
1087: RETURN FND_API.G_MISS_NUM;
1088:
1089: END Get_Organization_Id;
1090:
1091: FUNCTION Get_Overcpl_Primary_Qty
1213: fnd_msg_pub.add_exc_msg('WIP_Default_Shopfloormove','get_overcpl_primary_qty: select from RT');
1214: end;
1215:
1216: IF (l_interface_txn_id IS NULL) THEN
1217: RAISE fnd_api.g_exc_error;
1218: END IF;
1219:
1220: begin
1221: SELECT item_id
1379: RETURN l_overcpl_primary_qty;
1380:
1381: EXCEPTION
1382: WHEN OTHERS THEN
1383: RETURN FND_API.G_MISS_NUM;
1384: END Get_Overcpl_Primary_Qty;
1385:
1386: FUNCTION Get_Overcpl_Transaction
1387: RETURN NUMBER
1395: RETURN NULL;
1396:
1397: EXCEPTION
1398: WHEN OTHERS THEN
1399: RETURN FND_API.G_MISS_NUM;
1400:
1401: END Get_Overcpl_Transaction;
1402:
1403: FUNCTION Get_Overcpl_Transaction_Qty
1432: RETURN NULL;
1433:
1434: EXCEPTION
1435: WHEN OTHERS THEN
1436: RETURN FND_API.G_MISS_NUM;
1437:
1438: END Get_Overcpl_Transaction_Qty;
1439:
1440: FUNCTION Get_Primary_Item
1462: RETURN NULL;
1463:
1464: EXCEPTION
1465: WHEN OTHERS THEN
1466: RETURN FND_API.G_MISS_NUM;
1467:
1468: END Get_Primary_Item;
1469:
1470: FUNCTION Get_Primary_Quantity
1488: RETURN NULL;
1489:
1490: EXCEPTION
1491: WHEN OTHERS THEN
1492: RETURN FND_API.G_MISS_NUM;
1493:
1494: END Get_Primary_Quantity;
1495:
1496: FUNCTION Get_Primary_Uom
1518: RETURN NULL;
1519:
1520: EXCEPTION
1521: WHEN OTHERS THEN
1522: RETURN FND_API.G_MISS_CHAR;
1523:
1524: END Get_Primary_Uom;
1525:
1526: FUNCTION Get_Process_Phase
1539: RETURN NULL;
1540:
1541: EXCEPTION
1542: WHEN OTHERS THEN
1543: RETURN FND_API.G_MISS_NUM;
1544:
1545: END Get_Process_Phase;
1546:
1547: FUNCTION Get_Process_Status
1560: RETURN NULL;
1561:
1562: EXCEPTION
1563: WHEN OTHERS THEN
1564: RETURN FND_API.G_MISS_NUM;
1565:
1566: END Get_Process_Status;
1567:
1568: FUNCTION Get_Qa_Collection
1577: RETURN NULL;
1578:
1579: EXCEPTION
1580: WHEN OTHERS THEN
1581: RETURN FND_API.G_MISS_NUM;
1582:
1583: END Get_Qa_Collection;
1584:
1585: FUNCTION Get_Reason
1598: RETURN NULL;
1599:
1600: EXCEPTION
1601: WHEN OTHERS THEN
1602: RETURN FND_API.G_MISS_NUM;
1603:
1604: END Get_Reason;
1605:
1606: FUNCTION Get_Reason_Name
1619: RETURN NULL;
1620:
1621: EXCEPTION
1622: WHEN OTHERS THEN
1623: RETURN FND_API.G_MISS_CHAR;
1624:
1625: END Get_Reason_Name;
1626:
1627: FUNCTION Get_Reference
1640: RETURN NULL;
1641:
1642: EXCEPTION
1643: WHEN OTHERS THEN
1644: RETURN FND_API.G_MISS_NUM;
1645:
1646: END Get_Reference;
1647:
1648: FUNCTION Get_Repetitive_Schedule
1661: RETURN NULL;
1662:
1663: EXCEPTION
1664: WHEN OTHERS THEN
1665: RETURN FND_API.G_MISS_NUM;
1666:
1667: END Get_Repetitive_Schedule;
1668:
1669: FUNCTION Get_Scrap_Account
1678: RETURN NULL;
1679:
1680: EXCEPTION
1681: WHEN OTHERS THEN
1682: RETURN FND_API.G_MISS_NUM;
1683:
1684: END Get_Scrap_Account;
1685:
1686: FUNCTION Get_Source
1699: RETURN NULL;
1700:
1701: EXCEPTION
1702: WHEN OTHERS THEN
1703: RETURN FND_API.G_MISS_CHAR;
1704:
1705: END Get_Source;
1706:
1707: FUNCTION Get_Source_Line
1720: RETURN NULL;
1721:
1722: EXCEPTION
1723: WHEN OTHERS THEN
1724: RETURN FND_API.G_MISS_NUM;
1725:
1726: END Get_Source_Line;
1727:
1728: FUNCTION Get_To_Department_Code
1752: RETURN NULL;
1753:
1754: EXCEPTION
1755: WHEN OTHERS THEN
1756: RETURN FND_API.G_MISS_CHAR;
1757:
1758: END Get_To_Department_Code;
1759:
1760: FUNCTION Get_To_Department_Id
1794: RETURN NULL;
1795:
1796: EXCEPTION
1797: WHEN OTHERS THEN
1798: RETURN FND_API.G_MISS_NUM;
1799:
1800: END Get_To_Department_Id;
1801:
1802: FUNCTION Get_To_Intraop_Step_Type
1820: RETURN NULL;
1821:
1822: EXCEPTION
1823: WHEN OTHERS THEN
1824: RETURN FND_API.G_MISS_NUM;
1825:
1826: END Get_To_Intraop_Step_Type;
1827:
1828: FUNCTION Get_To_Operation
1837: RETURN NULL;
1838:
1839: EXCEPTION
1840: WHEN OTHERS THEN
1841: RETURN FND_API.G_MISS_CHAR;
1842:
1843: END Get_To_Operation;
1844:
1845: FUNCTION Get_To_Operation_Seq_Num
1863: RETURN NULL;
1864:
1865: EXCEPTION
1866: WHEN OTHERS THEN
1867: RETURN FND_API.G_MISS_NUM;
1868:
1869: END Get_To_Operation_Seq_Num;
1870:
1871: FUNCTION Get_Transaction_Date
1884: RETURN NULL;
1885:
1886: EXCEPTION
1887: WHEN OTHERS THEN
1888: RETURN FND_API.G_MISS_DATE;
1889:
1890: END Get_Transaction_Date;
1891:
1892: FUNCTION Get_Transaction
1901: RETURN NULL;
1902:
1903: EXCEPTION
1904: WHEN OTHERS THEN
1905: RETURN FND_API.G_MISS_NUM;
1906:
1907: END Get_Transaction;
1908:
1909: FUNCTION Get_Transaction_Quantity
1927: RETURN NULL;
1928:
1929: EXCEPTION
1930: WHEN OTHERS THEN
1931: RETURN FND_API.G_MISS_NUM;
1932:
1933: END Get_Transaction_Quantity;
1934:
1935: FUNCTION Get_Transaction_Type
1953: RETURN NULL;
1954:
1955: EXCEPTION
1956: WHEN OTHERS THEN
1957: RETURN FND_API.G_MISS_NUM;
1958:
1959: END Get_Transaction_Type;
1960:
1961: FUNCTION Get_Transaction_Uom
1974: RETURN NULL;
1975:
1976: EXCEPTION
1977: WHEN OTHERS THEN
1978: RETURN FND_API.G_MISS_NUM;
1979:
1980: END Get_Transaction_Uom;
1981:
1982: FUNCTION Get_Wip_Entity
1995: RETURN NULL;
1996:
1997: EXCEPTION
1998: WHEN OTHERS THEN
1999: RETURN FND_API.G_MISS_NUM;
2000:
2001: END Get_Wip_Entity;
2002:
2003: FUNCTION Get_Wip_Entity_Name
2025: RETURN NULL;
2026:
2027: EXCEPTION
2028: WHEN OTHERS THEN
2029: RETURN FND_API.G_MISS_CHAR;
2030:
2031: END Get_Wip_Entity_Name;
2032:
2033: PROCEDURE Get_Flex_Shopfloormove
2035: BEGIN
2036:
2037: -- In the future call Flex APIs for defaults
2038:
2039: IF g_ShopFloorMove_rec.attribute1 = FND_API.G_MISS_CHAR THEN
2040: g_ShopFloorMove_rec.attribute1 := NULL;
2041: END IF;
2042:
2043: IF g_ShopFloorMove_rec.attribute10 = FND_API.G_MISS_CHAR THEN
2039: IF g_ShopFloorMove_rec.attribute1 = FND_API.G_MISS_CHAR THEN
2040: g_ShopFloorMove_rec.attribute1 := NULL;
2041: END IF;
2042:
2043: IF g_ShopFloorMove_rec.attribute10 = FND_API.G_MISS_CHAR THEN
2044: g_ShopFloorMove_rec.attribute10 := NULL;
2045: END IF;
2046:
2047: IF g_ShopFloorMove_rec.attribute11 = FND_API.G_MISS_CHAR THEN
2043: IF g_ShopFloorMove_rec.attribute10 = FND_API.G_MISS_CHAR THEN
2044: g_ShopFloorMove_rec.attribute10 := NULL;
2045: END IF;
2046:
2047: IF g_ShopFloorMove_rec.attribute11 = FND_API.G_MISS_CHAR THEN
2048: g_ShopFloorMove_rec.attribute11 := NULL;
2049: END IF;
2050:
2051: IF g_ShopFloorMove_rec.attribute12 = FND_API.G_MISS_CHAR THEN
2047: IF g_ShopFloorMove_rec.attribute11 = FND_API.G_MISS_CHAR THEN
2048: g_ShopFloorMove_rec.attribute11 := NULL;
2049: END IF;
2050:
2051: IF g_ShopFloorMove_rec.attribute12 = FND_API.G_MISS_CHAR THEN
2052: g_ShopFloorMove_rec.attribute12 := NULL;
2053: END IF;
2054:
2055: IF g_ShopFloorMove_rec.attribute13 = FND_API.G_MISS_CHAR THEN
2051: IF g_ShopFloorMove_rec.attribute12 = FND_API.G_MISS_CHAR THEN
2052: g_ShopFloorMove_rec.attribute12 := NULL;
2053: END IF;
2054:
2055: IF g_ShopFloorMove_rec.attribute13 = FND_API.G_MISS_CHAR THEN
2056: g_ShopFloorMove_rec.attribute13 := NULL;
2057: END IF;
2058:
2059: IF g_ShopFloorMove_rec.attribute14 = FND_API.G_MISS_CHAR THEN
2055: IF g_ShopFloorMove_rec.attribute13 = FND_API.G_MISS_CHAR THEN
2056: g_ShopFloorMove_rec.attribute13 := NULL;
2057: END IF;
2058:
2059: IF g_ShopFloorMove_rec.attribute14 = FND_API.G_MISS_CHAR THEN
2060: g_ShopFloorMove_rec.attribute14 := NULL;
2061: END IF;
2062:
2063: IF g_ShopFloorMove_rec.attribute15 = FND_API.G_MISS_CHAR THEN
2059: IF g_ShopFloorMove_rec.attribute14 = FND_API.G_MISS_CHAR THEN
2060: g_ShopFloorMove_rec.attribute14 := NULL;
2061: END IF;
2062:
2063: IF g_ShopFloorMove_rec.attribute15 = FND_API.G_MISS_CHAR THEN
2064: g_ShopFloorMove_rec.attribute15 := NULL;
2065: END IF;
2066:
2067: IF g_ShopFloorMove_rec.attribute2 = FND_API.G_MISS_CHAR THEN
2063: IF g_ShopFloorMove_rec.attribute15 = FND_API.G_MISS_CHAR THEN
2064: g_ShopFloorMove_rec.attribute15 := NULL;
2065: END IF;
2066:
2067: IF g_ShopFloorMove_rec.attribute2 = FND_API.G_MISS_CHAR THEN
2068: g_ShopFloorMove_rec.attribute2 := NULL;
2069: END IF;
2070:
2071: IF g_ShopFloorMove_rec.attribute3 = FND_API.G_MISS_CHAR THEN
2067: IF g_ShopFloorMove_rec.attribute2 = FND_API.G_MISS_CHAR THEN
2068: g_ShopFloorMove_rec.attribute2 := NULL;
2069: END IF;
2070:
2071: IF g_ShopFloorMove_rec.attribute3 = FND_API.G_MISS_CHAR THEN
2072: g_ShopFloorMove_rec.attribute3 := NULL;
2073: END IF;
2074:
2075: IF g_ShopFloorMove_rec.attribute4 = FND_API.G_MISS_CHAR THEN
2071: IF g_ShopFloorMove_rec.attribute3 = FND_API.G_MISS_CHAR THEN
2072: g_ShopFloorMove_rec.attribute3 := NULL;
2073: END IF;
2074:
2075: IF g_ShopFloorMove_rec.attribute4 = FND_API.G_MISS_CHAR THEN
2076: g_ShopFloorMove_rec.attribute4 := NULL;
2077: END IF;
2078:
2079: IF g_ShopFloorMove_rec.attribute5 = FND_API.G_MISS_CHAR THEN
2075: IF g_ShopFloorMove_rec.attribute4 = FND_API.G_MISS_CHAR THEN
2076: g_ShopFloorMove_rec.attribute4 := NULL;
2077: END IF;
2078:
2079: IF g_ShopFloorMove_rec.attribute5 = FND_API.G_MISS_CHAR THEN
2080: g_ShopFloorMove_rec.attribute5 := NULL;
2081: END IF;
2082:
2083: IF g_ShopFloorMove_rec.attribute6 = FND_API.G_MISS_CHAR THEN
2079: IF g_ShopFloorMove_rec.attribute5 = FND_API.G_MISS_CHAR THEN
2080: g_ShopFloorMove_rec.attribute5 := NULL;
2081: END IF;
2082:
2083: IF g_ShopFloorMove_rec.attribute6 = FND_API.G_MISS_CHAR THEN
2084: g_ShopFloorMove_rec.attribute6 := NULL;
2085: END IF;
2086:
2087: IF g_ShopFloorMove_rec.attribute7 = FND_API.G_MISS_CHAR THEN
2083: IF g_ShopFloorMove_rec.attribute6 = FND_API.G_MISS_CHAR THEN
2084: g_ShopFloorMove_rec.attribute6 := NULL;
2085: END IF;
2086:
2087: IF g_ShopFloorMove_rec.attribute7 = FND_API.G_MISS_CHAR THEN
2088: g_ShopFloorMove_rec.attribute7 := NULL;
2089: END IF;
2090:
2091: IF g_ShopFloorMove_rec.attribute8 = FND_API.G_MISS_CHAR THEN
2087: IF g_ShopFloorMove_rec.attribute7 = FND_API.G_MISS_CHAR THEN
2088: g_ShopFloorMove_rec.attribute7 := NULL;
2089: END IF;
2090:
2091: IF g_ShopFloorMove_rec.attribute8 = FND_API.G_MISS_CHAR THEN
2092: g_ShopFloorMove_rec.attribute8 := NULL;
2093: END IF;
2094:
2095: IF g_ShopFloorMove_rec.attribute9 = FND_API.G_MISS_CHAR THEN
2091: IF g_ShopFloorMove_rec.attribute8 = FND_API.G_MISS_CHAR THEN
2092: g_ShopFloorMove_rec.attribute8 := NULL;
2093: END IF;
2094:
2095: IF g_ShopFloorMove_rec.attribute9 = FND_API.G_MISS_CHAR THEN
2096: g_ShopFloorMove_rec.attribute9 := NULL;
2097: END IF;
2098:
2099: IF g_ShopFloorMove_rec.attribute_category = FND_API.G_MISS_CHAR THEN
2095: IF g_ShopFloorMove_rec.attribute9 = FND_API.G_MISS_CHAR THEN
2096: g_ShopFloorMove_rec.attribute9 := NULL;
2097: END IF;
2098:
2099: IF g_ShopFloorMove_rec.attribute_category = FND_API.G_MISS_CHAR THEN
2100: g_ShopFloorMove_rec.attribute_category := NULL;
2101: END IF;
2102:
2103: END Get_Flex_Shopfloormove;
2123: FND_MSG_PUB.Add;
2124:
2125: END IF;
2126:
2127: RAISE FND_API.G_EXC_ERROR;
2128:
2129: END IF;
2130:
2131: -- Initialize global variables