DBA Data[Home] [Help]

APPS.CSI_WIP_TRXS_PKG dependencies on CSI_ITEM_INSTANCE_PUB

Line 471: p_pkg_name => 'csi_item_instance_pub',

467: FROM csi_item_instances
468: WHERE instance_id = p_instance_id;
469:
470: api_log(
471: p_pkg_name => 'csi_item_instance_pub',
472: p_api_name => 'update_item_instance');
473:
474: debug(' instance_id : '||l_u_instance_rec.instance_id);
475: debug(' quantity : '||l_u_instance_rec.quantity);

Line 479: csi_item_instance_pub.update_item_instance(

475: debug(' quantity : '||l_u_instance_rec.quantity);
476: debug(' instance_ovn : '||l_u_instance_rec.object_version_number);
477:
478: -- update item_instance
479: csi_item_instance_pub.update_item_instance(
480: p_api_version => 1.0,
481: p_commit => fnd_api.g_false,
482: p_init_msg_list => fnd_api.g_true,
483: p_validation_level => fnd_api.g_valid_level_full,

Line 544: p_pkg_name => 'csi_item_instance_pub',

540: FROM csi_item_instances
541: WHERE instance_id = l_u_instance_rec.instance_id;
542:
543: api_log(
544: p_pkg_name => 'csi_item_instance_pub',
545: p_api_name => 'update_item_instance');
546:
547: debug(' instance_id : '||l_u_instance_rec.instance_id);
548: debug(' quantity : '||l_u_instance_rec.quantity);

Line 552: csi_item_instance_pub.update_item_instance(

548: debug(' quantity : '||l_u_instance_rec.quantity);
549: debug(' instance_ovn : '||l_u_instance_rec.object_version_number);
550:
551: -- update item_instance
552: csi_item_instance_pub.update_item_instance(
553: p_api_version => 1.0,
554: p_commit => fnd_api.g_false,
555: p_init_msg_list => fnd_api.g_true,
556: p_validation_level => fnd_api.g_valid_level_full,

Line 628: p_pkg_name => 'csi_item_instance_pub',

624:
625: l_g_instance_rec.instance_id := p_instance_id;
626:
627: api_log(
628: p_pkg_name => 'csi_item_instance_pub',
629: p_api_name => 'get_item_instance_details');
630:
631: -- get the instance party and party account info
632: csi_item_instance_pub.get_item_instance_details(

Line 632: csi_item_instance_pub.get_item_instance_details(

628: p_pkg_name => 'csi_item_instance_pub',
629: p_api_name => 'get_item_instance_details');
630:
631: -- get the instance party and party account info
632: csi_item_instance_pub.get_item_instance_details(
633: p_api_version => 1.0,
634: p_commit => fnd_api.g_false,
635: p_init_msg_list => fnd_api.g_true,
636: p_validation_level => fnd_api.g_valid_level_full,

Line 718: p_pkg_name => 'csi_item_instance_pub',

714: END IF;
715:
716: -- create a new instance for the decremented qty
717: api_log(
718: p_pkg_name => 'csi_item_instance_pub',
719: p_api_name => 'create_item_instance');
720:
721: csi_item_instance_pub.create_item_instance(
722: p_api_version => 1.0,

Line 721: csi_item_instance_pub.create_item_instance(

717: api_log(
718: p_pkg_name => 'csi_item_instance_pub',
719: p_api_name => 'create_item_instance');
720:
721: csi_item_instance_pub.create_item_instance(
722: p_api_version => 1.0,
723: p_commit => fnd_api.g_false,
724: p_init_msg_list => fnd_api.g_true,
725: p_validation_level => fnd_api.g_valid_level_full,

Line 1032: p_pkg_name => 'csi_item_instance_pub');

1028: csi_t_gen_utility_pvt.dump_instance_query_rec(l_inst_query_rec);
1029:
1030: api_log(
1031: p_api_name => 'get_item_instances',
1032: p_pkg_name => 'csi_item_instance_pub');
1033:
1034: csi_item_instance_pub.get_item_instances(
1035: p_api_version => 1.0,
1036: p_commit => fnd_api.g_false,

Line 1034: csi_item_instance_pub.get_item_instances(

1030: api_log(
1031: p_api_name => 'get_item_instances',
1032: p_pkg_name => 'csi_item_instance_pub');
1033:
1034: csi_item_instance_pub.get_item_instances(
1035: p_api_version => 1.0,
1036: p_commit => fnd_api.g_false,
1037: p_init_msg_list => fnd_api.g_true,
1038: p_validation_level => fnd_api.g_valid_level_full,

Line 1294: p_pkg_name => 'csi_item_instance_pub');

1290: l_inst_query_rec.instance_usage_code := 'IN_WIP';
1291:
1292: api_log(
1293: p_api_name => 'get_item_instances',
1294: p_pkg_name => 'csi_item_instance_pub');
1295:
1296: csi_item_instance_pub.get_item_instances(
1297: p_api_version => 1.0,
1298: p_commit => fnd_api.g_false,

Line 1296: csi_item_instance_pub.get_item_instances(

1292: api_log(
1293: p_api_name => 'get_item_instances',
1294: p_pkg_name => 'csi_item_instance_pub');
1295:
1296: csi_item_instance_pub.get_item_instances(
1297: p_api_version => 1.0,
1298: p_commit => fnd_api.g_false,
1299: p_init_msg_list => fnd_api.g_true,
1300: p_validation_level => fnd_api.g_valid_level_full,

Line 1373: p_pkg_name => 'csi_item_instance_pub');

1369: l_inst_query_rec.serial_number := p_serial_number;
1370:
1371: csi_t_gen_utility_pvt.dump_api_info(
1372: p_api_name => 'get_item_instances',
1373: p_pkg_name => 'csi_item_instance_pub');
1374:
1375: csi_item_instance_pub.get_item_instances(
1376: p_api_version => 1.0,
1377: p_commit => fnd_api.g_false,

Line 1375: csi_item_instance_pub.get_item_instances(

1371: csi_t_gen_utility_pvt.dump_api_info(
1372: p_api_name => 'get_item_instances',
1373: p_pkg_name => 'csi_item_instance_pub');
1374:
1375: csi_item_instance_pub.get_item_instances(
1376: p_api_version => 1.0,
1377: p_commit => fnd_api.g_false,
1378: p_init_msg_list => fnd_api.g_true,
1379: p_validation_level => fnd_api.g_valid_level_full,

Line 1494: p_pkg_name => 'csi_item_instance_pub',

1490:
1491: l_g_instance_rec.instance_id := p_instance_id;
1492:
1493: api_log(
1494: p_pkg_name => 'csi_item_instance_pub',
1495: p_api_name => 'get_item_instance_details');
1496:
1497: -- get the instance party and party account info
1498: csi_item_instance_pub.get_item_instance_details(

Line 1498: csi_item_instance_pub.get_item_instance_details(

1494: p_pkg_name => 'csi_item_instance_pub',
1495: p_api_name => 'get_item_instance_details');
1496:
1497: -- get the instance party and party account info
1498: csi_item_instance_pub.get_item_instance_details(
1499: p_api_version => 1.0,
1500: p_commit => fnd_api.g_false,
1501: p_init_msg_list => fnd_api.g_true,
1502: p_validation_level => fnd_api.g_valid_level_full,

Line 1603: p_pkg_name => 'csi_item_instance_pub',

1599: END IF;
1600:
1601: -- create a new instance for the decremented qty
1602: api_log(
1603: p_pkg_name => 'csi_item_instance_pub',
1604: p_api_name => 'create_item_instance');
1605:
1606: csi_item_instance_pub.create_item_instance(
1607: p_api_version => 1.0,

Line 1606: csi_item_instance_pub.create_item_instance(

1602: api_log(
1603: p_pkg_name => 'csi_item_instance_pub',
1604: p_api_name => 'create_item_instance');
1605:
1606: csi_item_instance_pub.create_item_instance(
1607: p_api_version => 1.0,
1608: p_commit => fnd_api.g_false,
1609: p_init_msg_list => fnd_api.g_true,
1610: p_validation_level => fnd_api.g_valid_level_full,

Line 1645: p_pkg_name => 'csi_item_instance_pub',

1641: FROM csi_item_instances
1642: WHERE instance_id = l_u_instance_rec.instance_id;
1643:
1644: api_log(
1645: p_pkg_name => 'csi_item_instance_pub',
1646: p_api_name => 'update_item_instance');
1647:
1648: csi_item_instance_pub.update_item_instance(
1649: p_api_version => 1.0,

Line 1648: csi_item_instance_pub.update_item_instance(

1644: api_log(
1645: p_pkg_name => 'csi_item_instance_pub',
1646: p_api_name => 'update_item_instance');
1647:
1648: csi_item_instance_pub.update_item_instance(
1649: p_api_version => 1.0,
1650: p_commit => fnd_api.g_false,
1651: p_init_msg_list => fnd_api.g_true,
1652: p_validation_level => fnd_api.g_valid_level_full,

Line 1839: p_pkg_name => 'csi_item_instance_pub',

1835:
1836: l_g_instance_rec.instance_id := px_issued_instances(l_ind).instance_id;
1837:
1838: api_log(
1839: p_pkg_name => 'csi_item_instance_pub',
1840: p_api_name => 'get_item_instance_details');
1841:
1842: -- get the instance party and party account info
1843: csi_item_instance_pub.get_item_instance_details(

Line 1843: csi_item_instance_pub.get_item_instance_details(

1839: p_pkg_name => 'csi_item_instance_pub',
1840: p_api_name => 'get_item_instance_details');
1841:
1842: -- get the instance party and party account info
1843: csi_item_instance_pub.get_item_instance_details(
1844: p_api_version => 1.0,
1845: p_commit => fnd_api.g_false,
1846: p_init_msg_list => fnd_api.g_true,
1847: p_validation_level => fnd_api.g_valid_level_full,

Line 1942: p_pkg_name => 'csi_item_instance_pub',

1938: END IF;
1939:
1940: -- create a new instance for the decremented qty
1941: api_log(
1942: p_pkg_name => 'csi_item_instance_pub',
1943: p_api_name => 'create_item_instance');
1944:
1945: csi_item_instance_pub.create_item_instance(
1946: p_api_version => 1.0,

Line 1945: csi_item_instance_pub.create_item_instance(

1941: api_log(
1942: p_pkg_name => 'csi_item_instance_pub',
1943: p_api_name => 'create_item_instance');
1944:
1945: csi_item_instance_pub.create_item_instance(
1946: p_api_version => 1.0,
1947: p_commit => fnd_api.g_false,
1948: p_init_msg_list => fnd_api.g_true,
1949: p_validation_level => fnd_api.g_valid_level_full,

Line 1985: p_pkg_name => 'csi_item_instance_pub',

1981: FROM csi_item_instances
1982: WHERE instance_id = l_u_instance_rec.instance_id;
1983:
1984: api_log(
1985: p_pkg_name => 'csi_item_instance_pub',
1986: p_api_name => 'update_item_instance');
1987:
1988: csi_item_instance_pub.update_item_instance(
1989: p_api_version => 1.0,

Line 1988: csi_item_instance_pub.update_item_instance(

1984: api_log(
1985: p_pkg_name => 'csi_item_instance_pub',
1986: p_api_name => 'update_item_instance');
1987:
1988: csi_item_instance_pub.update_item_instance(
1989: p_api_version => 1.0,
1990: p_commit => fnd_api.g_false,
1991: p_init_msg_list => fnd_api.g_true,
1992: p_validation_level => fnd_api.g_valid_level_full,

Line 4819: csi_item_instance_pub.get_item_instances(

4815:
4816: l_inst_query_rec.inventory_item_id := px_instance_rec.inventory_item_id;
4817: l_inst_query_rec.serial_number := px_instance_rec.serial_number;
4818:
4819: csi_item_instance_pub.get_item_instances(
4820: p_api_version => 1.0,
4821: p_commit => fnd_api.g_false,
4822: p_init_msg_list => fnd_api.g_true,
4823: p_validation_level => fnd_api.g_valid_level_full,

Line 4885: p_pkg_name => 'csi_item_instance_pub',

4881:
4882: csi_t_gen_utility_pvt.dump_instance_query_rec(p_instance_query_rec);
4883:
4884: api_log(
4885: p_pkg_name => 'csi_item_instance_pub',
4886: p_api_name => 'get_item_instances');
4887:
4888: csi_item_instance_pub.get_item_instances(
4889: p_api_version => 1.0,

Line 4888: csi_item_instance_pub.get_item_instances(

4884: api_log(
4885: p_pkg_name => 'csi_item_instance_pub',
4886: p_api_name => 'get_item_instances');
4887:
4888: csi_item_instance_pub.get_item_instances(
4889: p_api_version => 1.0,
4890: p_commit => fnd_api.g_false,
4891: p_init_msg_list => fnd_api.g_true,
4892: p_validation_level => fnd_api.g_valid_level_full,