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_KANBANCARD_PKG dependencies on INV_KANBAN_PVT

Line 92: RETURN inv_kanban_pvt.kanban_card_rec_type IS

88: RETURN FALSE;
89: END check_unique;
90:
91: FUNCTION query_row(p_kanban_card_id IN NUMBER)
92: RETURN inv_kanban_pvt.kanban_card_rec_type IS
93: l_kanban_card_rec inv_kanban_pvt.kanban_card_rec_type;
94: BEGIN
95:
96: SELECT kanban_card_id

Line 93: l_kanban_card_rec inv_kanban_pvt.kanban_card_rec_type;

89: END check_unique;
90:
91: FUNCTION query_row(p_kanban_card_id IN NUMBER)
92: RETURN inv_kanban_pvt.kanban_card_rec_type IS
93: l_kanban_card_rec inv_kanban_pvt.kanban_card_rec_type;
94: BEGIN
95:
96: SELECT kanban_card_id
97: , kanban_card_number

Line 227: If p_card_status = INV_Kanban_PVT.G_Card_Status_Cancel

223: l_supply_status_from VARCHAR2(30);
224: l_supply_status_to VARCHAR2(30);
225: BEGIN
226: /*
227: If p_card_status = INV_Kanban_PVT.G_Card_Status_Cancel
228: Then
229: FND_MESSAGE.SET_NAME('INV','INV_NO_ACT_ALLOW_CANCEL_CARD');
230: Return False;
231: Elsif p_card_status = INV_Kanban_PVT.G_Card_Status_Hold

Line 231: Elsif p_card_status = INV_Kanban_PVT.G_Card_Status_Hold

227: If p_card_status = INV_Kanban_PVT.G_Card_Status_Cancel
228: Then
229: FND_MESSAGE.SET_NAME('INV','INV_NO_ACT_ALLOW_CANCEL_CARD');
230: Return False;
231: Elsif p_card_status = INV_Kanban_PVT.G_Card_Status_Hold
232: Then
233: FND_MESSAGE.SET_NAME('INV','INV_NO_ACT_ALLOW_HOLD_CARD');
234: Return False;
235: Else

Line 322: FUNCTION changed_row(p_kanban_card_rec inv_kanban_pvt.kanban_card_rec_type, p_old_kanban_card_rec inv_kanban_pvt.kanban_card_rec_type)

318: BEGIN
319: ROLLBACK;
320: END rollback_row;
321:
322: FUNCTION changed_row(p_kanban_card_rec inv_kanban_pvt.kanban_card_rec_type, p_old_kanban_card_rec inv_kanban_pvt.kanban_card_rec_type)
323: RETURN BOOLEAN IS
324: l_dupl_inprocess_act BOOLEAN := ( p_kanban_card_rec.supply_status = p_old_kanban_card_rec.supply_status
325: AND p_kanban_card_rec.supply_status = 5
326: AND p_kanban_card_rec.current_replnsh_cycle_id = p_old_kanban_card_rec.current_replnsh_cycle_id

Line 540: l_kanban_card_rec inv_kanban_pvt.kanban_card_rec_type;

536: , p_program_id NUMBER
537: , p_program_update_date DATE
538: , p_release_kanban_flag NUMBER
539: ) IS
540: l_kanban_card_rec inv_kanban_pvt.kanban_card_rec_type;
541: l_kanban_card_number_ok BOOLEAN := FALSE;
542: l_dummy VARCHAR2(1);
543: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
544: l_current_replnsh_cycle_id NUMBER;

Line 702: , inv_kanban_pvt.g_supply_status_empty, inv_kanban_pvt.g_supply_status_new

698: , l_kanban_card_rec.organization_id
699: , l_kanban_card_rec.subinventory_name
700: , DECODE(
701: l_kanban_card_rec.supply_status
702: , inv_kanban_pvt.g_supply_status_empty, inv_kanban_pvt.g_supply_status_new
703: , l_kanban_card_rec.supply_status
704: )
705: , l_kanban_card_rec.card_status
706: , l_kanban_card_rec.kanban_card_type

Line 748: (l_kanban_card_rec.card_status = inv_kanban_pvt.g_card_status_active)

744: );
745:
746: IF (
747: (
748: (l_kanban_card_rec.card_status = inv_kanban_pvt.g_card_status_active)
749: AND(l_kanban_card_rec.supply_status = inv_kanban_pvt.g_supply_status_empty)
750: AND(p_release_kanban_flag = 1)
751: )
752: OR(p_release_kanban_flag = 2)

Line 749: AND(l_kanban_card_rec.supply_status = inv_kanban_pvt.g_supply_status_empty)

745:
746: IF (
747: (
748: (l_kanban_card_rec.card_status = inv_kanban_pvt.g_card_status_active)
749: AND(l_kanban_card_rec.supply_status = inv_kanban_pvt.g_supply_status_empty)
750: AND(p_release_kanban_flag = 1)
751: )
752: OR(p_release_kanban_flag = 2)
753: ) THEN

Line 1102: l_kanban_card_rec inv_kanban_pvt.kanban_card_rec_type;

1098: , p_max_replenishments NUMBER DEFAULT NULL
1099: , p_disable_date DATE DEFAULT NULL
1100: , p_replacement_flag NUMBER DEFAULT NULL
1101: ) IS
1102: l_kanban_card_rec inv_kanban_pvt.kanban_card_rec_type;
1103: l_old_kanban_card_rec inv_kanban_pvt.kanban_card_rec_type;
1104: l_current_replenish_cycle_id NUMBER;
1105: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1106: l_supply_status NUMBER;

Line 1103: l_old_kanban_card_rec inv_kanban_pvt.kanban_card_rec_type;

1099: , p_disable_date DATE DEFAULT NULL
1100: , p_replacement_flag NUMBER DEFAULT NULL
1101: ) IS
1102: l_kanban_card_rec inv_kanban_pvt.kanban_card_rec_type;
1103: l_old_kanban_card_rec inv_kanban_pvt.kanban_card_rec_type;
1104: l_current_replenish_cycle_id NUMBER;
1105: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1106: l_supply_status NUMBER;
1107: l_consolidation_option NUMBER := null;

Line 1136: IF (l_kanban_card_rec.kanban_card_type = inv_kanban_pvt.g_card_type_nonreplenishable)

1132: END IF;
1133: END IF;
1134: */
1135:
1136: IF (l_kanban_card_rec.kanban_card_type = inv_kanban_pvt.g_card_type_nonreplenishable)
1137: AND(trunc(l_kanban_card_rec.supply_status) = inv_kanban_pvt.g_supply_status_full)
1138: AND(trunc(l_old_kanban_card_rec.supply_status) <> trunc(l_kanban_card_rec.supply_status)) THEN
1139: l_kanban_card_rec.card_status := inv_kanban_pvt.g_card_status_hold;
1140: ELSE

