eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_RULE_GEN_PVT dependencies on INV_RULE_GEN_PVT

Line 1: PACKAGE BODY inv_rule_gen_pvt AS

1: PACKAGE BODY inv_rule_gen_pvt AS
2: /* $Header: INVRLGNB.pls 120.4 2006/09/26 17:30:48 lgao noship $ */
3: --
4: -- File : INVRLGNB.pls
5: -- Content : INV_RULE_GEN_PVT

Line 5: -- Content : INV_RULE_GEN_PVT

1: PACKAGE BODY inv_rule_gen_pvt AS
2: /* $Header: INVRLGNB.pls 120.4 2006/09/26 17:30:48 lgao noship $ */
3: --
4: -- File : INVRLGNB.pls
5: -- Content : INV_RULE_GEN_PVT
6: -- Description : wms rules engine private API's
7: -- Notes :
8: -- Modified : 08/30/04 ckuenzel created orginal file in inventory
9: --

Line 12: G_PKG_NAME CONSTANT VARCHAR2(30):='INV_RULE_GEN_PVT';

8: -- Modified : 08/30/04 ckuenzel created orginal file in inventory
9: --
10:
11: /* Global variables */
12: G_PKG_NAME CONSTANT VARCHAR2(30):='INV_RULE_GEN_PVT';
13: /* Save procedure will save the record to the following
14: Mtl_picking_rules
15: Wms_rules_b
16: Wms_rules_tl

Line 32: (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec

28: END debug;
29:
30:
31: PROCEDURE Save
32: (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec
33: , x_return_status OUT NOCOPY VARCHAR2
34: , x_msg_data OUT NOCOPY VARCHAR2
35: , x_msg_count OUT NOCOPY NUMBER
36: ) IS

Line 72: inv_rule_gen_pvt.Restrictions_insert

68: );
69:
70:
71: If l_is_new_rec = 1 then
72: inv_rule_gen_pvt.Restrictions_insert
73: (p_mtl_picking_rule_rec=> p_mtl_picking_rule_rec
74: , x_return_status => x_return_status
75: , x_msg_data => x_msg_data
76: , x_msg_count => x_msg_count

Line 78: inv_rule_gen_pvt.consistency_insert

74: , x_return_status => x_return_status
75: , x_msg_data => x_msg_data
76: , x_msg_count => x_msg_count
77: );
78: inv_rule_gen_pvt.consistency_insert
79: (p_mtl_picking_rule_rec=> p_mtl_picking_rule_rec
80: , x_return_status => x_return_status
81: , x_msg_data => x_msg_data
82: , x_msg_count => x_msg_count

Line 84: inv_rule_gen_pvt.sorting_criteria_insert

80: , x_return_status => x_return_status
81: , x_msg_data => x_msg_data
82: , x_msg_count => x_msg_count
83: );
84: inv_rule_gen_pvt.sorting_criteria_insert
85: (p_mtl_picking_rule_rec=> p_mtl_picking_rule_rec
86: , x_return_status => x_return_status
87: , x_msg_data => x_msg_data
88: , x_msg_count => x_msg_count

Line 91: inv_rule_gen_pvt.restrictions_update

87: , x_msg_data => x_msg_data
88: , x_msg_count => x_msg_count
89: );
90: Else
91: inv_rule_gen_pvt.restrictions_update
92: (p_mtl_picking_rule_rec=> p_mtl_picking_rule_rec
93: , x_return_status => x_return_status
94: , x_msg_data => x_msg_data
95: , x_msg_count => x_msg_count

Line 97: inv_rule_gen_pvt.consistency_update

93: , x_return_status => x_return_status
94: , x_msg_data => x_msg_data
95: , x_msg_count => x_msg_count
96: );
97: inv_rule_gen_pvt.consistency_update
98: (p_mtl_picking_rule_rec=> p_mtl_picking_rule_rec
99: , x_return_status => x_return_status
100: , x_msg_data => x_msg_data
101: , x_msg_count => x_msg_count

Line 104: inv_rule_gen_pvt.sorting_criteria_update

100: , x_msg_data => x_msg_data
101: , x_msg_count => x_msg_count
102: );
103:
104: inv_rule_gen_pvt.sorting_criteria_update
105: (p_mtl_picking_rule_rec=> p_mtl_picking_rule_rec
106: , x_return_status => x_return_status
107: , x_msg_data => x_msg_data
108: , x_msg_count => x_msg_count

Line 133: (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec

129: );
130: END save;
131:
132: PROCEDURE Save_to_mtl_picking_rules
133: (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec
134: , x_return_status OUT NOCOPY VARCHAR2
135: , x_msg_data OUT NOCOPY VARCHAR2
136: , x_msg_count OUT NOCOPY NUMBER)
137: IS

Line 248: (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec

244: );
245: END save_to_mtl_picking_rules;
246:
247: PROCEDURE Save_to_wms_rule
248: (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec
249: , x_return_status OUT NOCOPY VARCHAR2
250: , x_msg_data OUT NOCOPY VARCHAR2
251: , x_msg_count OUT NOCOPY NUMBER
252: ) IS

Line 254: l_picking_rule_rec INV_RULE_GEN_PVT.picking_rule_rec;

250: , x_msg_data OUT NOCOPY VARCHAR2
251: , x_msg_count OUT NOCOPY NUMBER
252: ) IS
253: l_api_name CONSTANT VARCHAR2 (30) := 'Save_to_wms_rule';
254: l_picking_rule_rec INV_RULE_GEN_PVT.picking_rule_rec;
255: l_wms_rule_id NUMBER;
256: l_row_id VARCHAR2(500);
257: l_organization_id NUMBER;
258: l_allocation_mode_id NUMBER;

Line 381: (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec

377: );
378: END save_to_wms_rule;
379:
380: PROCEDURE Restrictions_insert
381: (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec
382: , x_return_status OUT NOCOPY VARCHAR2
383: , x_msg_data OUT NOCOPY VARCHAR2
384: , x_msg_count OUT NOCOPY NUMBER)
385: IS

Line 388: l_picking_rule_rec INV_RULE_GEN_PVT.picking_rule_rec;

384: , x_msg_count OUT NOCOPY NUMBER)
385: IS
386:
387: l_api_name CONSTANT VARCHAR2 (30) := 'Restrictions_insert';
388: l_picking_rule_rec INV_RULE_GEN_PVT.picking_rule_rec;
389: l_parameter_id NUMBER;
390: l_Row_Id VARCHAR2(500) ;
391: l_Sequence_Number NUMBER;
392: l_shelf_days NUMBER;

Line 674: (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec

670: * 1) delete the current rows for the rule_id
671: * 2) insert the new rows for the current p_mtl_picking_rule_rec
672: */
673: PROCEDURE Restrictions_update
674: (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec
675: , x_return_status OUT NOCOPY VARCHAR2
676: , x_msg_data OUT NOCOPY VARCHAR2
677: , x_msg_count OUT NOCOPY NUMBER)
678: IS

