APPS.PSB_DEFAULTS_PVT dependencies on PSB_DEFAULTS

Line 1: PACKAGE BODY PSB_DEFAULTS_PVT AS

1: PACKAGE BODY PSB_DEFAULTS_PVT AS
2: /* $Header: PSBVPDFB.pls 120.3 2004/11/30 14:18:26 shtripat ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PSB_DEFAULTS_PVT';
5:

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

1: PACKAGE BODY PSB_DEFAULTS_PVT AS
2: /* $Header: PSBVPDFB.pls 120.3 2004/11/30 14:18:26 shtripat ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'PSB_DEFAULTS_PVT';
5:
6: /* ----------------------------------------------------------------------- */
7:
8: PROCEDURE INSERT_ROW

Line 40: select ROWID from psb_defaults

36: l_api_version CONSTANT NUMBER := 1.0;
37: l_row_id varchar2(40);
38: --
39: cursor c1 is
40: select ROWID from psb_defaults
41: where default_rule_id = p_default_rule_id;
42:
43: BEGIN
44:

Line 71: INSERT INTO psb_defaults

67: p_return_status := FND_API.G_RET_STS_SUCCESS;
68:
69:
70: -- API body
71: INSERT INTO psb_defaults
72: (
73: DEFAULT_RULE_ID ,
74: NAME ,
75: GLOBAL_DEFAULT_FLAG ,

Line 221: UPDATE psb_defaults SET

217:
218: p_return_status := FND_API.G_RET_STS_SUCCESS;
219:
220: -- API body
221: UPDATE psb_defaults SET
222: DEFAULT_RULE_ID = P_DEFAULT_RULE_ID,
223: NAME = P_NAME,
224: GLOBAL_DEFAULT_FLAG = P_GLOBAL_DEFAULT_FLAG,
225: DATA_EXTRACT_ID = P_DATA_EXTRACT_ID,

Line 353: DELETE FROM psb_defaults

349: DELETE FROM psb_default_account_distrs
350: WHERE default_rule_id = p_default_rule_id;
351:
352: -- Check the existence of Non FTE record.
353: DELETE FROM psb_defaults
354: WHERE default_rule_id = p_default_rule_id
355: AND NOT EXISTS(
356: SELECT 1
357: FROM PSB_FTE_RULES_V

Line 369: DELETE FROM psb_defaults

365: WHERE allocation_rule_id = p_entity_id;
366:
367: IF NVL(P_source_form, 'X') = 'F' THEN
368: -- Check the existence of FTE record.
369: DELETE FROM psb_defaults
370: WHERE default_rule_id = p_default_rule_id
371: AND NOT EXISTS(
372: SELECT 1
373: FROM PSB_NON_FTE_RULES_V

Line 386: DELETE FROM psb_defaults

382:
383: DELETE FROM psb_default_account_distrs
384: WHERE default_rule_id = p_default_rule_id;
385:
386: DELETE FROM psb_defaults
387: WHERE default_rule_id = p_default_rule_id;
388: END IF;
389: /*IF (SQL%NOTFOUND) THEN
390: RAISE NO_DATA_FOUND;

Line 475: CURSOR C IS SELECT * FROM psb_defaults

471: l_api_version CONSTANT NUMBER := 1.0;
472: --
473: counter number;
474:
475: CURSOR C IS SELECT * FROM psb_defaults
476: WHERE rowid = p_row_id
477: FOR UPDATE of default_rule_id NOWAIT;
478: Recinfo C%ROWTYPE;
479:

Line 649: FROM psb_defaults

645: l_tmp VARCHAR2(1);
646:
647: CURSOR c IS
648: SELECT '1'
649: FROM psb_defaults
650: WHERE name = p_name
651: AND ( (p_default_rule_id IS NULL)
652: OR ( default_rule_id <> p_default_rule_id) )
653: AND (data_extract_id = p_data_extract_id);

Line 676: -- Checking the psb_defaults table for uniqueness.

672: --
673: p_return_status := FND_API.G_RET_STS_SUCCESS ;
674: --
675:
676: -- Checking the psb_defaults table for uniqueness.
677: OPEN c;
678: FETCH c INTO l_tmp;
679:
680: --

Line 753: FROM psb_defaults

749: l_tmp varchar2(10);
750:
751: CURSOR c IS
752: SELECT (1)
753: FROM psb_defaults
754: WHERE data_extract_id = p_data_extract_id
755: AND global_default_flag = p_global_default_flag
756: AND ( (p_row_id IS NULL)
757: OR ( rowid <> p_row_id) );

Line 780: -- Checking the psb_defaults table for uniqueness.

776: --
777: p_return_status := FND_API.G_RET_STS_SUCCESS ;
778: --
779:
780: -- Checking the psb_defaults table for uniqueness.
781: OPEN c;
782: FETCH c INTO l_tmp;
783:
784: --

Line 936: END PSB_DEFAULTS_PVT;

932: --
933: END Check_References;
934:
935:
936: END PSB_DEFAULTS_PVT;