Line 1137: AND(trunc(l_kanban_card_rec.supply_status) = inv_kanban_pvt.g_supply_status_full)

1133: END IF;
1134: */
1135:
1136: IF (l_kanban_card_rec.kanban_card_type = inv_kanban_pvt.g_card_type_nonreplenishable)
1137: AND(trunc(l_kanban_card_rec.supply_status) = inv_kanban_pvt.g_supply_status_full)
1138: AND(trunc(l_old_kanban_card_rec.supply_status) <> trunc(l_kanban_card_rec.supply_status)) THEN
1139: l_kanban_card_rec.card_status := inv_kanban_pvt.g_card_status_hold;
1140: ELSE
1141: l_kanban_card_rec.card_status := p_card_status;

Line 1139: l_kanban_card_rec.card_status := inv_kanban_pvt.g_card_status_hold;

1135:
1136: IF (l_kanban_card_rec.kanban_card_type = inv_kanban_pvt.g_card_type_nonreplenishable)
1137: AND(trunc(l_kanban_card_rec.supply_status) = inv_kanban_pvt.g_supply_status_full)
1138: AND(trunc(l_old_kanban_card_rec.supply_status) <> trunc(l_kanban_card_rec.supply_status)) THEN
1139: l_kanban_card_rec.card_status := inv_kanban_pvt.g_card_status_hold;
1140: ELSE
1141: l_kanban_card_rec.card_status := p_card_status;
1142: END IF;
1143:

Line 1169: IF trunc(p_supply_status) = inv_kanban_pvt.g_supply_status_full THEN

1165: l_kanban_card_rec.disable_date := p_disable_date;
1166: l_kanban_card_rec.replacement_flag := p_replacement_flag;
1167:
1168:
1169: IF trunc(p_supply_status) = inv_kanban_pvt.g_supply_status_full THEN
1170: l_kanban_card_rec.current_replnsh_cycle_id := NULL;
1171: ELSE
1172: l_kanban_card_rec.current_replnsh_cycle_id := p_current_replnsh_cycle_id;
1173: END IF;

Line 1202: IF l_kanban_card_rec.card_status = inv_kanban_pvt.g_card_status_active

1198: l_kanban_card_rec.replenish_quantity := p_replenish_quantity;
1199: l_kanban_card_rec.need_by_date := p_need_by_date;
1200: l_kanban_card_rec.source_wip_entity_id := p_source_wip_entity_id;
1201:
1202: IF l_kanban_card_rec.card_status = inv_kanban_pvt.g_card_status_active
1203: AND trunc(l_kanban_card_rec.supply_status) = inv_kanban_pvt.g_supply_status_empty
1204: AND trunc(l_old_kanban_card_rec.supply_status) <> trunc(l_kanban_card_rec.supply_status)
1205: AND status_check(l_old_kanban_card_rec.supply_status,l_kanban_card_rec.supply_status) = 2 --13683149
1206: THEN

Line 1203: AND trunc(l_kanban_card_rec.supply_status) = inv_kanban_pvt.g_supply_status_empty

1199: l_kanban_card_rec.need_by_date := p_need_by_date;
1200: l_kanban_card_rec.source_wip_entity_id := p_source_wip_entity_id;
1201:
1202: IF l_kanban_card_rec.card_status = inv_kanban_pvt.g_card_status_active
1203: AND trunc(l_kanban_card_rec.supply_status) = inv_kanban_pvt.g_supply_status_empty
1204: AND trunc(l_old_kanban_card_rec.supply_status) <> trunc(l_kanban_card_rec.supply_status)
1205: AND status_check(l_old_kanban_card_rec.supply_status,l_kanban_card_rec.supply_status) = 2 --13683149
1206: THEN
1207: mydebug('calling INV_Kanban_PVT.Check_And_Create_Replenishment');

Line 1207: mydebug('calling INV_Kanban_PVT.Check_And_Create_Replenishment');