Line 682: inv_rule_gen_pvt.Restrictions_delete

678: IS
679: l_api_name CONSTANT VARCHAR2 (30) := 'Restrictions_Update';
680: Begin
681: x_return_status := FND_API.G_RET_STS_SUCCESS;
682: inv_rule_gen_pvt.Restrictions_delete
683: (p_mtl_picking_rule_rec=> p_mtl_picking_rule_rec
684: , x_return_status => x_return_status
685: , x_msg_data => x_msg_data
686: , x_msg_count => x_msg_count

Line 688: inv_rule_gen_pvt.Restrictions_insert

684: , x_return_status => x_return_status
685: , x_msg_data => x_msg_data
686: , x_msg_count => x_msg_count
687: );
688: inv_rule_gen_pvt.Restrictions_insert
689: (p_mtl_picking_rule_rec=> p_mtl_picking_rule_rec
690: , x_return_status => x_return_status
691: , x_msg_data => x_msg_data
692: , x_msg_count => x_msg_count

Line 715: (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec

711: );
712: END restrictions_update;
713:
714: PROCEDURE Restrictions_delete
715: (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec
716: , x_return_status OUT NOCOPY VARCHAR2
717: , x_msg_data OUT NOCOPY VARCHAR2
718: , x_msg_count OUT NOCOPY NUMBER)
719: IS

Line 745: (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec

741: );
742: END restrictions_delete;
743:
744: PROCEDURE consistency_insert
745: (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec
746: , x_return_status OUT NOCOPY VARCHAR2
747: , x_msg_data OUT NOCOPY VARCHAR2
748: , x_msg_count OUT NOCOPY NUMBER
749: )

Line 752: l_picking_rule_rec INV_RULE_GEN_PVT.picking_rule_rec;

748: , x_msg_count OUT NOCOPY NUMBER
749: )
750: IS
751: l_api_name CONSTANT VARCHAR2 (30) := 'consistency_insert';
752: l_picking_rule_rec INV_RULE_GEN_PVT.picking_rule_rec;
753: l_consistency_id NUMBER;
754: l_row_id VARCHAR2(500);
755: l_parameter_id NUMBER;
756: Begin

