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.WMS_STRATEGY_PVT dependencies on INV_SQL_BINDING_PVT

Line 1182: inv_sql_binding_pvt.InitBindTables;

1178: -- BUILD DYNAMIC SQL TO FIND STRATEGY --
1179: -- -------------------------------------------------------------------- --
1180:
1181: -- Initialize variables for dynamically bound input parameters
1182: inv_sql_binding_pvt.InitBindTables;
1183:
1184: -- Initialize 'where' and 'from' clause
1185: l_where := null;
1186: l_from := null;

Line 1222: l_identifier := inv_sql_binding_pvt.InitBindVar(l_organization_id);

1218: -- add organization id, to search for assignments set up within the
1219: -- actual organization only
1220: -- Bug 1736590 - Need to look for strategies that are common to
1221: -- all orgs; added -1
1222: l_identifier := inv_sql_binding_pvt.InitBindVar(l_organization_id);
1223: l_where := l_where||'and '||l_table_alias||
1224: '.ORGANIZATION_ID IN (' ||l_identifier|| ', -1)
1225: ';
1226:

Line 1228: l_identifier := inv_sql_binding_pvt.InitBindVar(l_object_id);

1224: '.ORGANIZATION_ID IN (' ||l_identifier|| ', -1)
1225: ';
1226:
1227: -- add object id restriction
1228: l_identifier := inv_sql_binding_pvt.InitBindVar(l_object_id);
1229: l_where := l_where||'and '||l_table_alias||'.OBJECT_ID = '||
1230: l_identifier|| '
1231: ';
1232:

Line 1234: l_identifier := inv_sql_binding_pvt.InitBindVar(p_type_code);

1230: l_identifier|| '
1231: ';
1232:
1233: -- add type code restriction
1234: l_identifier := inv_sql_binding_pvt.InitBindVar(p_type_code);
1235: l_where := l_where||'and '||l_table_alias||
1236: '.STRATEGY_TYPE_CODE = '||l_identifier|| '
1237: ';
1238:

Line 1259: l_identifier := inv_sql_binding_pvt.InitBindVar(p_type_code);

1255: end if;
1256:
1257: -- join last DB object with Key Identifiers
1258: if l_db_object_id = 1000 then
1259: l_identifier := inv_sql_binding_pvt.InitBindVar(p_type_code);
1260: l_where :='and '||l_table_alias||'.TYPE_CODE = '||l_identifier||'
1261: '||l_where;
1262: l_identifier:=inv_sql_binding_pvt.InitBindVar(p_transaction_temp_id);
1263: l_where := 'where '||l_table_alias||'.LINE_ID = '||

Line 1262: l_identifier:=inv_sql_binding_pvt.InitBindVar(p_transaction_temp_id);

1258: if l_db_object_id = 1000 then
1259: l_identifier := inv_sql_binding_pvt.InitBindVar(p_type_code);
1260: l_where :='and '||l_table_alias||'.TYPE_CODE = '||l_identifier||'
1261: '||l_where;
1262: l_identifier:=inv_sql_binding_pvt.InitBindVar(p_transaction_temp_id);
1263: l_where := 'where '||l_table_alias||'.LINE_ID = '||
1264: l_identifier||'
1265: '||l_where;
1266: l_last_object_found := TRUE;

Line 1269: l_identifier := inv_sql_binding_pvt.InitBindVar(p_transaction_temp_id);

1265: '||l_where;
1266: l_last_object_found := TRUE;
1267: -- for cost groups
1268: elsif l_db_object_id = 40 then -- wms_cost_group_input_v
1269: l_identifier := inv_sql_binding_pvt.InitBindVar(p_transaction_temp_id);
1270: l_where := 'where '||l_table_alias||'.LINE_ID = '||
1271: l_identifier||'
1272: '||l_where;
1273: l_last_object_found := TRUE;

Line 1291: inv_sql_binding_pvt.GetConversionString ( l_data_type_code

1287: ,l_parent_table_alias;
1288: exit when conditions%notfound;
1289:
1290: -- find out, if data type conversion is needed
1291: inv_sql_binding_pvt.GetConversionString ( l_data_type_code
1292: ,l_parent_data_type_code
1293: ,l_left_part_conv_fct
1294: ,l_right_part_conv_fct );
1295:

Line 1345: inv_sql_binding_pvt.ShowBindVars;

1341: log_event(l_api_name, 'Dynamic SQL STMT for Stg Search Order', l_stmt);
1342: End if;
1343:
1344: --Wms_re_common_pvt.ShowSQL(l_stmt);
1345: inv_sql_binding_pvt.ShowBindVars;
1346:
1347: -- 2nd step: get a cursor and parse the SQL statement
1348: l_cursor := dbms_sql.open_cursor;
1349: dbms_sql.parse( l_cursor, l_stmt, dbms_sql.native );

Line 1352: inv_sql_binding_pvt.BindVars(l_cursor);

1348: l_cursor := dbms_sql.open_cursor;
1349: dbms_sql.parse( l_cursor, l_stmt, dbms_sql.native );
1350:
1351: -- 3rd step: bind input variables
1352: inv_sql_binding_pvt.BindVars(l_cursor);
1353:
1354: -- 4th step: define output column
1355: dbms_sql.define_column(l_cursor, 1, l_strategy_id);
1356: dbms_sql.define_column(l_cursor, 2, l_pk1_value,150);

Line 1455: inv_sql_binding_pvt.InitBindTables;

1451: END IF;
1452: end if;
1453: x_strategy_id := l_strategy_id;
1454: -- Clean up variables for dynamically bound input parameters
1455: inv_sql_binding_pvt.InitBindTables;
1456:
1457: -- Standard call to get message count and if count is 1, get message info
1458: fnd_msg_pub.count_and_get( p_count => x_msg_count
1459: ,p_data => x_msg_data );

Line 1495: inv_sql_binding_pvt.InitBindTables;

1491: inv_pp_debug.send_last_error_position;
1492: END IF;
1493: -- end of debugging section
1494: --
1495: inv_sql_binding_pvt.InitBindTables;
1496: x_return_status := fnd_api.g_ret_sts_error;
1497: fnd_msg_pub.count_and_get( p_count => x_msg_count
1498: ,p_data => x_msg_data );
1499: If (g_debug = 1) then

Line 1522: inv_sql_binding_pvt.InitBindTables;

1518: inv_pp_debug.send_last_error_position;
1519: END IF;
1520: -- end of debugging section
1521: --
1522: inv_sql_binding_pvt.InitBindTables;
1523: x_return_status := fnd_api.g_ret_sts_unexp_error;
1524: fnd_msg_pub.count_and_get( p_count => x_msg_count
1525: ,p_data => x_msg_data );
1526: If (g_debug = 1) then

Line 1549: inv_sql_binding_pvt.InitBindTables;

1545: inv_pp_debug.send_last_error_position;
1546: END IF;
1547: -- end of debugging section
1548: --
1549: inv_sql_binding_pvt.InitBindTables;
1550: if input%isopen then
1551: close input;
1552: end if;
1553: if hierarchy%isopen then