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 4982: UPDATE wsm_lot_split_merges_interface

4978: BEGIN
4979: l_stmt_num := 10;
4980:
4981: IF p_group_id is NOT NULL THEN
4982: UPDATE wsm_lot_split_merges_interface
4983: SET PROCESS_STATUS = COMPLETE
4984: , ERROR_MESSAGE = NULL
4985: WHERE PROCESS_STATUS =PENDING
4986: AND GROUP_ID = p_group_id

Line 4990: UPDATE wsm_lot_split_merges_interface

4986: AND GROUP_ID = p_group_id
4987: AND header_id=p_header_id;
4988: ELSE
4989:
4990: UPDATE wsm_lot_split_merges_interface
4991: SET PROCESS_STATUS = COMPLETE
4992: , ERROR_MESSAGE = NULL
4993: WHERE PROCESS_STATUS = PENDING
4994: AND header_ID = p_header_id;

Line 5069: FROM wsm_lot_split_merges_interface

5065: request_id ,
5066: program_application_id ,
5067: program_id ,
5068: program_update_date
5069: FROM wsm_lot_split_merges_interface
5070: WHERE header_id = p_header_id
5071: and process_status=COMPLETE;
5072:
5073: l_stmt_num :=30;

Line 5146: wsm_lot_split_merges_interface h

5142: s.attribute13,
5143: s.attribute14,
5144: s.attribute15
5145: FROM wsm_starting_lots_interface s,
5146: wsm_lot_split_merges_interface h
5147: WHERE h.header_id = p_header_id
5148: and s.header_id = h.header_id;
5149:
5150:

Line 5226: , wsm_lot_split_merges_interface h

5222: r.attribute13,
5223: r.attribute14,
5224: r.attribute15
5225: FROM wsm_resulting_lots_interface r
5226: , wsm_lot_split_merges_interface h
5227: WHERE h.header_id = p_header_id
5228: and r.header_id = h.header_id;
5229:
5230: /*Bug 4779518 fix: don't commit for online mode, it commits rows in mmtt, base tables, etc.*/

Line 5269: UPDATE wsm_lot_split_merges_interface

5265: -- IF p_group_id is NOT NULL THEN -- bugfix 2449452 : not needed since its enough to use header_id parameter.
5266:
5267: l_stmt_num := 10;
5268:
5269: UPDATE wsm_lot_split_merges_interface
5270:
5271: SET PROCESS_STATUS = ERROR
5272: /*BA#IIIP*/
5273: , error_message = p_message

Line 5296: FROM wsm_lot_split_merges_interface

5292: INSERT INTO WSM_INTERFACE_ERRORS(header_id,message ,
5293: creation_date, last_update_date, last_updated_by, created_by)
5294: SELECT transaction_id,p_message, sysdate, sysdate,
5295: last_updated_by, created_by
5296: FROM wsm_lot_split_merges_interface
5297: WHERE PROCESS_STATUS = ERROR
5298: AND GROUP_ID = p_group_id
5299: and transaction_id=p_header_id;
5300: