APPS.OPIMPXIN dependencies on OPI_IDS_PUSH_LOG

Line 3611: FROM opi_ids_push_log

3607:
3608:
3609: CURSOR row_exists IS
3610: SELECT 1
3611: FROM opi_ids_push_log
3612: WHERE IDS_KEY=l_pk;
3613:
3614: CURSOR change_location IS
3615: SELECT physical_location_id

Line 3678: l_query := 'UPDATE opi_ids_push_log SET push_flag = 1,' || p_col_name1

3674:
3675: IF row_exists%rowcount > 0 THEN
3676: --dbms_output.put_line(' > 0');
3677: IF(selector = 1) then
3678: l_query := 'UPDATE opi_ids_push_log SET push_flag = 1,' || p_col_name1
3679: || ' = ' || 'nvl(:p_total1,0) WHERE IDS_KEY = :l_pk ';
3680:
3681: execute immediate l_query using p_total1, l_pk;
3682: ELSE

Line 3683: l_query := 'UPDATE opi_ids_push_log SET push_flag = 1, '

3679: || ' = ' || 'nvl(:p_total1,0) WHERE IDS_KEY = :l_pk ';
3680:
3681: execute immediate l_query using p_total1, l_pk;
3682: ELSE
3683: l_query := 'UPDATE opi_ids_push_log SET push_flag = 1, '
3684: || p_col_name1 || ' = nvl(:p_total1,0),' || p_col_name2 ||
3685: ' = nvl(:p_total2,0), ' || p_col_name3 || ' = nvl( :p_total3,0), '
3686: || p_col_name4 || ' = nvl(:p_total4,0), '|| p_col_name5 ||
3687: ' = nvl(:p_total5,0), '|| p_col_name6 || ' = nvl(:p_total6,0) '

Line 3695: l_query := 'INSERT INTO opi_ids_push_log(IDS_KEY,trx_date,organization_id,Push_flag';

3691: END IF;
3692: ELSE
3693: --dbms_output.put_line('<0, not exist');
3694:
3695: l_query := 'INSERT INTO opi_ids_push_log(IDS_KEY,trx_date,organization_id,Push_flag';
3696:
3697: l_query := l_query || ', cost_group_id , inventory_item_id, revision, lot_number';
3698: l_query := l_query||', subinventory_code, locator_id, project_locator_id, item_status';
3699: l_query := l_query||', item_type, base_uom';