Line 814: (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec

810: );
811: END consistency_insert;
812:
813: PROCEDURE Consistency_update
814: (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec
815: , x_return_status OUT NOCOPY VARCHAR2
816: , x_msg_data OUT NOCOPY VARCHAR2
817: , x_msg_count OUT NOCOPY NUMBER
818: )

Line 823: inv_rule_gen_pvt.consistency_delete

819: IS
820: l_api_name CONSTANT VARCHAR2 (30) := 'Consistency_Update';
821: Begin
822: x_return_status := FND_API.G_RET_STS_SUCCESS;
823: inv_rule_gen_pvt.consistency_delete
824: (p_mtl_picking_rule_rec=> p_mtl_picking_rule_rec
825: , x_return_status => x_return_status
826: , x_msg_data => x_msg_data
827: , x_msg_count => x_msg_count

Line 829: inv_rule_gen_pvt.consistency_insert

825: , x_return_status => x_return_status
826: , x_msg_data => x_msg_data
827: , x_msg_count => x_msg_count
828: );
829: inv_rule_gen_pvt.consistency_insert
830: (p_mtl_picking_rule_rec=> p_mtl_picking_rule_rec
831: , x_return_status => x_return_status
832: , x_msg_data => x_msg_data
833: , x_msg_count => x_msg_count

Line 856: (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec

852: );
853: END consistency_update;
854:
855: PROCEDURE Consistency_delete
856: (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec
857: , x_return_status OUT NOCOPY VARCHAR2
858: , x_msg_data OUT NOCOPY VARCHAR2
859: , x_msg_count OUT NOCOPY NUMBER
860: )

Line 887: (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec

883: );
884: END consistency_delete;
885:
886: PROCEDURE Sorting_criteria_insert
887: (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec
888: , x_return_status OUT NOCOPY VARCHAR2
889: , x_msg_data OUT NOCOPY VARCHAR2
890: , x_msg_count OUT NOCOPY NUMBER)
891: IS

Line 1052: (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec

1048: * 2) Insert new rows for the current setup
1049: */
1050:
1051: PROCEDURE sorting_criteria_update
1052: (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec
1053: , x_return_status OUT NOCOPY VARCHAR2
1054: , x_msg_data OUT NOCOPY VARCHAR2
1055: , x_msg_count OUT NOCOPY NUMBER)
1056: IS

Line 1060: inv_rule_gen_pvt.sorting_criteria_delete

1056: IS
1057: l_api_name CONSTANT VARCHAR2 (30) := 'Sorting_criteria_Update';
1058: Begin
1059: x_return_status := FND_API.G_RET_STS_SUCCESS;
1060: inv_rule_gen_pvt.sorting_criteria_delete
1061: (p_mtl_picking_rule_rec=> p_mtl_picking_rule_rec
1062: , x_return_status => x_return_status
1063: , x_msg_data => x_msg_data
1064: , x_msg_count => x_msg_count

Line 1066: inv_rule_gen_pvt.sorting_criteria_insert

1062: , x_return_status => x_return_status
1063: , x_msg_data => x_msg_data
1064: , x_msg_count => x_msg_count
1065: );
1066: inv_rule_gen_pvt.sorting_criteria_insert
1067: (p_mtl_picking_rule_rec=> p_mtl_picking_rule_rec
1068: , x_return_status => x_return_status
1069: , x_msg_data => x_msg_data
1070: , x_msg_count => x_msg_count

Line 1093: (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec

1089: );
1090: END sorting_criteria_update;
1091:
1092: PROCEDURE Sorting_criteria_delete
1093: (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec
1094: , x_return_status OUT NOCOPY VARCHAR2
1095: , x_msg_data OUT NOCOPY VARCHAR2
1096: , x_msg_count OUT NOCOPY NUMBER)
1097: IS

Line 1124: (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec

1120: );
1121: END sorting_criteria_delete;
1122:
1123: PROCEDURE Strategy_insert
1124: (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec
1125: , x_return_status OUT NOCOPY VARCHAR2
1126: , x_msg_data OUT NOCOPY VARCHAR2
1127: , x_msg_count OUT NOCOPY NUMBER
1128: )

Line 1238: (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec

1234:
1235: /* Only enabled flag can be updated. */
1236: /* disable the strategy when rule is disabled */
1237: PROCEDURE Strategy_update
1238: (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec
1239: , x_return_status OUT NOCOPY VARCHAR2
1240: , x_msg_data OUT NOCOPY VARCHAR2
1241: , x_msg_count OUT NOCOPY NUMBER
1242: )

Line 1299: (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec

1295: END;
1296:
1297: /* when rule is deleted, strategy is also deleted */
1298: PROCEDURE Strategy_delete
1299: (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec
1300: , x_return_status OUT NOCOPY VARCHAR2
1301: , x_msg_data OUT NOCOPY VARCHAR2
1302: , x_msg_count OUT NOCOPY NUMBER
1303: )

Line 1330: (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec

1326: );
1327: END;
1328:
1329: PROCEDURE Rule_Enabled_Flag
1330: (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec
1331: , x_return_status OUT NOCOPY VARCHAR2
1332: , x_msg_data OUT NOCOPY VARCHAR2
1333: , x_msg_count OUT NOCOPY NUMBER)
1334: IS

Line 1336: l_picking_rule_rec INV_RULE_GEN_PVT.picking_rule_rec;

1332: , x_msg_data OUT NOCOPY VARCHAR2
1333: , x_msg_count OUT NOCOPY NUMBER)
1334: IS
1335: l_api_name CONSTANT VARCHAR2 (30) := 'Strategy_Delete';
1336: l_picking_rule_rec INV_RULE_GEN_PVT.picking_rule_rec;
1337: l_return_status VARCHAR2(1);
1338: l_msg_data VARCHAR2(2000);
1339: l_msg_count NUMBER;
1340: v_type_code number;

Line 1384: inv_rule_gen_pvt.Strategy_insert

1380: ,p_pkg_type => 'B'
1381: );
1382:
1383: /* if l_picking_rule_rec.wms_strategy_id is null THEN
1384: inv_rule_gen_pvt.Strategy_insert
1385: (p_mtl_picking_rule_rec=> p_mtl_picking_rule_rec
1386: , x_return_status => x_return_status
1387: , x_msg_data => x_msg_data
1388: , x_msg_count => x_msg_count

Line 1391: inv_rule_gen_pvt.Strategy_Update

1387: , x_msg_data => x_msg_data
1388: , x_msg_count => x_msg_count
1389: );
1390: Else
1391: inv_rule_gen_pvt.Strategy_Update
1392: (p_mtl_picking_rule_rec=> p_mtl_picking_rule_rec
1393: , x_return_status => x_return_status
1394: , x_msg_data => x_msg_data
1395: , x_msg_count => x_msg_count

Line 1409: inv_rule_gen_pvt.Strategy_Update

1405: ELSE -- disable the flag
1406: l_picking_rule_rec.enabled_flag:='N';
1407: debug('disabling the rule and strategy');
1408: /*
1409: inv_rule_gen_pvt.Strategy_Update
1410: (p_mtl_picking_rule_rec=> p_mtl_picking_rule_rec
1411: , x_return_status => x_return_status
1412: , x_msg_data => x_msg_data
1413: , x_msg_count => x_msg_count

Line 1443: (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec

1439: );
1440: END Rule_Enabled_Flag;
1441:
1442: FUNCTION rule_assigned_to_strategy
1443: (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec
1444: , x_return_status OUT NOCOPY VARCHAR2
1445: , x_msg_data OUT NOCOPY VARCHAR2
1446: , x_msg_count OUT NOCOPY NUMBER)
1447: RETURN BOOLEAN IS

Line 1546: (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec

1542: );
1543: END rule_assigned_to_strategy;
1544:
1545: PROCEDURE GenerateRulePKG
1546: (p_mtl_picking_rule_rec IN OUT NOCOPY INV_RULE_GEN_PVT.picking_rule_rec
1547: , x_return_status OUT NOCOPY VARCHAR2
1548: , x_msg_data OUT NOCOPY VARCHAR2
1549: , x_msg_count OUT NOCOPY NUMBER)
1550: IS

Line 1600: END inv_rule_gen_pvt;

1596: , p_data => x_msg_data
1597: );
1598: END GenerateRulePKG;
1599:
1600: END inv_rule_gen_pvt;