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.MTL_CCEOI_ACTION_PUB dependencies on MTL_CCEOI_VAR_PVT

Line 17: -- cycle count entry whose id is stored inside mtl_cceoi_var_pvt.G_CYCLE_COUNT_ENTRY_REC.CYCLE_COUNT_ENTRY_ID

13:
14:
15:
16: -- finds interface id of an interface record that is created for processing
17: -- cycle count entry whose id is stored inside mtl_cceoi_var_pvt.G_CYCLE_COUNT_ENTRY_REC.CYCLE_COUNT_ENTRY_ID
18: -- pre: mtl_var_cceoi_pvt.g_cycle_count_entry_rec is filled out by call to
19: -- mtl_cceoi_prcess_pvt.validate_countlistseq
20: -- this function relies on invariant: at any time there shall be no more than
21: -- one interface record that contains pointer to exported cycle count entry

Line 37: for c_rec in l_mcei_csr(mtl_cceoi_var_pvt.G_CYCLE_COUNT_ENTRY_REC.CYCLE_COUNT_ENTRY_ID) loop

33: counter number := 0;
34:
35: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
36: begin
37: for c_rec in l_mcei_csr(mtl_cceoi_var_pvt.G_CYCLE_COUNT_ENTRY_REC.CYCLE_COUNT_ENTRY_ID) loop
38: p_cei_id := c_rec.cc_entry_interface_id;
39: counter := counter + 1;
40: end loop;
41:

Line 59: , last_updated_by = MTL_CCEOI_VAR_PVT.G_UserID

55: update mtl_cc_entries_interface
56: set
57: lock_flag = 2
58: , last_update_date = sysdate
59: , last_updated_by = MTL_CCEOI_VAR_PVT.G_UserID
60: , last_update_login = MTL_CCEOI_VAR_PVT.G_LoginID
61: , request_id = MTL_CCEOI_VAR_PVT.G_RequestID
62: , program_application_id = MTL_CCEOI_VAR_PVT.G_ProgramAppID
63: , program_id = MTL_CCEOI_VAR_PVT.G_ProgramID

Line 60: , last_update_login = MTL_CCEOI_VAR_PVT.G_LoginID

56: set
57: lock_flag = 2
58: , last_update_date = sysdate
59: , last_updated_by = MTL_CCEOI_VAR_PVT.G_UserID
60: , last_update_login = MTL_CCEOI_VAR_PVT.G_LoginID
61: , request_id = MTL_CCEOI_VAR_PVT.G_RequestID
62: , program_application_id = MTL_CCEOI_VAR_PVT.G_ProgramAppID
63: , program_id = MTL_CCEOI_VAR_PVT.G_ProgramID
64: , program_update_date = sysdate

Line 61: , request_id = MTL_CCEOI_VAR_PVT.G_RequestID

57: lock_flag = 2
58: , last_update_date = sysdate
59: , last_updated_by = MTL_CCEOI_VAR_PVT.G_UserID
60: , last_update_login = MTL_CCEOI_VAR_PVT.G_LoginID
61: , request_id = MTL_CCEOI_VAR_PVT.G_RequestID
62: , program_application_id = MTL_CCEOI_VAR_PVT.G_ProgramAppID
63: , program_id = MTL_CCEOI_VAR_PVT.G_ProgramID
64: , program_update_date = sysdate
65: where

Line 62: , program_application_id = MTL_CCEOI_VAR_PVT.G_ProgramAppID

58: , last_update_date = sysdate
59: , last_updated_by = MTL_CCEOI_VAR_PVT.G_UserID
60: , last_update_login = MTL_CCEOI_VAR_PVT.G_LoginID
61: , request_id = MTL_CCEOI_VAR_PVT.G_RequestID
62: , program_application_id = MTL_CCEOI_VAR_PVT.G_ProgramAppID
63: , program_id = MTL_CCEOI_VAR_PVT.G_ProgramID
64: , program_update_date = sysdate
65: where
66: cc_entry_interface_id = p_iface_id;

Line 63: , program_id = MTL_CCEOI_VAR_PVT.G_ProgramID

59: , last_updated_by = MTL_CCEOI_VAR_PVT.G_UserID
60: , last_update_login = MTL_CCEOI_VAR_PVT.G_LoginID
61: , request_id = MTL_CCEOI_VAR_PVT.G_RequestID
62: , program_application_id = MTL_CCEOI_VAR_PVT.G_ProgramAppID
63: , program_id = MTL_CCEOI_VAR_PVT.G_ProgramID
64: , program_update_date = sysdate
65: where
66: cc_entry_interface_id = p_iface_id;
67:

Line 79: x_iface_rec IN OUT NOCOPY MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE,

75: -- the interface row
76: -- pre: p_cce_rec is a copy of valid mtl_cycle_count_entry record
77: PROCEDURE derive_CCE_Info
78: (
79: x_iface_rec IN OUT NOCOPY MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE,
80: p_cce_rec IN MTL_CYCLE_COUNT_ENTRIES%ROWTYPE )
81: IS
82: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
83: BEGIN

