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.INVKBCGN dependencies on INV_KANBAN_PVT

Line 1288: l_kanban_card_ids INV_Kanban_PVT.kanban_card_id_tbl_type;

1284: --ekanban changes by javakat
1285: X_CREATE_CARD_FLAG IN NUMBER DEFAULT 1,
1286: X_PLAN_CARD_FLAG IN NUMBER DEFAULT 2
1287: ) IS
1288: l_kanban_card_ids INV_Kanban_PVT.kanban_card_id_tbl_type;
1289: l_pull_seq_rec INV_Kanban_PVT.pull_sequence_rec_type;
1290: /*l_kanban_card_rec declared by javakat 11829018
1291: to insert record into mtl_kanban_card_activity*/
1292: l_kanban_card_rec INV_Kanban_PVT.Kanban_Card_Rec_Type;

Line 1289: l_pull_seq_rec INV_Kanban_PVT.pull_sequence_rec_type;

1285: X_CREATE_CARD_FLAG IN NUMBER DEFAULT 1,
1286: X_PLAN_CARD_FLAG IN NUMBER DEFAULT 2
1287: ) IS
1288: l_kanban_card_ids INV_Kanban_PVT.kanban_card_id_tbl_type;
1289: l_pull_seq_rec INV_Kanban_PVT.pull_sequence_rec_type;
1290: /*l_kanban_card_rec declared by javakat 11829018
1291: to insert record into mtl_kanban_card_activity*/
1292: l_kanban_card_rec INV_Kanban_PVT.Kanban_Card_Rec_Type;
1293: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;

Line 1292: l_kanban_card_rec INV_Kanban_PVT.Kanban_Card_Rec_Type;

1288: l_kanban_card_ids INV_Kanban_PVT.kanban_card_id_tbl_type;
1289: l_pull_seq_rec INV_Kanban_PVT.pull_sequence_rec_type;
1290: /*l_kanban_card_rec declared by javakat 11829018
1291: to insert record into mtl_kanban_card_activity*/
1292: l_kanban_card_rec INV_Kanban_PVT.Kanban_Card_Rec_Type;
1293: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
1294: l_report_id number;
1295: l_org_code VARCHAR2(3) := Null;
1296: l_item_name MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE := Null;

Line 1319: WHERE card_status =INV_Kanban_PVT.G_Card_Status_Planned

1315: Cursor get_cards_to_update(p_pull_sequence_id NUMBER)
1316: Is
1317: SELECT kanban_card_id
1318: FROM MTL_KANBAN_CARDS
1319: WHERE card_status =INV_Kanban_PVT.G_Card_Status_Planned
1320: AND pull_sequence_id = p_pull_sequence_id;
1321: BEGIN
1322: l_pull_seq_rec.pull_sequence_id := X_pull_sequence_id;
1323: l_pull_seq_rec.organization_id := X_org_id ;

Line 1382: if l_pull_seq_rec.source_type = INV_Kanban_PVT.G_Source_Type_Supplier then

1378: ,last_update_date = sysdate
1379: ,last_updated_by = fnd_global.user_id
1380: WHERE pull_sequence_id = X_pull_sequence_id;
1381:
1382: if l_pull_seq_rec.source_type = INV_Kanban_PVT.G_Source_Type_Supplier then
1383: FLM_MULTIPLE_SUPPLIERS.multiple_supplier_kanban_cards( p_pull_seq_id =>X_pull_sequence_id,
1384: x_retcode =>l_return_status ,
1385: x_err_msg => X_ERR_MSG);
1386: end if;

Line 1397: AND (card_status = INV_Kanban_PVT.G_Card_Status_Active or

1393: SELECT COUNT(*)
1394: INTO l_no_of_existing_cards
1395: FROM MTL_KANBAN_CARDS
1396: WHERE pull_sequence_id = X_Pull_sequence_id
1397: AND (card_status = INV_Kanban_PVT.G_Card_Status_Active or
1398: card_status = INV_Kanban_PVT.G_Card_Status_Hold)
1399: AND max_replenishments is null
1400: AND disable_date is null
1401: AND kanban_card_type = INV_Kanban_Pvt.g_card_type_replenishable;

Line 1398: card_status = INV_Kanban_PVT.G_Card_Status_Hold)

