APPS.INV_DIAG_MSN dependencies on INV_DIAG_MSN

Line 1: package body INV_DIAG_MSN as

1: package body INV_DIAG_MSN as
2: /* $Header: INVDS01B.pls 120.0.12000000.1 2007/06/22 01:22:39 musinha noship $ */
3: PROCEDURE init is
4: BEGIN
5: null;

Line 87: delete from inv_diag_msn_temp;

83: sqltxt := 'select * from ('||sqltxt||') WHERE ROWNUM <= '||row_limit;
84:
85: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Serial Status');
86:
87: delete from inv_diag_msn_temp;
88:
89: insert into inv_diag_msn_temp
90: (serial_number
91: ,org_id

Line 89: insert into inv_diag_msn_temp

85: dummy_num:= JTF_DIAGNOSTIC_COREAPI.display_sql(sqltxt, 'Serial Status');
86:
87: delete from inv_diag_msn_temp;
88:
89: insert into inv_diag_msn_temp
90: (serial_number
91: ,org_id
92: ,inventory_item_id)
93: select distinct serial_number, current_organization_id,inventory_item_id