Line 165: x_iface_rec.adjustment_account_id := mtl_cceoi_var_pvt.g_cycle_count_header_rec.inventory_adjustment_account;

161: x_iface_rec.attribute14 := p_cce_rec.attribute14;
162: x_iface_rec.attribute15 := p_cce_rec.attribute15;
163:
164: -- account
165: x_iface_rec.adjustment_account_id := mtl_cceoi_var_pvt.g_cycle_count_header_rec.inventory_adjustment_account;
166: x_iface_rec.account_segment1 := null;
167: x_iface_rec.account_segment2 := null;
168: x_iface_rec.account_segment3 := null;
169: x_iface_rec.account_segment4 := null;

Line 222: x_iface_rec IN OUT NOCOPY MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE)

218: x_return_status OUT NOCOPY VARCHAR2 ,
219: x_errorcode OUT NOCOPY NUMBER,
220: x_msg_count OUT NOCOPY NUMBER ,
221: x_msg_data OUT NOCOPY VARCHAR2 ,
222: x_iface_rec IN OUT NOCOPY MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE)
223: IS
224: l_api_version number := 0.9;
225: l_api_name VARCHAR2(30) := 'Enforce_SKU_CountEntry_Match';
226:

Line 284: p_cycle_count_header_id => MTL_CCEOI_VAR_PVT.G_CC_HEADER_ID,

280: x_msg_count => x_msg_count,
281: x_msg_data => x_msg_data,
282: x_return_status => x_return_status,
283: x_errorcode => x_errorcode,
284: p_cycle_count_header_id => MTL_CCEOI_VAR_PVT.G_CC_HEADER_ID,
285: p_cycle_count_entry_id => x_iface_rec.cycle_count_entry_id,
286: p_count_list_sequence => x_iface_rec.count_list_sequence,
287: p_organization_id =>
288: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.organization_id);

Line 288: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.organization_id);

284: p_cycle_count_header_id => MTL_CCEOI_VAR_PVT.G_CC_HEADER_ID,
285: p_cycle_count_entry_id => x_iface_rec.cycle_count_entry_id,
286: p_count_list_sequence => x_iface_rec.count_list_sequence,
287: p_organization_id =>
288: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC.organization_id);
289:
290: if (x_return_status <> fnd_api.g_ret_sts_success) then
291: raise fnd_api.g_exc_error;
292: end if;

Line 304: mtl_cceoi_var_pvt.g_cycle_count_entry_rec.cycle_count_entry_id;

300:
301: -- if we're here that means we have found a corresponding entry
302: -- in the cycle count
303: x_iface_rec.cycle_count_entry_id :=
304: mtl_cceoi_var_pvt.g_cycle_count_entry_rec.cycle_count_entry_id;
305: end if;
306:
307: for c_rec in l_mcce_csr(x_iface_rec.cycle_count_entry_id) loop
308:

Line 332: if (x_iface_rec.action_code <> mtl_cceoi_var_pvt.g_valsim) then

328: -- TODO: print warning about deriving stuff
329:
330: derive_CCE_Info(x_iface_rec => x_iface_rec, p_cce_rec => c_rec);
331:
332: if (x_iface_rec.action_code <> mtl_cceoi_var_pvt.g_valsim) then
333: IF (l_debug = 1) THEN
334: mdebug('Exporting: ' || to_char(x_iface_rec.cycle_count_entry_id));
335: END IF;
336: mtl_cceoi_process_pvt.Set_CCExport(

Line 423: x_iface_rec IN OUT NOCOPY MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE)

419: x_return_status OUT NOCOPY VARCHAR2 ,
420: x_errorcode OUT NOCOPY NUMBER,
421: x_msg_count OUT NOCOPY NUMBER ,
422: x_msg_data OUT NOCOPY VARCHAR2 ,
423: x_iface_rec IN OUT NOCOPY MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE)
424: IS
425: -- Start OF comments
426: -- API name : Initial_Insert
427: -- TYPE : Private

Line 506: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID :=

502: END IF;
503: -- if record is in the interface already
504: for c_rec in l_mcei_csr(x_iface_rec.cc_entry_interface_id) loop
505:
506: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID :=
507: x_iface_rec.cc_entry_interface_id;
508:
509: if (c_rec.lock_flag = 1) then
510:

Line 598: x_iface_rec.cycle_count_header_id := mtl_cceoi_var_pvt.g_cc_header_id;

594: x_iface_rec.valid_flag := 2;--c_rec.valid_flag;
595: x_iface_rec.status_flag := c_rec.status_flag;
596: x_iface_rec.error_flag := c_rec.error_flag;
597: x_iface_rec.lock_flag := 1;
598: x_iface_rec.cycle_count_header_id := mtl_cceoi_var_pvt.g_cc_header_id;
599:
600: mtl_cceoi_process_pvt.Update_CCIEntry(x_iface_rec,x_return_status);
601:
602: if (x_return_status <> fnd_api.g_ret_sts_success) then

