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 1220: inv_sql_binding_pvt.InitBindTables;

1216: -- BUILD DYNAMIC SQL TO FIND STRATEGY --
1217: -- -------------------------------------------------------------------- --
1218:
1219: -- Initialize variables for dynamically bound input parameters
1220: inv_sql_binding_pvt.InitBindTables;
1221:
1222: -- Initialize 'where' and 'from' clause
1223: l_where := null;
1224: l_from := null;

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

1256: -- add organization id, to search for assignments set up within the
1257: -- actual organization only
1258: -- Bug 1736590 - Need to look for strategies that are common to
1259: -- all orgs; added -1
1260: l_identifier := inv_sql_binding_pvt.InitBindVar(l_organization_id);
1261: l_where := l_where||'and '||l_table_alias||
1262: '.ORGANIZATION_ID IN (' ||l_identifier|| ', -1)
1263: ';
1264:

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

1262: '.ORGANIZATION_ID IN (' ||l_identifier|| ', -1)
1263: ';
1264:
1265: -- add object id restriction
1266: l_identifier := inv_sql_binding_pvt.InitBindVar(l_object_id);
1267: l_where := l_where||'and '||l_table_alias||'.OBJECT_ID = '||
1268: l_identifier|| '
1269: ';
1270:

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

1268: l_identifier|| '
1269: ';
1270:
1271: -- add type code restriction
1272: l_identifier := inv_sql_binding_pvt.InitBindVar(p_type_code);
1273: l_where := l_where||'and '||l_table_alias||
1274: '.STRATEGY_TYPE_CODE = '||l_identifier|| '
1275: ';
1276:

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

1293: end if;
1294:
1295: -- join last DB object with Key Identifiers
1296: if l_db_object_id = 1000 then
1297: l_identifier := inv_sql_binding_pvt.InitBindVar(p_type_code);
1298: l_where :='and '||l_table_alias||'.TYPE_CODE = '||l_identifier||'
1299: '||l_where;
1300: l_identifier:=inv_sql_binding_pvt.InitBindVar(p_transaction_temp_id);
1301: l_where := 'where '||l_table_alias||'.LINE_ID = '||

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

1296: if l_db_object_id = 1000 then
1297: l_identifier := inv_sql_binding_pvt.InitBindVar(p_type_code);
1298: l_where :='and '||l_table_alias||'.TYPE_CODE = '||l_identifier||'
1299: '||l_where;
1300: l_identifier:=inv_sql_binding_pvt.InitBindVar(p_transaction_temp_id);
1301: l_where := 'where '||l_table_alias||'.LINE_ID = '||
1302: l_identifier||'
1303: '||l_where;
1304: l_last_object_found := TRUE;

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

1303: '||l_where;
1304: l_last_object_found := TRUE;
1305: -- for cost groups
1306: elsif l_db_object_id = 40 then -- wms_cost_group_input_v
1307: l_identifier := inv_sql_binding_pvt.InitBindVar(p_transaction_temp_id);
1308: l_where := 'where '||l_table_alias||'.LINE_ID = '||
1309: l_identifier||'
1310: '||l_where;
1311: l_last_object_found := TRUE;

Line 1329: inv_sql_binding_pvt.GetConversionString ( l_data_type_code

1325: ,l_parent_table_alias;
1326: exit when conditions%notfound;
1327:
1328: -- find out, if data type conversion is needed
1329: inv_sql_binding_pvt.GetConversionString ( l_data_type_code
1330: ,l_parent_data_type_code
1331: ,l_left_part_conv_fct
1332: ,l_right_part_conv_fct );
1333:

Line 1383: inv_sql_binding_pvt.ShowBindVars;

1379: log_event(l_api_name, 'Dynamic SQL STMT for Stg Search Order', l_stmt);
1380: End if;
1381:
1382: --Wms_re_common_pvt.ShowSQL(l_stmt);
1383: inv_sql_binding_pvt.ShowBindVars;
1384:
1385: -- 2nd step: get a cursor and parse the SQL statement
1386: l_cursor := dbms_sql.open_cursor;
1387: dbms_sql.parse( l_cursor, l_stmt, dbms_sql.native );

Line 1390: inv_sql_binding_pvt.BindVars(l_cursor);

1386: l_cursor := dbms_sql.open_cursor;
1387: dbms_sql.parse( l_cursor, l_stmt, dbms_sql.native );
1388:
1389: -- 3rd step: bind input variables
1390: inv_sql_binding_pvt.BindVars(l_cursor);
1391:
1392: -- 4th step: define output column
1393: dbms_sql.define_column(l_cursor, 1, l_strategy_id);
1394: dbms_sql.define_column(l_cursor, 2, l_pk1_value,150);

Line 1493: inv_sql_binding_pvt.InitBindTables;

1489: END IF;
1490: end if;
1491: x_strategy_id := l_strategy_id;
1492: -- Clean up variables for dynamically bound input parameters
1493: inv_sql_binding_pvt.InitBindTables;
1494:
1495: -- Standard call to get message count and if count is 1, get message info
1496: fnd_msg_pub.count_and_get( p_count => x_msg_count
1497: ,p_data => x_msg_data );

Line 1533: inv_sql_binding_pvt.InitBindTables;

1529: inv_pp_debug.send_last_error_position;
1530: END IF;
1531: -- end of debugging section
1532: --
1533: inv_sql_binding_pvt.InitBindTables;
1534: x_return_status := fnd_api.g_ret_sts_error;
1535: fnd_msg_pub.count_and_get( p_count => x_msg_count
1536: ,p_data => x_msg_data );
1537: If (g_debug = 1) then

Line 1560: inv_sql_binding_pvt.InitBindTables;

1556: inv_pp_debug.send_last_error_position;
1557: END IF;
1558: -- end of debugging section
1559: --
1560: inv_sql_binding_pvt.InitBindTables;
1561: x_return_status := fnd_api.g_ret_sts_unexp_error;
1562: fnd_msg_pub.count_and_get( p_count => x_msg_count
1563: ,p_data => x_msg_data );
1564: If (g_debug = 1) then

Line 1587: inv_sql_binding_pvt.InitBindTables;

1583: inv_pp_debug.send_last_error_position;
1584: END IF;
1585: -- end of debugging section
1586: --
1587: inv_sql_binding_pvt.InitBindTables;
1588: if input%isopen then
1589: close input;
1590: end if;
1591: if hierarchy%isopen then