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.WSMPINVL dependencies on WSM_LOT_SPLIT_MERGES_INTERFACE

Line 141: FROM wsm_lot_split_merges_interface

137: */
138:
139: CURSOR NO_GRP_ID_ROWS IS
140: SELECT header_id
141: FROM wsm_lot_split_merges_interface
142: WHERE group_id IS NULL
143: AND process_status = WSMPINVL.PENDING
144: AND transaction_date <= SYSDATE
145: ORDER BY transaction_date;

Line 151: FROM wsm_lot_split_merges_interface

147: Cursor txns IS
148: SELECT transaction_id, header_id, process_status,
149: transaction_type_id, created_by, transaction_date
150: , organization_id -- bugfix 2832025/2841055: added orgn_id
151: FROM wsm_lot_split_merges_interface
152: WHERE nvl(group_id,-1) = nvl(p_group_id, nvl(group_id,-1) )
153: AND header_id = nvl(p_header_id, header_id)
154: AND process_status = WSMPINVL.PENDING
155: AND transaction_date <= SYSDATE

Line 164: FROM wsm_lot_split_merges_interface

160: --detail please check at where the enter_genealogy_records was being called.
161: Cursor comp_txns IS
162: SELECT transaction_id, header_id, process_status,
163: transaction_type_id, created_by, transaction_date
164: FROM wsm_lot_split_merges_interface
165: WHERE nvl(group_id,-1) = nvl(p_group_id, nvl(group_id,-1) )
166: AND header_id = nvl(p_header_id, header_id)
167: AND process_status = WSMPINVL.COMPLETE
168: AND transaction_date <= SYSDATE

Line 240: UPDATE wsm_lot_split_merges_interface

236: loop
237: fetch no_grp_id_rows into l_header_id;
238: exit when no_grp_id_rows%NOTFOUND;
239:
240: UPDATE wsm_lot_split_merges_interface
241: SET group_id = wsm_lot_sm_ifc_header_s.nextval
242: WHERE header_id = l_header_id
243: RETURNING group_id INTO l_group_id;
244:

Line 517: ** update wsm_lot_split_merges_interface

513: ** into txn.transaction_id
514: ** from dual;
515: **
516: **
517: ** update wsm_lot_split_merges_interface
518: ** set transaction_id = txn.transaction_id
519: ** Where header_id = txn.header_id;
520: */
521:

Line 525: update wsm_lot_split_merges_interface

521:
522: -- begin modification by abedajna for perf. tuning
523:
524: lProcLocation := 130;
525: update wsm_lot_split_merges_interface
526: set transaction_id = wsm_split_merge_transactions_s.nextval
527: Where header_id = txn.header_id
528: returning transaction_id into txn.transaction_id;
529:

Line 1052: FROM wsm_lot_split_merges_interface wlsmi

1048:
1049: BEGIN
1050: SELECT 1
1051: into x_dummy
1052: FROM wsm_lot_split_merges_interface wlsmi
1053: WHERE wlsmi.header_id = p_header_id
1054: AND wlsmi.organization_id = crec.organization_id;
1055:
1056: EXCEPTION when others THEN

Line 1335: FROM wsm_lot_split_merges_interface

1331: /*
1332: BEGIN
1333: SELECT 1
1334: into x_dummy
1335: FROM wsm_lot_split_merges_interface
1336: WHERE transaction_id = p_header_id
1337: AND organization_id = crec.organization_id;
1338: EXCEPTION when others THEN
1339: --fnd_message.set_name('WSM', 'WSM_RESULTING_DIFFERENT');

Line 1565: FROM wsm_lot_split_merges_interface m,

1561: r.locator_id,
1562: r.revision,
1563: r.last_updated_by,
1564: r.created_by
1565: FROM wsm_lot_split_merges_interface m,
1566: wsm_resulting_lots_interface r
1567: WHERE r.header_id = m.header_id
1568: AND m.header_id = p_header_id;
1569:

Line 1803: FROM wsm_lot_split_merges_interface

1799:
1800: BEGIN
1801: SELECT 1
1802: into x_dummy
1803: FROM wsm_lot_split_merges_interface
1804: WHERE header_id = p_header_id
1805: AND organization_id = crec.organization_id;
1806: EXCEPTION when others THEN
1807: fnd_message.set_name('WSM', 'WSM_RESULTING_DIFFERENT');

Line 2429: FROM wsm_lot_split_merges_interface

2425: */
2426:
2427: SELECT transaction_type_id
2428: INTO x_transaction_type_id
2429: FROM wsm_lot_split_merges_interface
2430: WHERE header_id = p_header_id;
2431: BEGIN
2432: SELECT 1
2433: into x_dummy

