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: SELECT kanban_card_id
96: , kanban_card_number

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: SELECT kanban_card_id
96: , kanban_card_number
97: , pull_sequence_id

Line 216: If p_card_status = INV_Kanban_PVT.G_Card_Status_Cancel

212: l_supply_status_from VARCHAR2(30);
213: l_supply_status_to VARCHAR2(30);
214: BEGIN
215: /*
216: If p_card_status = INV_Kanban_PVT.G_Card_Status_Cancel
217: Then
218: FND_MESSAGE.SET_NAME('INV','INV_NO_ACT_ALLOW_CANCEL_CARD');
219: Return False;
220: Elsif p_card_status = INV_Kanban_PVT.G_Card_Status_Hold

Line 220: Elsif p_card_status = INV_Kanban_PVT.G_Card_Status_Hold

216: If p_card_status = INV_Kanban_PVT.G_Card_Status_Cancel
217: Then
218: FND_MESSAGE.SET_NAME('INV','INV_NO_ACT_ALLOW_CANCEL_CARD');
219: Return False;
220: Elsif p_card_status = INV_Kanban_PVT.G_Card_Status_Hold
221: Then
222: FND_MESSAGE.SET_NAME('INV','INV_NO_ACT_ALLOW_HOLD_CARD');
223: Return False;
224: Else

Line 265: 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)

261: BEGIN
262: ROLLBACK;
263: END rollback_row;
264:
265: 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)
266: RETURN BOOLEAN IS
267: l_dupl_inprocess_act BOOLEAN := ( p_kanban_card_rec.supply_status = p_old_kanban_card_rec.supply_status
268: AND p_kanban_card_rec.supply_status = 5
269: AND p_kanban_card_rec.current_replnsh_cycle_id = p_old_kanban_card_rec.current_replnsh_cycle_id

Line 483: l_kanban_card_rec inv_kanban_pvt.kanban_card_rec_type;

479: , p_program_id NUMBER
480: , p_program_update_date DATE
481: , p_release_kanban_flag NUMBER
482: ) IS
483: l_kanban_card_rec inv_kanban_pvt.kanban_card_rec_type;
484: l_kanban_card_number_ok BOOLEAN := FALSE;
485: l_dummy VARCHAR2(1);
486: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
487: l_current_replnsh_cycle_id NUMBER;

Line 626: , inv_kanban_pvt.g_supply_status_empty, inv_kanban_pvt.g_supply_status_new

622: , l_kanban_card_rec.organization_id
623: , l_kanban_card_rec.subinventory_name
624: , DECODE(
625: l_kanban_card_rec.supply_status
626: , inv_kanban_pvt.g_supply_status_empty, inv_kanban_pvt.g_supply_status_new
627: , l_kanban_card_rec.supply_status
628: )
629: , l_kanban_card_rec.card_status
630: , l_kanban_card_rec.kanban_card_type

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

668: );
669:
670: IF (
671: (
672: (l_kanban_card_rec.card_status = inv_kanban_pvt.g_card_status_active)
673: AND(l_kanban_card_rec.supply_status = inv_kanban_pvt.g_supply_status_empty)
674: AND(p_release_kanban_flag = 1)
675: )
676: OR(p_release_kanban_flag = 2)

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

669:
670: IF (
671: (
672: (l_kanban_card_rec.card_status = inv_kanban_pvt.g_card_status_active)
673: AND(l_kanban_card_rec.supply_status = inv_kanban_pvt.g_supply_status_empty)
674: AND(p_release_kanban_flag = 1)
675: )
676: OR(p_release_kanban_flag = 2)
677: ) THEN

Line 985: l_kanban_card_rec inv_kanban_pvt.kanban_card_rec_type;

981: , p_replenish_quantity NUMBER DEFAULT NULL
982: , p_need_by_date DATE DEFAULT NULL
983: , p_source_wip_entity_id NUMBER DEFAULT NULL
984: ) IS
985: l_kanban_card_rec inv_kanban_pvt.kanban_card_rec_type;
986: l_old_kanban_card_rec inv_kanban_pvt.kanban_card_rec_type;
987: l_current_replenish_cycle_id NUMBER;
988: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
989: l_supply_status NUMBER;

Line 986: l_old_kanban_card_rec inv_kanban_pvt.kanban_card_rec_type;

982: , p_need_by_date DATE DEFAULT NULL
983: , p_source_wip_entity_id NUMBER DEFAULT NULL
984: ) IS
985: l_kanban_card_rec inv_kanban_pvt.kanban_card_rec_type;
986: l_old_kanban_card_rec inv_kanban_pvt.kanban_card_rec_type;
987: l_current_replenish_cycle_id NUMBER;
988: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
989: l_supply_status NUMBER;
990: BEGIN

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

999: l_kanban_card_rec.subinventory_name := p_subinventory_name;
1000: l_kanban_card_rec.kanban_card_type := p_kanban_card_type;
1001: l_kanban_card_rec.supply_status := p_supply_status;
1002:
1003: IF (l_kanban_card_rec.kanban_card_type = inv_kanban_pvt.g_card_type_nonreplenishable)
1004: AND(l_kanban_card_rec.supply_status = inv_kanban_pvt.g_supply_status_full)
1005: AND(l_old_kanban_card_rec.supply_status <> l_kanban_card_rec.supply_status) THEN
1006: l_kanban_card_rec.card_status := inv_kanban_pvt.g_card_status_hold;
1007: ELSE

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

1000: l_kanban_card_rec.kanban_card_type := p_kanban_card_type;
1001: l_kanban_card_rec.supply_status := p_supply_status;
1002:
1003: IF (l_kanban_card_rec.kanban_card_type = inv_kanban_pvt.g_card_type_nonreplenishable)
1004: AND(l_kanban_card_rec.supply_status = inv_kanban_pvt.g_supply_status_full)
1005: AND(l_old_kanban_card_rec.supply_status <> l_kanban_card_rec.supply_status) THEN
1006: l_kanban_card_rec.card_status := inv_kanban_pvt.g_card_status_hold;
1007: ELSE
1008: l_kanban_card_rec.card_status := p_card_status;

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

1002:
1003: IF (l_kanban_card_rec.kanban_card_type = inv_kanban_pvt.g_card_type_nonreplenishable)
1004: AND(l_kanban_card_rec.supply_status = inv_kanban_pvt.g_supply_status_full)
1005: AND(l_old_kanban_card_rec.supply_status <> l_kanban_card_rec.supply_status) THEN
1006: l_kanban_card_rec.card_status := inv_kanban_pvt.g_card_status_hold;
1007: ELSE
1008: l_kanban_card_rec.card_status := p_card_status;
1009: END IF;
1010:

Line 1030: IF p_supply_status = inv_kanban_pvt.g_supply_status_full THEN

1026: l_kanban_card_rec.document_type := p_document_type;
1027: l_kanban_card_rec.document_header_id := p_document_header_id;
1028: l_kanban_card_rec.document_detail_id := p_document_detail_id;
1029:
1030: IF p_supply_status = inv_kanban_pvt.g_supply_status_full THEN
1031: l_kanban_card_rec.current_replnsh_cycle_id := NULL;
1032: ELSE
1033: l_kanban_card_rec.current_replnsh_cycle_id := p_current_replnsh_cycle_id;
1034: END IF;

Line 1063: IF l_kanban_card_rec.card_status = inv_kanban_pvt.g_card_status_active

1059: l_kanban_card_rec.replenish_quantity := p_replenish_quantity;
1060: l_kanban_card_rec.need_by_date := p_need_by_date;
1061: l_kanban_card_rec.source_wip_entity_id := p_source_wip_entity_id;
1062:
1063: IF l_kanban_card_rec.card_status = inv_kanban_pvt.g_card_status_active
1064: AND l_kanban_card_rec.supply_status = inv_kanban_pvt.g_supply_status_empty
1065: AND l_old_kanban_card_rec.supply_status <> l_kanban_card_rec.supply_status THEN
1066: mydebug('calling INV_Kanban_PVT.Check_And_Create_Replenishment');
1067: inv_kanban_pvt.check_and_create_replenishment(

Line 1064: AND l_kanban_card_rec.supply_status = inv_kanban_pvt.g_supply_status_empty

1060: l_kanban_card_rec.need_by_date := p_need_by_date;
1061: l_kanban_card_rec.source_wip_entity_id := p_source_wip_entity_id;
1062:
1063: IF l_kanban_card_rec.card_status = inv_kanban_pvt.g_card_status_active
1064: AND l_kanban_card_rec.supply_status = inv_kanban_pvt.g_supply_status_empty
1065: AND l_old_kanban_card_rec.supply_status <> l_kanban_card_rec.supply_status THEN
1066: mydebug('calling INV_Kanban_PVT.Check_And_Create_Replenishment');
1067: inv_kanban_pvt.check_and_create_replenishment(
1068: x_return_status => l_return_status

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

1062:
1063: IF l_kanban_card_rec.card_status = inv_kanban_pvt.g_card_status_active
1064: AND l_kanban_card_rec.supply_status = inv_kanban_pvt.g_supply_status_empty
1065: AND l_old_kanban_card_rec.supply_status <> l_kanban_card_rec.supply_status THEN
1066: mydebug('calling INV_Kanban_PVT.Check_And_Create_Replenishment');
1067: inv_kanban_pvt.check_and_create_replenishment(
1068: x_return_status => l_return_status
1069: , x_supply_status => l_supply_status
1070: , x_current_replenish_cycle_id => l_current_replenish_cycle_id

Line 1067: inv_kanban_pvt.check_and_create_replenishment(

1063: IF l_kanban_card_rec.card_status = inv_kanban_pvt.g_card_status_active
1064: AND l_kanban_card_rec.supply_status = inv_kanban_pvt.g_supply_status_empty
1065: AND l_old_kanban_card_rec.supply_status <> l_kanban_card_rec.supply_status THEN
1066: mydebug('calling INV_Kanban_PVT.Check_And_Create_Replenishment');
1067: inv_kanban_pvt.check_and_create_replenishment(
1068: x_return_status => l_return_status
1069: , x_supply_status => l_supply_status
1070: , x_current_replenish_cycle_id => l_current_replenish_cycle_id
1071: , p_kanban_card_rec => l_kanban_card_rec

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

1132:
1133: IF changed_row(l_kanban_card_rec, l_old_kanban_card_rec) THEN
1134: insert_activity_for_card(l_kanban_card_rec);
1135: -- Bug Fix 4361921
1136: ELSIF l_kanban_card_rec.document_type = INV_KANBAN_PVT.G_Doc_type_lot_job and
1137: l_kanban_card_rec.document_header_id <>
1138: nvl( l_old_kanban_card_rec.document_header_id,-9999) and
1139: l_kanban_card_rec.supply_status =
1140: INV_KANBAN_PVT.G_Supply_Status_InProcess THEN

Line 1140: INV_KANBAN_PVT.G_Supply_Status_InProcess THEN

1136: ELSIF l_kanban_card_rec.document_type = INV_KANBAN_PVT.G_Doc_type_lot_job and
1137: l_kanban_card_rec.document_header_id <>
1138: nvl( l_old_kanban_card_rec.document_header_id,-9999) and
1139: l_kanban_card_rec.supply_status =
1140: INV_KANBAN_PVT.G_Supply_Status_InProcess THEN
1141: -- Bug Fix: 5344450
1142: -- Added the IF condition
1143: IF (p_replenish_quantity IS NULL) THEN
1144:

Line 1152: supply_status = INV_KANBAN_PVT.G_Supply_Status_InProcess AND

1148: UPDATE mtl_kanban_card_activity
1149: SET document_header_id = l_kanban_card_rec.document_header_id
1150: WHERE
1151: kanban_card_number = l_kanban_card_rec.kanban_card_number AND
1152: supply_status = INV_KANBAN_PVT.G_Supply_Status_InProcess AND
1153: document_type = INV_KANBAN_PVT.G_Doc_type_lot_job AND
1154: replenishment_cycle_id = l_kanban_card_rec.current_replnsh_cycle_id;
1155: ELSE
1156: -- Bug Fix: 5344450

Line 1153: document_type = INV_KANBAN_PVT.G_Doc_type_lot_job AND

1149: SET document_header_id = l_kanban_card_rec.document_header_id
1150: WHERE
1151: kanban_card_number = l_kanban_card_rec.kanban_card_number AND
1152: supply_status = INV_KANBAN_PVT.G_Supply_Status_InProcess AND
1153: document_type = INV_KANBAN_PVT.G_Doc_type_lot_job AND
1154: replenishment_cycle_id = l_kanban_card_rec.current_replnsh_cycle_id;
1155: ELSE
1156: -- Bug Fix: 5344450
1157: -- Added new update statement to update the kanban_size with p_replenish_quantity

Line 1165: supply_status = INV_KANBAN_PVT.G_Supply_Status_InProcess AND

1161: SET document_header_id = l_kanban_card_rec.document_header_id,
1162: kanban_size = p_replenish_quantity
1163: WHERE
1164: kanban_card_number = l_kanban_card_rec.kanban_card_number AND
1165: supply_status = INV_KANBAN_PVT.G_Supply_Status_InProcess AND
1166: document_type = INV_KANBAN_PVT.G_Doc_type_lot_job AND
1167: replenishment_cycle_id = l_kanban_card_rec.current_replnsh_cycle_id;
1168:
1169: END IF;

Line 1166: document_type = INV_KANBAN_PVT.G_Doc_type_lot_job AND

1162: kanban_size = p_replenish_quantity
1163: WHERE
1164: kanban_card_number = l_kanban_card_rec.kanban_card_number AND
1165: supply_status = INV_KANBAN_PVT.G_Supply_Status_InProcess AND
1166: document_type = INV_KANBAN_PVT.G_Doc_type_lot_job AND
1167: replenishment_cycle_id = l_kanban_card_rec.current_replnsh_cycle_id;
1168:
1169: END IF;
1170:

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

1186:
1187: x_return_status := fnd_api.g_ret_sts_unexp_error;
1188: END update_row;
1189:
1190: PROCEDURE update_row(p_kanban_card_rec inv_kanban_pvt.kanban_card_rec_type) IS
1191: l_return_status VARCHAR2(1);
1192: l_supply_status NUMBER;
1193: l_card_status NUMBER;
1194: l_current_replnsh_cycle_id NUMBER;

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

1275:
1276: RAISE fnd_api.g_exc_unexpected_error;
1277: END update_row;
1278:
1279: PROCEDURE update_card_status(p_kanban_card_rec IN OUT NOCOPY inv_kanban_pvt.kanban_card_rec_type, p_card_status IN NUMBER) IS
1280: l_return_status VARCHAR2(1);
1281: l_card_status NUMBER;
1282: BEGIN
1283: fnd_msg_pub.initialize;

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

1375:
1376: x_return_status := fnd_api.g_ret_sts_unexp_error;
1377: END delete_row;
1378:
1379: PROCEDURE insert_activity_for_card(p_kanban_card_rec IN inv_kanban_pvt.kanban_card_rec_type) IS
1380: BEGIN
1381: INSERT INTO mtl_kanban_card_activity
1382: (
1383: kanban_activity_id