Line 619: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID :=

615: SELECT MTL_CC_ENTRIES_INTERFACE_S1.nextval
616: INTO x_iface_rec.cc_entry_interface_id
617: FROM dual;
618:
619: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID :=
620: x_iface_rec.cc_entry_interface_id;
621: MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM := FALSE;
622:
623: Enforce_SKU_CountEntry_Match(

Line 621: MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM := FALSE;

617: FROM dual;
618:
619: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID :=
620: x_iface_rec.cc_entry_interface_id;
621: MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM := FALSE;
622:
623: Enforce_SKU_CountEntry_Match(
624: p_api_version=>0.9,
625: x_msg_data => x_msg_data,

Line 648: -- if header name was supplied then mtl_cceoi_var_pvt.g_cc_header_id

644: end if;
645:
646: -- mark record to be initially valid, unprocessed, no errors, locked
647: x_iface_rec.valid_flag := 2;
648: -- if header name was supplied then mtl_cceoi_var_pvt.g_cc_header_id
649: -- contains its id, if id was supplied instead of name then
650: -- mtl_cceoi_var_pvt.g_cc_header_id is equal to that
651: -- if no id or header name was supplied then this variable is still
652: -- null

Line 650: -- mtl_cceoi_var_pvt.g_cc_header_id is equal to that

646: -- mark record to be initially valid, unprocessed, no errors, locked
647: x_iface_rec.valid_flag := 2;
648: -- if header name was supplied then mtl_cceoi_var_pvt.g_cc_header_id
649: -- contains its id, if id was supplied instead of name then
650: -- mtl_cceoi_var_pvt.g_cc_header_id is equal to that
651: -- if no id or header name was supplied then this variable is still
652: -- null
653: IF mtl_cceoi_var_pvt.g_cc_header_id IS NOT NULL THEN
654: x_iface_rec.cycle_count_header_id := mtl_cceoi_var_pvt.g_cc_header_id;

Line 653: IF mtl_cceoi_var_pvt.g_cc_header_id IS NOT NULL THEN

649: -- contains its id, if id was supplied instead of name then
650: -- mtl_cceoi_var_pvt.g_cc_header_id is equal to that
651: -- if no id or header name was supplied then this variable is still
652: -- null
653: IF mtl_cceoi_var_pvt.g_cc_header_id IS NOT NULL THEN
654: x_iface_rec.cycle_count_header_id := mtl_cceoi_var_pvt.g_cc_header_id;
655: END IF;
656: x_iface_rec.status_flag := null;
657: x_iface_rec.error_flag := null;

Line 654: x_iface_rec.cycle_count_header_id := mtl_cceoi_var_pvt.g_cc_header_id;

650: -- mtl_cceoi_var_pvt.g_cc_header_id is equal to that
651: -- if no id or header name was supplied then this variable is still
652: -- null
653: IF mtl_cceoi_var_pvt.g_cc_header_id IS NOT NULL THEN
654: x_iface_rec.cycle_count_header_id := mtl_cceoi_var_pvt.g_cc_header_id;
655: END IF;
656: x_iface_rec.status_flag := null;
657: x_iface_rec.error_flag := null;
658: x_iface_rec.lock_flag := 1;

Line 676: MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM := TRUE; -- XXX do not need this anymore

672: end if;
673: end if;
674:
675: --
676: MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM := TRUE; -- XXX do not need this anymore
677: --
678: -- END of API body
679: --
680:

Line 739: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE,

735: X_return_status OUT NOCOPY VARCHAR2 ,
736: x_errorcode OUT NOCOPY NUMBER,
737: x_msg_count OUT NOCOPY NUMBER ,
738: x_msg_data OUT NOCOPY VARCHAR2 ,
739: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE,
740: x_interface_id OUT NOCOPY NUMBER)
741: IS
742:
743: l_return_status VARCHAR2(1);

Line 781: L_interface_rec MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE;

777: DECLARE
778: L_api_version CONSTANT NUMBER := 0.9;
779: L_api_name CONSTANT VARCHAR2(30) := 'Import_CountRequest';
780: L_CCEOIId NUMBER;
781: L_interface_rec MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE;
782: L_id NUMBER;
783: BEGIN
784: -- Standard start of API savepoint
785: SAVEPOINT Import_CountRequest_PUB;

Line 827: MTL_CCEOI_VAR_PVT.G_COST_GROUP_ID := p_interface_rec.cost_group_id;

823: END IF;
824: END IF;
825:
826: --Set Cost Group ID Global variable
827: MTL_CCEOI_VAR_PVT.G_COST_GROUP_ID := p_interface_rec.cost_group_id;
828:
829: --Set Cost Group ID Global variable
830: MTL_CCEOI_VAR_PVT.G_COST_GROUP_ID := p_interface_rec.cost_group_id;
831:

Line 830: MTL_CCEOI_VAR_PVT.G_COST_GROUP_ID := p_interface_rec.cost_group_id;

826: --Set Cost Group ID Global variable
827: MTL_CCEOI_VAR_PVT.G_COST_GROUP_ID := p_interface_rec.cost_group_id;
828:
829: --Set Cost Group ID Global variable
830: MTL_CCEOI_VAR_PVT.G_COST_GROUP_ID := p_interface_rec.cost_group_id;
831:
832: -- check for locks, exports / derive necessary data from cc entry
833: -- so that we do not store junk
834:

Line 869: P_interface_rec.action_code = MTL_CCEOI_VAR_PVT.G_VALIDATE THEN

865:
866:
867: -- IF (p_interface_rec.process_mode = 1) then -- online mode
868: IF
869: P_interface_rec.action_code = MTL_CCEOI_VAR_PVT.G_VALIDATE THEN
870: MTL_CCEOI_ACTION_PVT.Validate_CountRequest(
871: p_api_version => 0.9
872: , p_init_msg_list => FND_API.G_TRUE
873: , x_return_status => x_return_status

Line 878: P_interface_rec.action_code = MTL_CCEOI_VAR_PVT.G_CREATE THEN

874: , x_msg_count => x_msg_count
875: , x_msg_data => x_msg_data
876: , p_interface_rec => L_interface_rec);
877: ELSIF
878: P_interface_rec.action_code = MTL_CCEOI_VAR_PVT.G_CREATE THEN
879: MTL_CCEOI_ACTION_PVT.Create_CountRequest(
880: p_api_version => 0.9
881: , p_init_msg_list => FND_API.G_TRUE
882: , x_return_status => x_return_status

Line 887: P_interface_rec.action_code = MTL_CCEOI_VAR_PVT.G_VALSIM THEN

883: , x_msg_count => x_msg_count
884: , x_msg_data => x_msg_data
885: , p_interface_rec => L_interface_rec);
886: ELSIF
887: P_interface_rec.action_code = MTL_CCEOI_VAR_PVT.G_VALSIM THEN
888: MTL_CCEOI_ACTION_PVT.ValSim_CountRequest(
889: p_api_version => 0.9
890: , p_init_msg_list => FND_API.G_TRUE
891: , x_return_status => x_return_status

Line 896: P_interface_rec.action_code = MTL_CCEOI_VAR_PVT.G_PROCESS THEN

892: , x_msg_count => x_msg_count
893: , x_msg_data => x_msg_data
894: , p_interface_rec => L_interface_rec);
895: ELSIF
896: P_interface_rec.action_code = MTL_CCEOI_VAR_PVT.G_PROCESS THEN
897:
898: MTL_CCEOI_ACTION_PVT.Process_CountRequest(
899: p_api_version => 0.9
900: , p_init_msg_list => FND_API.G_TRUE

Line 915: if (MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = FALSE) THEN

911:
912: FND_MESSAGE.SET_NAME('INV', 'INV_CCEOI_UNKNOWN_ACTION_CODE');
913: FND_MSG_PUB.Add;
914:
915: if (MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM = FALSE) THEN
916:
917: -- this is a really dangerous call since
918: -- some of the mandatory fields may be null in which case
919: -- insert will raise an exception

Line 927: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID,

923: end if;
924:
925: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
926: p_cc_entry_interface_id =>
927: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID,
928: p_error_column_name => 'ACTION_CODE'
929: , p_error_table_name => 'MTL_CC_ENTRIES_INTERFACE_ID'
930: , p_message_name => 'INV_CCEOI_UNKNOWN_ACTION_CODE');
931:

Line 947: -- if (mtl_cceoi_var_pvt.g_rec_in_system) then

943: -- If the record exists in database and the record is processed successful
944: -- mark it for deletion, and unexport the record from MCCE
945: -- if necessary
946: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
947: -- if (mtl_cceoi_var_pvt.g_rec_in_system) then
948: -- it is unnecessary to mark it for deletion since
949: -- it will be deleted by purge if status_flag in (0,1)
950: /* MTL_CCEOI_PROCESS_PVT.Set_CCEOIFlags(
951: p_api_version => 0.9

Line 956: , p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID,

952: , p_init_msg_list => FND_API.G_TRUE
953: , x_return_status => x_return_status
954: , x_msg_count => x_msg_count
955: , x_msg_data => x_msg_data
956: , p_cc_entry_interface_id => MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID,
957: --=>L_interface_rec.cc_entry_interface_id,
958: p_flags => '$1$$');
959:
960: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 970: (mtl_cceoi_var_pvt.g_valsim, mtl_cceoi_var_pvt.g_validate))

966: -- need to unexport record if it was exported unless it was in
967: -- simulate mode in which case cce record was not exported
968: -- or validate in which case it should stay exported
969: if ((l_interface_rec.action_code not in
970: (mtl_cceoi_var_pvt.g_valsim, mtl_cceoi_var_pvt.g_validate))
971: AND ( MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.CYCLE_COUNT_ENTRY_ID is not null )) then
972: -- record must have been exported in order
973: -- to be processed, unless it is just validation
974: -- an of unscheduled entry in which case

Line 971: AND ( MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.CYCLE_COUNT_ENTRY_ID is not null )) then

967: -- simulate mode in which case cce record was not exported
968: -- or validate in which case it should stay exported
969: if ((l_interface_rec.action_code not in
970: (mtl_cceoi_var_pvt.g_valsim, mtl_cceoi_var_pvt.g_validate))
971: AND ( MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.CYCLE_COUNT_ENTRY_ID is not null )) then
972: -- record must have been exported in order
973: -- to be processed, unless it is just validation
974: -- an of unscheduled entry in which case
975: -- no cycle count entry id will exist

Line 981: p_cycle_count_entry_id => mtl_cceoi_var_pvt.G_CYCLE_COUNT_ENTRY_REC.CYCLE_COUNT_ENTRY_ID,

977: p_api_version => 0.9,
978: x_return_status => x_return_status,
979: x_msg_data => x_msg_data,
980: x_msg_count => x_msg_count,
981: p_cycle_count_entry_id => mtl_cceoi_var_pvt.G_CYCLE_COUNT_ENTRY_REC.CYCLE_COUNT_ENTRY_ID,
982: p_export_flag => null);
983:
984: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
985: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 996: IF MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID is not null and

992:
993: -- END IF;
994: --Before unlocking record, updating the item id, locator id
995: -- into the interface table, which are missing
996: IF MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID is not null and
997: mtl_cceoi_var_pvt.g_cc_entry_interface_id is not null
998: THEN
999: begin
1000: update mtl_cc_entries_interface

Line 997: mtl_cceoi_var_pvt.g_cc_entry_interface_id is not null

993: -- END IF;
994: --Before unlocking record, updating the item id, locator id
995: -- into the interface table, which are missing
996: IF MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID is not null and
997: mtl_cceoi_var_pvt.g_cc_entry_interface_id is not null
998: THEN
999: begin
1000: update mtl_cc_entries_interface
1001: set inventory_item_id = MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID,

Line 1001: set inventory_item_id = MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID,

997: mtl_cceoi_var_pvt.g_cc_entry_interface_id is not null
998: THEN
999: begin
1000: update mtl_cc_entries_interface
1001: set inventory_item_id = MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID,
1002: locator_id = MTL_CCEOI_VAR_PVT.G_LOCATOR_ID
1003: where cc_entry_interface_id = mtl_cceoi_var_pvt.g_cc_entry_interface_id
1004: and inventory_item_id is null;
1005: exception

Line 1002: locator_id = MTL_CCEOI_VAR_PVT.G_LOCATOR_ID

998: THEN
999: begin
1000: update mtl_cc_entries_interface
1001: set inventory_item_id = MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID,
1002: locator_id = MTL_CCEOI_VAR_PVT.G_LOCATOR_ID
1003: where cc_entry_interface_id = mtl_cceoi_var_pvt.g_cc_entry_interface_id
1004: and inventory_item_id is null;
1005: exception
1006: when others then null;

Line 1003: where cc_entry_interface_id = mtl_cceoi_var_pvt.g_cc_entry_interface_id

999: begin
1000: update mtl_cc_entries_interface
1001: set inventory_item_id = MTL_CCEOI_VAR_PVT.G_INVENTORY_ITEM_ID,
1002: locator_id = MTL_CCEOI_VAR_PVT.G_LOCATOR_ID
1003: where cc_entry_interface_id = mtl_cceoi_var_pvt.g_cc_entry_interface_id
1004: and inventory_item_id is null;
1005: exception
1006: when others then null;
1007: end;

Line 1022: x_interface_id := mtl_cceoi_var_pvt.g_cc_entry_interface_id;

1018:
1019: -- use a different x_return_status
1020:
1021:
1022: x_interface_id := mtl_cceoi_var_pvt.g_cc_entry_interface_id;
1023: --
1024: -- END of API body
1025: -- Standard check of p_commit
1026: IF FND_API.to_Boolean(p_commit) THEN

Line 1080: MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM := TRUE;

1076:
1077: --- temporary adhoc which helps concurrent programs to work properly
1078: --- since the only place where we set this variable is public api
1079: --- function that is not used by concurrent programs
1080: MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM := TRUE;
1081:
1082: END;
1083:
1084:

Line 1096: , p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE

1092: , x_return_status OUT NOCOPY VARCHAR2
1093: , x_errorcode OUT NOCOPY NUMBER
1094: , x_msg_count OUT NOCOPY NUMBER
1095: , x_msg_data OUT NOCOPY VARCHAR2
1096: , p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE
1097: , x_interface_id_list OUT NOCOPY MTL_CCEOI_VAR_PVT.INV_CCEOI_ID_TABLE_TYPE
1098: )
1099: IS
1100: l_api_version NUMBER := 0.9;

Line 1097: , x_interface_id_list OUT NOCOPY MTL_CCEOI_VAR_PVT.INV_CCEOI_ID_TABLE_TYPE

1093: , x_errorcode OUT NOCOPY NUMBER
1094: , x_msg_count OUT NOCOPY NUMBER
1095: , x_msg_data OUT NOCOPY VARCHAR2
1096: , p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE
1097: , x_interface_id_list OUT NOCOPY MTL_CCEOI_VAR_PVT.INV_CCEOI_ID_TABLE_TYPE
1098: )
1099: IS
1100: l_api_version NUMBER := 0.9;
1101: L_api_name VARCHAR2(30) := 'Process_LPN_CountRequest';

Line 1105: l_item_rec MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE := p_interface_rec;

1101: L_api_name VARCHAR2(30) := 'Process_LPN_CountRequest';
1102:
1103: l_lpn WMS_CONTAINER_PUB.LPN;
1104: l_expl_tbl WMS_CONTAINER_PUB.WMS_Container_Tbl_Type;
1105: l_item_rec MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE := p_interface_rec;
1106: l_temp_int_id NUMBER;
1107: l_counter NUMBER := 0;
1108: l_unsched_allowed NUMBER;
1109: v_index NUMBER;

Line 1127: MTL_CCEOI_VAR_PVT.G_LPN_ID := NULL;

1123: e_Invalid_Inputs EXCEPTION;
1124: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1125: BEGIN
1126:
1127: MTL_CCEOI_VAR_PVT.G_LPN_ID := NULL;
1128: -- Standard start of API savepoint
1129: SAVEPOINT Process_LPN_CountRequest;
1130:
1131: -- Standard Call to check for call compatibility

Line 1230: INTO MTL_CCEOI_VAR_PVT.G_CONTAINER_ENABLED_FLAG, MTL_CCEOI_VAR_PVT.G_CONTAINER_ADJUSTMENT_OPTION,

1226: END IF;
1227:
1228: -- Set global variables for container adjustment and discrepancies
1229: SELECT container_enabled_flag, container_adjustment_option, container_discrepancy_option
1230: INTO MTL_CCEOI_VAR_PVT.G_CONTAINER_ENABLED_FLAG, MTL_CCEOI_VAR_PVT.G_CONTAINER_ADJUSTMENT_OPTION,
1231: MTL_CCEOI_VAR_PVT.G_CONTAINER_DISCREPANCY_OPTION
1232: FROM MTL_CYCLE_COUNT_HEADERS
1233: WHERE cycle_count_header_id = p_interface_rec.cycle_count_header_id;
1234: -- If either flag is null if container enabled flag is enabled (1), set to default.

Line 1231: MTL_CCEOI_VAR_PVT.G_CONTAINER_DISCREPANCY_OPTION

1227:
1228: -- Set global variables for container adjustment and discrepancies
1229: SELECT container_enabled_flag, container_adjustment_option, container_discrepancy_option
1230: INTO MTL_CCEOI_VAR_PVT.G_CONTAINER_ENABLED_FLAG, MTL_CCEOI_VAR_PVT.G_CONTAINER_ADJUSTMENT_OPTION,
1231: MTL_CCEOI_VAR_PVT.G_CONTAINER_DISCREPANCY_OPTION
1232: FROM MTL_CYCLE_COUNT_HEADERS
1233: WHERE cycle_count_header_id = p_interface_rec.cycle_count_header_id;
1234: -- If either flag is null if container enabled flag is enabled (1), set to default.
1235: IF MTL_CCEOI_VAR_PVT.G_CONTAINER_ENABLED_FLAG = 1 THEN

Line 1235: IF MTL_CCEOI_VAR_PVT.G_CONTAINER_ENABLED_FLAG = 1 THEN

1231: MTL_CCEOI_VAR_PVT.G_CONTAINER_DISCREPANCY_OPTION
1232: FROM MTL_CYCLE_COUNT_HEADERS
1233: WHERE cycle_count_header_id = p_interface_rec.cycle_count_header_id;
1234: -- If either flag is null if container enabled flag is enabled (1), set to default.
1235: IF MTL_CCEOI_VAR_PVT.G_CONTAINER_ENABLED_FLAG = 1 THEN
1236: MTL_CCEOI_VAR_PVT.G_CONTAINER_ADJUSTMENT_OPTION := NVL(MTL_CCEOI_VAR_PVT.G_CONTAINER_ADJUSTMENT_OPTION, 1);
1237: MTL_CCEOI_VAR_PVT.G_CONTAINER_DISCREPANCY_OPTION := NVL(MTL_CCEOI_VAR_PVT.G_CONTAINER_DISCREPANCY_OPTION, 1);
1238: END IF;
1239:

Line 1236: MTL_CCEOI_VAR_PVT.G_CONTAINER_ADJUSTMENT_OPTION := NVL(MTL_CCEOI_VAR_PVT.G_CONTAINER_ADJUSTMENT_OPTION, 1);

1232: FROM MTL_CYCLE_COUNT_HEADERS
1233: WHERE cycle_count_header_id = p_interface_rec.cycle_count_header_id;
1234: -- If either flag is null if container enabled flag is enabled (1), set to default.
1235: IF MTL_CCEOI_VAR_PVT.G_CONTAINER_ENABLED_FLAG = 1 THEN
1236: MTL_CCEOI_VAR_PVT.G_CONTAINER_ADJUSTMENT_OPTION := NVL(MTL_CCEOI_VAR_PVT.G_CONTAINER_ADJUSTMENT_OPTION, 1);
1237: MTL_CCEOI_VAR_PVT.G_CONTAINER_DISCREPANCY_OPTION := NVL(MTL_CCEOI_VAR_PVT.G_CONTAINER_DISCREPANCY_OPTION, 1);
1238: END IF;
1239:
1240: --Check id interface record is an item or LPN

Line 1237: MTL_CCEOI_VAR_PVT.G_CONTAINER_DISCREPANCY_OPTION := NVL(MTL_CCEOI_VAR_PVT.G_CONTAINER_DISCREPANCY_OPTION, 1);

1233: WHERE cycle_count_header_id = p_interface_rec.cycle_count_header_id;
1234: -- If either flag is null if container enabled flag is enabled (1), set to default.
1235: IF MTL_CCEOI_VAR_PVT.G_CONTAINER_ENABLED_FLAG = 1 THEN
1236: MTL_CCEOI_VAR_PVT.G_CONTAINER_ADJUSTMENT_OPTION := NVL(MTL_CCEOI_VAR_PVT.G_CONTAINER_ADJUSTMENT_OPTION, 1);
1237: MTL_CCEOI_VAR_PVT.G_CONTAINER_DISCREPANCY_OPTION := NVL(MTL_CCEOI_VAR_PVT.G_CONTAINER_DISCREPANCY_OPTION, 1);
1238: END IF;
1239:
1240: --Check id interface record is an item or LPN
1241: IF (l_item_rec.inventory_item_id IS NOT NULL

Line 1485: MTL_CCEOI_VAR_PVT.G_LPN_ITEM_SYSTEM_QTY := l_expl_tbl(v_index).quantity;

1481: -- END INVCONV
1482: l_item_rec.cost_group_id := l_expl_tbl(v_index).cost_group_id;
1483:
1484: -- Assign count quantity to global variable
1485: MTL_CCEOI_VAR_PVT.G_LPN_ITEM_SYSTEM_QTY := l_expl_tbl(v_index).quantity;
1486: MTL_CCEOI_VAR_PVT.G_LPN_ITEM_SEC_SYSTEM_QTY := l_expl_tbl(v_index).sec_quantity; -- INVCONV
1487:
1488: -- Assign parent_lpn_id to global variable
1489: MTL_CCEOI_VAR_PVT.G_LPN_ID := l_expl_tbl(v_index).parent_lpn_id;

Line 1486: MTL_CCEOI_VAR_PVT.G_LPN_ITEM_SEC_SYSTEM_QTY := l_expl_tbl(v_index).sec_quantity; -- INVCONV

1482: l_item_rec.cost_group_id := l_expl_tbl(v_index).cost_group_id;
1483:
1484: -- Assign count quantity to global variable
1485: MTL_CCEOI_VAR_PVT.G_LPN_ITEM_SYSTEM_QTY := l_expl_tbl(v_index).quantity;
1486: MTL_CCEOI_VAR_PVT.G_LPN_ITEM_SEC_SYSTEM_QTY := l_expl_tbl(v_index).sec_quantity; -- INVCONV
1487:
1488: -- Assign parent_lpn_id to global variable
1489: MTL_CCEOI_VAR_PVT.G_LPN_ID := l_expl_tbl(v_index).parent_lpn_id;
1490:

Line 1489: MTL_CCEOI_VAR_PVT.G_LPN_ID := l_expl_tbl(v_index).parent_lpn_id;

1485: MTL_CCEOI_VAR_PVT.G_LPN_ITEM_SYSTEM_QTY := l_expl_tbl(v_index).quantity;
1486: MTL_CCEOI_VAR_PVT.G_LPN_ITEM_SEC_SYSTEM_QTY := l_expl_tbl(v_index).sec_quantity; -- INVCONV
1487:
1488: -- Assign parent_lpn_id to global variable
1489: MTL_CCEOI_VAR_PVT.G_LPN_ID := l_expl_tbl(v_index).parent_lpn_id;
1490:
1491: Import_CountRequest(
1492: p_api_version => 0.9,
1493: p_init_msg_list => FND_API.G_TRUE,

Line 1523: IF (l_lpn_discrepancy = 1 AND MTL_CCEOI_VAR_PVT.G_CONTAINER_ENABLED_FLAG = 1

1519: v_index := l_expl_tbl.NEXT(v_index);
1520: END LOOP;
1521:
1522: -- If discrepancy existed in lpn and no approval needed, then do a subinventory trasfer
1523: IF (l_lpn_discrepancy = 1 AND MTL_CCEOI_VAR_PVT.G_CONTAINER_ENABLED_FLAG = 1
1524: AND MTL_CCEOI_VAR_PVT.G_CONTAINER_ADJUSTMENT_OPTION = 1
1525: AND MTL_CCEOI_VAR_PVT.G_CONTAINER_DISCREPANCY_OPTION = 1 )THEN
1526: IF (l_debug = 1) THEN
1527: mdebug('lpn subinventory move in progress');

Line 1524: AND MTL_CCEOI_VAR_PVT.G_CONTAINER_ADJUSTMENT_OPTION = 1

1520: END LOOP;
1521:
1522: -- If discrepancy existed in lpn and no approval needed, then do a subinventory trasfer
1523: IF (l_lpn_discrepancy = 1 AND MTL_CCEOI_VAR_PVT.G_CONTAINER_ENABLED_FLAG = 1
1524: AND MTL_CCEOI_VAR_PVT.G_CONTAINER_ADJUSTMENT_OPTION = 1
1525: AND MTL_CCEOI_VAR_PVT.G_CONTAINER_DISCREPANCY_OPTION = 1 )THEN
1526: IF (l_debug = 1) THEN
1527: mdebug('lpn subinventory move in progress');
1528: END IF;

Line 1525: AND MTL_CCEOI_VAR_PVT.G_CONTAINER_DISCREPANCY_OPTION = 1 )THEN

1521:
1522: -- If discrepancy existed in lpn and no approval needed, then do a subinventory trasfer
1523: IF (l_lpn_discrepancy = 1 AND MTL_CCEOI_VAR_PVT.G_CONTAINER_ENABLED_FLAG = 1
1524: AND MTL_CCEOI_VAR_PVT.G_CONTAINER_ADJUSTMENT_OPTION = 1
1525: AND MTL_CCEOI_VAR_PVT.G_CONTAINER_DISCREPANCY_OPTION = 1 )THEN
1526: IF (l_debug = 1) THEN
1527: mdebug('lpn subinventory move in progress');
1528: END IF;
1529:

Line 1544: , TxnDate => MTL_CCEOI_VAR_PVT.G_count_date

1540: , sub => l_sub
1541: , PUOMQty=> 1
1542: , TxnQty=> 1
1543: , TxnUOM=> null
1544: , TxnDate => MTL_CCEOI_VAR_PVT.G_count_date
1545: , TxnAcctId => MTL_CCEOI_VAR_PVT.G_ADJUST_ACCOUNT_ID
1546: , LotNum => NULL
1547: , LotExpDate => NULL
1548: , rev => NULL

Line 1545: , TxnAcctId => MTL_CCEOI_VAR_PVT.G_ADJUST_ACCOUNT_ID

1541: , PUOMQty=> 1
1542: , TxnQty=> 1
1543: , TxnUOM=> null
1544: , TxnDate => MTL_CCEOI_VAR_PVT.G_count_date
1545: , TxnAcctId => MTL_CCEOI_VAR_PVT.G_ADJUST_ACCOUNT_ID
1546: , LotNum => NULL
1547: , LotExpDate => NULL
1548: , rev => NULL
1549: , locator_id => l_loc_id

Line 1552: , UserId=> MTL_CCEOI_VAR_PVT.G_userid

1548: , rev => NULL
1549: , locator_id => l_loc_id
1550: , TxnRef=> p_interface_rec.reference
1551: , ReasonId=> p_interface_rec.transaction_reason_id
1552: , UserId=> MTL_CCEOI_VAR_PVT.G_userid
1553: , cc_entry_id=> p_interface_rec.cycle_count_header_id
1554: , LoginId => MTL_CCEOI_VAR_PVT.G_LoginId
1555: , TxnProcMode => 1
1556: , TxnHeaderId=>L_txn_header_id

Line 1554: , LoginId => MTL_CCEOI_VAR_PVT.G_LoginId

1550: , TxnRef=> p_interface_rec.reference
1551: , ReasonId=> p_interface_rec.transaction_reason_id
1552: , UserId=> MTL_CCEOI_VAR_PVT.G_userid
1553: , cc_entry_id=> p_interface_rec.cycle_count_header_id
1554: , LoginId => MTL_CCEOI_VAR_PVT.G_LoginId
1555: , TxnProcMode => 1
1556: , TxnHeaderId=>L_txn_header_id
1557: , SerialNum=> NULL
1558: , TxnTempId=> NULL