1394: INTO l_no_of_existing_cards
1395: FROM MTL_KANBAN_CARDS
1396: WHERE pull_sequence_id = X_Pull_sequence_id
1397: AND (card_status = INV_Kanban_PVT.G_Card_Status_Active or
1398: card_status = INV_Kanban_PVT.G_Card_Status_Hold)
1399: AND max_replenishments is null
1400: AND disable_date is null
1401: AND kanban_card_type = INV_Kanban_Pvt.g_card_type_replenishable;
1402:

Line 1401: AND kanban_card_type = INV_Kanban_Pvt.g_card_type_replenishable;

1397: AND (card_status = INV_Kanban_PVT.G_Card_Status_Active or
1398: card_status = INV_Kanban_PVT.G_Card_Status_Hold)
1399: AND max_replenishments is null
1400: AND disable_date is null
1401: AND kanban_card_type = INV_Kanban_Pvt.g_card_type_replenishable;
1402:
1403: v_kanban_card.delete;
1404: UPDATE MTL_KANBAN_CARDS SET
1405: card_status=INV_Kanban_PVT.G_Card_Status_Active,

Line 1405: card_status=INV_Kanban_PVT.G_Card_Status_Active,

1401: AND kanban_card_type = INV_Kanban_Pvt.g_card_type_replenishable;
1402:
1403: v_kanban_card.delete;
1404: UPDATE MTL_KANBAN_CARDS SET
1405: card_status=INV_Kanban_PVT.G_Card_Status_Active,
1406: last_update_date = sysdate,
1407: last_updated_by = fnd_global.user_id
1408: WHERE card_status =INV_Kanban_PVT.G_Card_Status_Planned
1409: AND pull_sequence_id = X_pull_sequence_id

Line 1408: WHERE card_status =INV_Kanban_PVT.G_Card_Status_Planned

1404: UPDATE MTL_KANBAN_CARDS SET
1405: card_status=INV_Kanban_PVT.G_Card_Status_Active,
1406: last_update_date = sysdate,
1407: last_updated_by = fnd_global.user_id
1408: WHERE card_status =INV_Kanban_PVT.G_Card_Status_Planned
1409: AND pull_sequence_id = X_pull_sequence_id
1410: AND (max_replenishments is not null or
1411: disable_date is not null or
1412: kanban_card_type <> INV_Kanban_Pvt.g_card_type_replenishable)

Line 1412: kanban_card_type <> INV_Kanban_Pvt.g_card_type_replenishable)

1408: WHERE card_status =INV_Kanban_PVT.G_Card_Status_Planned
1409: AND pull_sequence_id = X_pull_sequence_id
1410: AND (max_replenishments is not null or
1411: disable_date is not null or
1412: kanban_card_type <> INV_Kanban_Pvt.g_card_type_replenishable)
1413: returning kanban_card_id bulk collect into v_kanban_card;
1414:
1415: l_temp := v_kanban_card.first;
1416: if l_temp is not null then

Line 1426: card_status=INV_Kanban_PVT.G_Card_Status_Active,

1422: end if;
1423:
1424: v_kanban_card.delete;
1425: UPDATE MTL_KANBAN_CARDS SET
1426: card_status=INV_Kanban_PVT.G_Card_Status_Active,
1427: last_update_date = sysdate,
1428: last_updated_by = fnd_global.user_id
1429: WHERE card_status =INV_Kanban_PVT.G_Card_Status_Planned
1430: AND pull_sequence_id = X_pull_sequence_id

Line 1429: WHERE card_status =INV_Kanban_PVT.G_Card_Status_Planned

1425: UPDATE MTL_KANBAN_CARDS SET
1426: card_status=INV_Kanban_PVT.G_Card_Status_Active,
1427: last_update_date = sysdate,
1428: last_updated_by = fnd_global.user_id
1429: WHERE card_status =INV_Kanban_PVT.G_Card_Status_Planned
1430: AND pull_sequence_id = X_pull_sequence_id
1431: AND max_replenishments is null
1432: AND disable_date is null
1433: AND kanban_card_type = INV_Kanban_Pvt.g_card_type_replenishable

Line 1433: AND kanban_card_type = INV_Kanban_Pvt.g_card_type_replenishable

1429: WHERE card_status =INV_Kanban_PVT.G_Card_Status_Planned
1430: AND pull_sequence_id = X_pull_sequence_id
1431: AND max_replenishments is null
1432: AND disable_date is null
1433: AND kanban_card_type = INV_Kanban_Pvt.g_card_type_replenishable
1434: AND rownum <= (nvl(l_number_of_cards,0)- l_no_of_existing_cards )
1435: returning kanban_card_id bulk collect into v_kanban_card;
1436:
1437: l_temp := v_kanban_card.first;