1203: AND trunc(l_kanban_card_rec.supply_status) = inv_kanban_pvt.g_supply_status_empty
1204: AND trunc(l_old_kanban_card_rec.supply_status) <> trunc(l_kanban_card_rec.supply_status)
1205: AND status_check(l_old_kanban_card_rec.supply_status,l_kanban_card_rec.supply_status) = 2 --13683149
1206: THEN
1207: mydebug('calling INV_Kanban_PVT.Check_And_Create_Replenishment');
1208:
1209: /* This validation should be done inside check_and_create_replenishment to accomodate consolidation. Bug 12570813.
1210: Begin
1211: select CONSOLIDATION into l_consolidation_option

Line 1219: if nvl(l_consolidation_option,INV_Kanban_PVT.G_consolidate_opt_no) = INV_Kanban_PVT.G_consolidate_opt_yes then

1215: when no_data_found then
1216: null;
1217: end;
1218:
1219: if nvl(l_consolidation_option,INV_Kanban_PVT.G_consolidate_opt_no) = INV_Kanban_PVT.G_consolidate_opt_yes then
1220: l_kanban_card_rec.supply_status := INV_Kanban_PVT.G_Supply_Status_Consolidate;
1221: else */
1222: inv_kanban_pvt.check_and_create_replenishment(
1223: x_return_status => l_return_status

Line 1220: l_kanban_card_rec.supply_status := INV_Kanban_PVT.G_Supply_Status_Consolidate;

1216: null;
1217: end;
1218:
1219: if nvl(l_consolidation_option,INV_Kanban_PVT.G_consolidate_opt_no) = INV_Kanban_PVT.G_consolidate_opt_yes then
1220: l_kanban_card_rec.supply_status := INV_Kanban_PVT.G_Supply_Status_Consolidate;
1221: else */
1222: inv_kanban_pvt.check_and_create_replenishment(
1223: x_return_status => l_return_status
1224: , x_supply_status => l_supply_status

Line 1222: inv_kanban_pvt.check_and_create_replenishment(

1218:
1219: if nvl(l_consolidation_option,INV_Kanban_PVT.G_consolidate_opt_no) = INV_Kanban_PVT.G_consolidate_opt_yes then
1220: l_kanban_card_rec.supply_status := INV_Kanban_PVT.G_Supply_Status_Consolidate;
1221: else */
1222: inv_kanban_pvt.check_and_create_replenishment(
1223: x_return_status => l_return_status
1224: , x_supply_status => l_supply_status
1225: , x_current_replenish_cycle_id => l_current_replenish_cycle_id
1226: , p_kanban_card_rec => l_kanban_card_rec

Line 1240: if l_supply_status not in (INV_Kanban_PVT.G_Supply_Status_Wait,INV_Kanban_PVT.G_Supply_Status_Consolidate) then

1236:
1237: l_kanban_card_rec.supply_status := l_supply_status;
1238: l_kanban_card_rec.current_replnsh_cycle_id := l_current_replenish_cycle_id;
1239: -- Added for Bug 12570813.
1240: if l_supply_status not in (INV_Kanban_PVT.G_Supply_Status_Wait,INV_Kanban_PVT.G_Supply_Status_Consolidate) then
1241: l_kanban_card_rec.replenishment_count := nvl(p_replenishment_count,0)+1;
1242: end if;
1243: -- end if;
1244: END IF;

Line 1301: ELSIF l_kanban_card_rec.document_type = INV_KANBAN_PVT.G_Doc_type_lot_job and

1297:
1298: IF changed_row(l_kanban_card_rec, l_old_kanban_card_rec) THEN
1299: insert_activity_for_card(l_kanban_card_rec);
1300: -- Bug Fix 4361921
1301: ELSIF l_kanban_card_rec.document_type = INV_KANBAN_PVT.G_Doc_type_lot_job and
1302: l_kanban_card_rec.document_header_id <>
1303: nvl( l_old_kanban_card_rec.document_header_id,-9999) and
1304: trunc(l_kanban_card_rec.supply_status) =
1305: INV_KANBAN_PVT.G_Supply_Status_InProcess THEN

Line 1305: INV_KANBAN_PVT.G_Supply_Status_InProcess THEN

1301: ELSIF l_kanban_card_rec.document_type = INV_KANBAN_PVT.G_Doc_type_lot_job and
1302: l_kanban_card_rec.document_header_id <>
1303: nvl( l_old_kanban_card_rec.document_header_id,-9999) and
1304: trunc(l_kanban_card_rec.supply_status) =
1305: INV_KANBAN_PVT.G_Supply_Status_InProcess THEN
1306: -- Bug Fix: 5344450
1307: -- Added the IF condition
1308: IF (p_replenish_quantity IS NULL) THEN
1309:

Line 1317: trunc(supply_status) = INV_KANBAN_PVT.G_Supply_Status_InProcess AND

1313: UPDATE mtl_kanban_card_activity
1314: SET document_header_id = l_kanban_card_rec.document_header_id
1315: WHERE
1316: kanban_card_number = l_kanban_card_rec.kanban_card_number AND
1317: trunc(supply_status) = INV_KANBAN_PVT.G_Supply_Status_InProcess AND
1318: document_type = INV_KANBAN_PVT.G_Doc_type_lot_job AND
1319: replenishment_cycle_id = l_kanban_card_rec.current_replnsh_cycle_id;
1320: ELSE
1321: -- Bug Fix: 5344450

Line 1318: document_type = INV_KANBAN_PVT.G_Doc_type_lot_job AND

1314: SET document_header_id = l_kanban_card_rec.document_header_id
1315: WHERE
1316: kanban_card_number = l_kanban_card_rec.kanban_card_number AND
1317: trunc(supply_status) = INV_KANBAN_PVT.G_Supply_Status_InProcess AND
1318: document_type = INV_KANBAN_PVT.G_Doc_type_lot_job AND
1319: replenishment_cycle_id = l_kanban_card_rec.current_replnsh_cycle_id;
1320: ELSE
1321: -- Bug Fix: 5344450
1322: -- Added new update statement to update the kanban_size with p_replenish_quantity

Line 1330: trunc(supply_status) = INV_KANBAN_PVT.G_Supply_Status_InProcess AND

1326: SET document_header_id = l_kanban_card_rec.document_header_id,
1327: kanban_size = p_replenish_quantity
1328: WHERE
1329: kanban_card_number = l_kanban_card_rec.kanban_card_number AND
1330: trunc(supply_status) = INV_KANBAN_PVT.G_Supply_Status_InProcess AND
1331: document_type = INV_KANBAN_PVT.G_Doc_type_lot_job AND
1332: replenishment_cycle_id = l_kanban_card_rec.current_replnsh_cycle_id;
1333:
1334: END IF;

Line 1331: document_type = INV_KANBAN_PVT.G_Doc_type_lot_job AND

1327: kanban_size = p_replenish_quantity
1328: WHERE
1329: kanban_card_number = l_kanban_card_rec.kanban_card_number AND
1330: trunc(supply_status) = INV_KANBAN_PVT.G_Supply_Status_InProcess AND
1331: document_type = INV_KANBAN_PVT.G_Doc_type_lot_job AND
1332: replenishment_cycle_id = l_kanban_card_rec.current_replnsh_cycle_id;
1333:
1334: END IF;
1335:

Line 1363: PROCEDURE update_row(p_kanban_card_rec inv_kanban_pvt.kanban_card_rec_type) IS

1359:
1360: x_return_status := fnd_api.g_ret_sts_unexp_error;
1361: END update_row;
1362:
1363: PROCEDURE update_row(p_kanban_card_rec inv_kanban_pvt.kanban_card_rec_type) IS
1364: l_return_status VARCHAR2(1);
1365: l_supply_status NUMBER;
1366: l_card_status NUMBER;
1367: l_current_replnsh_cycle_id NUMBER;

Line 1457: PROCEDURE update_card_status(p_kanban_card_rec IN OUT NOCOPY inv_kanban_pvt.kanban_card_rec_type, p_card_status IN NUMBER) IS

1453:
1454: RAISE fnd_api.g_exc_unexpected_error;
1455: END update_row;
1456:
1457: PROCEDURE update_card_status(p_kanban_card_rec IN OUT NOCOPY inv_kanban_pvt.kanban_card_rec_type, p_card_status IN NUMBER) IS
1458: l_return_status VARCHAR2(1);
1459: l_card_status NUMBER;
1460: BEGIN
1461: fnd_msg_pub.initialize;

Line 1557: PROCEDURE insert_activity_for_card(p_kanban_card_rec IN inv_kanban_pvt.kanban_card_rec_type) IS

1553:
1554: x_return_status := fnd_api.g_ret_sts_unexp_error;
1555: END delete_row;
1556:
1557: PROCEDURE insert_activity_for_card(p_kanban_card_rec IN inv_kanban_pvt.kanban_card_rec_type) IS
1558: BEGIN
1559: INSERT INTO mtl_kanban_card_activity
1560: (
1561: kanban_activity_id

Line 1787: l_kanban_card_rec inv_kanban_pvt.kanban_card_rec_type;

1783: , p_max_replenishments NUMBER DEFAULT NULL
1784: , p_disable_date DATE DEFAULT NULL
1785: , p_replacement_flag NUMBER DEFAULT NULL
1786: ) IS
1787: l_kanban_card_rec inv_kanban_pvt.kanban_card_rec_type;
1788: l_kanban_card_number_ok BOOLEAN := FALSE;
1789: l_dummy VARCHAR2(1);
1790: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1791: l_current_replnsh_cycle_id NUMBER;

Line 1970: , inv_kanban_pvt.g_supply_status_empty, inv_kanban_pvt.g_supply_status_new

1966: , l_kanban_card_rec.organization_id
1967: , l_kanban_card_rec.subinventory_name
1968: , DECODE(
1969: trunc(l_kanban_card_rec.supply_status)
1970: , inv_kanban_pvt.g_supply_status_empty, inv_kanban_pvt.g_supply_status_new
1971: , l_kanban_card_rec.supply_status
1972: )
1973: , l_kanban_card_rec.card_status
1974: , l_kanban_card_rec.kanban_card_type

Line 2021: (l_kanban_card_rec.card_status = inv_kanban_pvt.g_card_status_active)

2017: );
2018:
2019: IF (
2020: (
2021: (l_kanban_card_rec.card_status = inv_kanban_pvt.g_card_status_active)
2022: AND(trunc(l_kanban_card_rec.supply_status) = inv_kanban_pvt.g_supply_status_empty)
2023: AND(p_release_kanban_flag = 1)
2024: )
2025: OR(p_release_kanban_flag = 2)

Line 2022: AND(trunc(l_kanban_card_rec.supply_status) = inv_kanban_pvt.g_supply_status_empty)

2018:
2019: IF (
2020: (
2021: (l_kanban_card_rec.card_status = inv_kanban_pvt.g_card_status_active)
2022: AND(trunc(l_kanban_card_rec.supply_status) = inv_kanban_pvt.g_supply_status_empty)
2023: AND(p_release_kanban_flag = 1)
2024: )
2025: OR(p_release_kanban_flag = 2)
2026: ) THEN

Line 2363: l_kanban_card_rec inv_kanban_pvt.kanban_card_rec_type;

2359: , p_replenish_quantity NUMBER DEFAULT NULL
2360: , p_need_by_date DATE DEFAULT NULL
2361: , p_source_wip_entity_id NUMBER DEFAULT NULL
2362: ) IS
2363: l_kanban_card_rec inv_kanban_pvt.kanban_card_rec_type;
2364: l_old_kanban_card_rec inv_kanban_pvt.kanban_card_rec_type;
2365: l_current_replenish_cycle_id NUMBER;
2366: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
2367: l_supply_status NUMBER;

Line 2364: l_old_kanban_card_rec inv_kanban_pvt.kanban_card_rec_type;

2360: , p_need_by_date DATE DEFAULT NULL
2361: , p_source_wip_entity_id NUMBER DEFAULT NULL
2362: ) IS
2363: l_kanban_card_rec inv_kanban_pvt.kanban_card_rec_type;
2364: l_old_kanban_card_rec inv_kanban_pvt.kanban_card_rec_type;
2365: l_current_replenish_cycle_id NUMBER;
2366: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
2367: l_supply_status NUMBER;
2368: BEGIN

Line 2381: IF (l_kanban_card_rec.kanban_card_type = inv_kanban_pvt.g_card_type_nonreplenishable)

2377: l_kanban_card_rec.subinventory_name := p_subinventory_name;
2378: l_kanban_card_rec.kanban_card_type := p_kanban_card_type;
2379: l_kanban_card_rec.supply_status := p_supply_status;
2380:
2381: IF (l_kanban_card_rec.kanban_card_type = inv_kanban_pvt.g_card_type_nonreplenishable)
2382: AND(l_kanban_card_rec.supply_status = inv_kanban_pvt.g_supply_status_full)
2383: AND(l_old_kanban_card_rec.supply_status <> l_kanban_card_rec.supply_status) THEN
2384: l_kanban_card_rec.card_status := inv_kanban_pvt.g_card_status_hold;
2385: ELSE

Line 2382: AND(l_kanban_card_rec.supply_status = inv_kanban_pvt.g_supply_status_full)

2378: l_kanban_card_rec.kanban_card_type := p_kanban_card_type;
2379: l_kanban_card_rec.supply_status := p_supply_status;
2380:
2381: IF (l_kanban_card_rec.kanban_card_type = inv_kanban_pvt.g_card_type_nonreplenishable)
2382: AND(l_kanban_card_rec.supply_status = inv_kanban_pvt.g_supply_status_full)
2383: AND(l_old_kanban_card_rec.supply_status <> l_kanban_card_rec.supply_status) THEN
2384: l_kanban_card_rec.card_status := inv_kanban_pvt.g_card_status_hold;
2385: ELSE
2386: l_kanban_card_rec.card_status := p_card_status;

Line 2384: l_kanban_card_rec.card_status := inv_kanban_pvt.g_card_status_hold;

2380:
2381: IF (l_kanban_card_rec.kanban_card_type = inv_kanban_pvt.g_card_type_nonreplenishable)
2382: AND(l_kanban_card_rec.supply_status = inv_kanban_pvt.g_supply_status_full)
2383: AND(l_old_kanban_card_rec.supply_status <> l_kanban_card_rec.supply_status) THEN
2384: l_kanban_card_rec.card_status := inv_kanban_pvt.g_card_status_hold;
2385: ELSE
2386: l_kanban_card_rec.card_status := p_card_status;
2387: END IF;
2388:

Line 2408: IF p_supply_status = inv_kanban_pvt.g_supply_status_full THEN

2404: l_kanban_card_rec.document_type := p_document_type;
2405: l_kanban_card_rec.document_header_id := p_document_header_id;
2406: l_kanban_card_rec.document_detail_id := p_document_detail_id;
2407:
2408: IF p_supply_status = inv_kanban_pvt.g_supply_status_full THEN
2409: l_kanban_card_rec.current_replnsh_cycle_id := NULL;
2410: ELSE
2411: l_kanban_card_rec.current_replnsh_cycle_id := p_current_replnsh_cycle_id;
2412: END IF;

Line 2441: IF l_kanban_card_rec.card_status = inv_kanban_pvt.g_card_status_active

2437: l_kanban_card_rec.replenish_quantity := p_replenish_quantity;
2438: l_kanban_card_rec.need_by_date := p_need_by_date;
2439: l_kanban_card_rec.source_wip_entity_id := p_source_wip_entity_id;
2440:
2441: IF l_kanban_card_rec.card_status = inv_kanban_pvt.g_card_status_active
2442: AND l_kanban_card_rec.supply_status = inv_kanban_pvt.g_supply_status_empty
2443: AND l_old_kanban_card_rec.supply_status <> l_kanban_card_rec.supply_status THEN
2444: mydebug('calling INV_Kanban_PVT.Check_And_Create_Replenishment');
2445: inv_kanban_pvt.check_and_create_replenishment(

Line 2442: AND l_kanban_card_rec.supply_status = inv_kanban_pvt.g_supply_status_empty

2438: l_kanban_card_rec.need_by_date := p_need_by_date;
2439: l_kanban_card_rec.source_wip_entity_id := p_source_wip_entity_id;
2440:
2441: IF l_kanban_card_rec.card_status = inv_kanban_pvt.g_card_status_active
2442: AND l_kanban_card_rec.supply_status = inv_kanban_pvt.g_supply_status_empty
2443: AND l_old_kanban_card_rec.supply_status <> l_kanban_card_rec.supply_status THEN
2444: mydebug('calling INV_Kanban_PVT.Check_And_Create_Replenishment');
2445: inv_kanban_pvt.check_and_create_replenishment(
2446: x_return_status => l_return_status

Line 2444: mydebug('calling INV_Kanban_PVT.Check_And_Create_Replenishment');

2440:
2441: IF l_kanban_card_rec.card_status = inv_kanban_pvt.g_card_status_active
2442: AND l_kanban_card_rec.supply_status = inv_kanban_pvt.g_supply_status_empty
2443: AND l_old_kanban_card_rec.supply_status <> l_kanban_card_rec.supply_status THEN
2444: mydebug('calling INV_Kanban_PVT.Check_And_Create_Replenishment');
2445: inv_kanban_pvt.check_and_create_replenishment(
2446: x_return_status => l_return_status
2447: , x_supply_status => l_supply_status
2448: , x_current_replenish_cycle_id => l_current_replenish_cycle_id

Line 2445: inv_kanban_pvt.check_and_create_replenishment(

2441: IF l_kanban_card_rec.card_status = inv_kanban_pvt.g_card_status_active
2442: AND l_kanban_card_rec.supply_status = inv_kanban_pvt.g_supply_status_empty
2443: AND l_old_kanban_card_rec.supply_status <> l_kanban_card_rec.supply_status THEN
2444: mydebug('calling INV_Kanban_PVT.Check_And_Create_Replenishment');
2445: inv_kanban_pvt.check_and_create_replenishment(
2446: x_return_status => l_return_status
2447: , x_supply_status => l_supply_status
2448: , x_current_replenish_cycle_id => l_current_replenish_cycle_id
2449: , p_kanban_card_rec => l_kanban_card_rec

Line 2514: ELSIF l_kanban_card_rec.document_type = INV_KANBAN_PVT.G_Doc_type_lot_job and

2510:
2511: IF changed_row(l_kanban_card_rec, l_old_kanban_card_rec) THEN
2512: insert_activity_for_card(l_kanban_card_rec);
2513: -- Bug Fix 4361921
2514: ELSIF l_kanban_card_rec.document_type = INV_KANBAN_PVT.G_Doc_type_lot_job and
2515: l_kanban_card_rec.document_header_id <>
2516: nvl( l_old_kanban_card_rec.document_header_id,-9999) and
2517: l_kanban_card_rec.supply_status =
2518: INV_KANBAN_PVT.G_Supply_Status_InProcess THEN

Line 2518: INV_KANBAN_PVT.G_Supply_Status_InProcess THEN

2514: ELSIF l_kanban_card_rec.document_type = INV_KANBAN_PVT.G_Doc_type_lot_job and
2515: l_kanban_card_rec.document_header_id <>
2516: nvl( l_old_kanban_card_rec.document_header_id,-9999) and
2517: l_kanban_card_rec.supply_status =
2518: INV_KANBAN_PVT.G_Supply_Status_InProcess THEN
2519: -- Bug Fix: 5344450
2520: -- Added the IF condition
2521: IF (p_replenish_quantity IS NULL) THEN
2522:

Line 2530: supply_status = INV_KANBAN_PVT.G_Supply_Status_InProcess AND

2526: UPDATE mtl_kanban_card_activity
2527: SET document_header_id = l_kanban_card_rec.document_header_id
2528: WHERE
2529: kanban_card_number = l_kanban_card_rec.kanban_card_number AND
2530: supply_status = INV_KANBAN_PVT.G_Supply_Status_InProcess AND
2531: document_type = INV_KANBAN_PVT.G_Doc_type_lot_job AND
2532: replenishment_cycle_id = l_kanban_card_rec.current_replnsh_cycle_id;
2533: ELSE
2534: -- Bug Fix: 5344450

Line 2531: document_type = INV_KANBAN_PVT.G_Doc_type_lot_job AND

2527: SET document_header_id = l_kanban_card_rec.document_header_id
2528: WHERE
2529: kanban_card_number = l_kanban_card_rec.kanban_card_number AND
2530: supply_status = INV_KANBAN_PVT.G_Supply_Status_InProcess AND
2531: document_type = INV_KANBAN_PVT.G_Doc_type_lot_job AND
2532: replenishment_cycle_id = l_kanban_card_rec.current_replnsh_cycle_id;
2533: ELSE
2534: -- Bug Fix: 5344450
2535: -- Added new update statement to update the kanban_size with p_replenish_quantity

Line 2543: supply_status = INV_KANBAN_PVT.G_Supply_Status_InProcess AND

2539: SET document_header_id = l_kanban_card_rec.document_header_id,
2540: kanban_size = p_replenish_quantity
2541: WHERE
2542: kanban_card_number = l_kanban_card_rec.kanban_card_number AND
2543: supply_status = INV_KANBAN_PVT.G_Supply_Status_InProcess AND
2544: document_type = INV_KANBAN_PVT.G_Doc_type_lot_job AND
2545: replenishment_cycle_id = l_kanban_card_rec.current_replnsh_cycle_id;
2546:
2547: END IF;

Line 2544: document_type = INV_KANBAN_PVT.G_Doc_type_lot_job AND

2540: kanban_size = p_replenish_quantity
2541: WHERE
2542: kanban_card_number = l_kanban_card_rec.kanban_card_number AND
2543: supply_status = INV_KANBAN_PVT.G_Supply_Status_InProcess AND
2544: document_type = INV_KANBAN_PVT.G_Doc_type_lot_job AND
2545: replenishment_cycle_id = l_kanban_card_rec.current_replnsh_cycle_id;
2546:
2547: END IF;
2548: