APPS.PSB_WS_DISTRIBUTION_RULES_PVT dependencies on PSB_WS_DISTRIBUTION_RULES

Line 1: PACKAGE BODY PSB_WS_Distribution_Rules_PVT AS

1: PACKAGE BODY PSB_WS_Distribution_Rules_PVT AS
2: /* $Header: PSBVWDRB.pls 120.2 2005/07/13 11:30:49 shtripat ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PSB_WS_Distribution_Rules_PVT';
5:

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PSB_WS_Distribution_Rules_PVT';

1: PACKAGE BODY PSB_WS_Distribution_Rules_PVT AS
2: /* $Header: PSBVWDRB.pls 120.2 2005/07/13 11:30:49 shtripat ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PSB_WS_Distribution_Rules_PVT';
5:
6: g_chr10 CONSTANT VARCHAR2(1) := FND_GLOBAL.Newline;
7:
8: G_DBUG VARCHAR2(2000) := 'start';

Line 705: FROM psb_ws_distribution_rules

701: l_tmp VARCHAR2(1);
702:
703: CURSOR c IS
704: SELECT '1'
705: FROM psb_ws_distribution_rules
706: WHERE name = p_name
707: AND ( (p_Row_Id IS NULL)
708: OR (RowId <> p_Row_Id) );
709: BEGIN

Line 961: FROM psb_ws_distribution_rules

957: IS
958:
959: CURSOR C IS
960: SELECT rowid
961: FROM psb_ws_distribution_rules
962: WHERE distribution_rule_id = p_distribution_rule_id ;
963:
964: --
965: P_LAST_UPDATE_DATE DATE;

Line 1012: INSERT INTO psb_ws_distribution_rules

1008: raise FND_API.G_EXC_ERROR;
1009: end if;
1010: --
1011:
1012: INSERT INTO psb_ws_distribution_rules
1013: ( distribution_rule_id,
1014: name,
1015: budget_group_id,
1016: creation_date,

Line 1134: DELETE psb_ws_distribution_rules

1130: END IF;
1131: --
1132: -- Deleting the record in psb_ws_distribution_rule_lines and rules.
1133: --
1134: DELETE psb_ws_distribution_rules
1135: WHERE distribution_rule_id = p_distribution_rule_id;
1136:
1137: DELETE psb_ws_distribution_rule_lines
1138: WHERE distribution_rule_id = p_distribution_rule_id;

Line 1254: SELECT psb_ws_distribution_rules_s.NEXTVAL

1250: l_return_status := FND_API.G_RET_STS_SUCCESS;
1251: --
1252: -- ... insert distribution rules
1253:
1254: SELECT psb_ws_distribution_rules_s.NEXTVAL
1255: INTO l_dist_rule_id FROM dual;
1256:
1257:
1258: RULES_INSERT_ROW (

Line 1379: END PSB_WS_Distribution_Rules_PVT;

1375: END get_debug;
1376:
1377: /* ----------------------------------------------------------------------- */
1378:
1379: END PSB_WS_Distribution_Rules_PVT;