APPS.INV_SUB_CG_UTIL dependencies on INV_SUB_CG_UTIL

Line 1: PACKAGE BODY INV_SUB_CG_UTIL AS

1: PACKAGE BODY INV_SUB_CG_UTIL AS
2: /* $Header: INVSBCGB.pls 120.1 2005/06/15 14:56:29 appldev $ */
3:
4: /*
5: ** -------------------------------------------------------------------------

Line 30: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_SUB_CG_UTIL';

26: ** . x_return_status is set to error when an error(such as SQL error)
27: ** occurs.
28: ** --------------------------------------------------------------------------
29: */
30: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_SUB_CG_UTIL';
31:
32: function validate_cg_update (
33: x_return_status OUT NOCOPY VARCHAR2
34: , x_msg_count OUT NOCOPY NUMBER

Line 775: , x_sub_tbl OUT NOCOPY inv_sub_cg_util.sub_rec_tbl

771: procedure get_subs_from_cg(
772: x_return_status OUT NOCOPY VARCHAR2
773: , x_msg_count OUT NOCOPY NUMBER
774: , x_msg_data OUT NOCOPY VARCHAR2
775: , x_sub_tbl OUT NOCOPY inv_sub_cg_util.sub_rec_tbl
776: , x_count OUT NOCOPY NUMBER
777: , p_cost_group_id IN NUMBER)
778: is
779: cursor subinventory_cursor

Line 869: , x_org_tbl OUT NOCOPY inv_sub_cg_util.org_rec_tbl

865: procedure get_orgs_from_cg(
866: x_return_status OUT NOCOPY VARCHAR2
867: , x_msg_count OUT NOCOPY NUMBER
868: , x_msg_data OUT NOCOPY VARCHAR2
869: , x_org_tbl OUT NOCOPY inv_sub_cg_util.org_rec_tbl
870: , x_count OUT NOCOPY NUMBER
871: , p_cost_group_id IN NUMBER)
872: is
873: cursor org_cursor

Line 1133: l_sub_tbl inv_sub_cg_util.sub_rec_tbl;

1129: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1130: l_msg_count number;
1131: l_msg_data varchar2(240);
1132:
1133: l_sub_tbl inv_sub_cg_util.sub_rec_tbl;
1134: l_count number;
1135: begin
1136: x_return_status := fnd_api.g_ret_sts_success;
1137:

Line 1144: inv_sub_cg_util.get_subs_from_cg(

1140: --
1141: -- Get the subinventories that have the passed cost group as
1142: -- the default cost group
1143: --
1144: inv_sub_cg_util.get_subs_from_cg(
1145: x_return_status => l_return_status
1146: , x_msg_count => l_msg_count
1147: , x_msg_data => l_msg_data
1148: , x_sub_tbl => l_sub_tbl

Line 1166: inv_sub_cg_util.update_sub_accounts (

1162: --
1163: -- Synchronize the subinventory accounts with those of the
1164: -- passed cost group.
1165: --
1166: inv_sub_cg_util.update_sub_accounts (
1167: x_return_status => l_return_status
1168: , x_msg_count => l_msg_count
1169: , x_msg_data => l_msg_data
1170: , p_cost_group_id => p_cost_group_id

Line 1259: l_org_tbl inv_sub_cg_util.org_rec_tbl;

1255: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1256: l_msg_count number;
1257: l_msg_data varchar2(240);
1258:
1259: l_org_tbl inv_sub_cg_util.org_rec_tbl;
1260: l_count number;
1261: begin
1262: x_return_status := fnd_api.g_ret_sts_success;
1263:

Line 1270: inv_sub_cg_util.get_orgs_from_cg(

1266: --
1267: -- Get the organizations that have the passed cost group as
1268: -- the default cost group
1269: --
1270: inv_sub_cg_util.get_orgs_from_cg(
1271: x_return_status => l_return_status
1272: , x_msg_count => l_msg_count
1273: , x_msg_data => l_msg_data
1274: , x_org_tbl => l_org_tbl

Line 1292: inv_sub_cg_util.update_org_accounts (

1288: --
1289: -- Synchronize the organization accounts with those of the
1290: -- passed cost group.
1291: --
1292: inv_sub_cg_util.update_org_accounts (
1293: x_return_status => l_return_status
1294: , x_msg_count => l_msg_count
1295: , x_msg_data => l_msg_data
1296: , p_cost_group_id => p_cost_group_id

Line 1351: end INV_SUB_CG_UTIL;

1347: );
1348:
1349: end find_update_orgs_accounts;
1350:
1351: end INV_SUB_CG_UTIL;