Line 1452: AND (card_status = INV_Kanban_PVT.G_Card_Status_Active or

1448: SELECT COUNT(*)
1449: INTO l_no_of_existing_cards
1450: FROM MTL_KANBAN_CARDS
1451: WHERE pull_sequence_id = X_Pull_sequence_id
1452: AND (card_status = INV_Kanban_PVT.G_Card_Status_Active or
1453: card_status = INV_Kanban_PVT.G_Card_Status_Hold)
1454: /*Added these 2 where clauses by javakat to fix 11829018*/
1455: AND max_replenishments is null
1456: AND disable_date is null

Line 1453: card_status = INV_Kanban_PVT.G_Card_Status_Hold)

1449: INTO l_no_of_existing_cards
1450: FROM MTL_KANBAN_CARDS
1451: WHERE pull_sequence_id = X_Pull_sequence_id
1452: AND (card_status = INV_Kanban_PVT.G_Card_Status_Active or
1453: card_status = INV_Kanban_PVT.G_Card_Status_Hold)
1454: /*Added these 2 where clauses by javakat to fix 11829018*/
1455: AND max_replenishments is null
1456: AND disable_date is null
1457: AND kanban_card_type = INV_Kanban_Pvt.g_card_type_replenishable;

Line 1457: AND kanban_card_type = INV_Kanban_Pvt.g_card_type_replenishable;

1453: card_status = INV_Kanban_PVT.G_Card_Status_Hold)
1454: /*Added these 2 where clauses by javakat to fix 11829018*/
1455: AND max_replenishments is null
1456: AND disable_date is null
1457: AND kanban_card_type = INV_Kanban_Pvt.g_card_type_replenishable;
1458:
1459: PUT_LINE('l_no_of_existing_cards - '||l_no_of_existing_cards);
1460: PUT_LINE('l_future_no_of_cards - '||l_future_no_of_cards);
1461: l_pull_seq_rec.number_of_cards := l_number_of_cards-l_no_of_existing_cards ;

Line 1468: if INV_kanban_PVT.Ok_To_Create_Kanban_Cards(X_Pull_sequence_id ) then

1464: PUT_LINE('No Cards will be created X_CREATE_CARD_FLAG -'||X_CREATE_CARD_FLAG);
1465: RAISE end_of_code;
1466: END IF;
1467: ELSE --for old code
1468: if INV_kanban_PVT.Ok_To_Create_Kanban_Cards(X_Pull_sequence_id ) then
1469: l_create_kanban:=TRUE;
1470: ELSE
1471: l_create_kanban:=FALSE;
1472: PUT_LINE( fnd_message.get );

Line 1479: PUT_LINE('calling INV_kanban_PVT.create_kanban_cards');

1475: /*changes made to the if clause to fix bug 11800873*/
1476: --IF l_create_kanban AND l_pull_seq_rec.number_of_cards >0 THEN
1477: no_of_cards_created:=l_pull_seq_rec.number_of_cards; --Bug 11829018
1478: IF l_create_kanban THEN
1479: PUT_LINE('calling INV_kanban_PVT.create_kanban_cards');
1480: INV_kanban_PVT.create_kanban_cards( l_return_status,
1481: l_kanban_card_ids,
1482: l_pull_seq_rec,
1483: X_STATUS );

Line 1480: INV_kanban_PVT.create_kanban_cards( l_return_status,

1476: --IF l_create_kanban AND l_pull_seq_rec.number_of_cards >0 THEN
1477: no_of_cards_created:=l_pull_seq_rec.number_of_cards; --Bug 11829018
1478: IF l_create_kanban THEN
1479: PUT_LINE('calling INV_kanban_PVT.create_kanban_cards');
1480: INV_kanban_PVT.create_kanban_cards( l_return_status,
1481: l_kanban_card_ids,
1482: l_pull_seq_rec,
1483: X_STATUS );
1484:

Line 2087: PUT_LINE('calling INV_kanban_PVT.Create_eKanban_Cards');

2083: l_loc_name varchar2(2000);
2084: l_subinventory varchar2(10);
2085: l_org_code varchar2(3);
2086: BEGIN
2087: PUT_LINE('calling INV_kanban_PVT.Create_eKanban_Cards');
2088: --make a call to Create_Kanban_Cards
2089:
2090: select nvl(planning_effectivity,trunc(sysdate)),future_card_size,kanban_size,number_of_cards,future_no_of_cards
2091: into l_plan_eff_date,l_future_size,l_size,l_num_card,l_future_num_card