Line 2711: FROM wsm_lot_split_merges_interface

2707: x_last_updated_by,
2708: x_created_by,
2709: x_reason_id,
2710: x_transaction_date
2711: FROM wsm_lot_split_merges_interface
2712: WHERE header_id = p_header_id;
2713:
2714: -- Check if the org is a valid WSM Org.
2715:

Line 3443: FROM wsm_lot_split_merges_interface

3439:
3440: SELECT reason_id, transaction_reference, organization_id,
3441: transaction_date
3442: INTO x_reason_id, x_reference, x_org_id, x_date
3443: FROM wsm_lot_split_merges_interface
3444: WHERE header_id = p_header_id;
3445:
3446: l_stmt_num :=20;
3447:

Line 5150: UPDATE wsm_lot_split_merges_interface

5146: BEGIN
5147: l_stmt_num := 10;
5148:
5149: IF p_group_id is NOT NULL THEN
5150: UPDATE wsm_lot_split_merges_interface
5151: SET PROCESS_STATUS = COMPLETE
5152: , ERROR_MESSAGE = NULL
5153: WHERE PROCESS_STATUS =PENDING
5154: AND GROUP_ID = p_group_id

Line 5158: UPDATE wsm_lot_split_merges_interface

5154: AND GROUP_ID = p_group_id
5155: AND header_id=p_header_id;
5156: ELSE
5157:
5158: UPDATE wsm_lot_split_merges_interface
5159: SET PROCESS_STATUS = COMPLETE
5160: , ERROR_MESSAGE = NULL
5161: WHERE PROCESS_STATUS = PENDING
5162: AND header_ID = p_header_id;

Line 5237: FROM wsm_lot_split_merges_interface

5233: request_id ,
5234: program_application_id ,
5235: program_id ,
5236: program_update_date
5237: FROM wsm_lot_split_merges_interface
5238: WHERE header_id = p_header_id
5239: and process_status=COMPLETE;
5240:
5241: l_stmt_num :=30;

Line 5314: wsm_lot_split_merges_interface h

5310: s.attribute13,
5311: s.attribute14,
5312: s.attribute15
5313: FROM wsm_starting_lots_interface s,
5314: wsm_lot_split_merges_interface h
5315: WHERE h.header_id = p_header_id
5316: and s.header_id = h.header_id;
5317:
5318:

Line 5394: , wsm_lot_split_merges_interface h

5390: r.attribute13,
5391: r.attribute14,
5392: r.attribute15
5393: FROM wsm_resulting_lots_interface r
5394: , wsm_lot_split_merges_interface h
5395: WHERE h.header_id = p_header_id
5396: and r.header_id = h.header_id;
5397:
5398: /*Bug 4779518 fix: don't commit for online mode, it commits rows in mmtt, base tables, etc.*/

Line 5437: UPDATE wsm_lot_split_merges_interface

5433: -- IF p_group_id is NOT NULL THEN -- bugfix 2449452 : not needed since its enough to use header_id parameter.
5434:
5435: l_stmt_num := 10;
5436:
5437: UPDATE wsm_lot_split_merges_interface
5438:
5439: SET PROCESS_STATUS = ERROR
5440: /*BA#IIIP*/
5441: , error_message = p_message

Line 5464: FROM wsm_lot_split_merges_interface

5460: INSERT INTO WSM_INTERFACE_ERRORS(header_id,message ,
5461: creation_date, last_update_date, last_updated_by, created_by)
5462: SELECT transaction_id,p_message, sysdate, sysdate,
5463: last_updated_by, created_by
5464: FROM wsm_lot_split_merges_interface
5465: WHERE PROCESS_STATUS = ERROR
5466: AND GROUP_ID = p_group_id
5467: and transaction_id=p_header_id;
5468: