APPS.CN_RULESETS_PKG dependencies on CN_RULESETS

Line 1: PACKAGE BODY cn_rulesets_pkg AS

1: PACKAGE BODY cn_rulesets_pkg AS
2: -- $Header: cnrulstb.pls 120.3 2005/06/28 22:53:49 appldev ship $
3:
4: -- Function Name: Sync_ruleset
5: -- Purpose

Line 8: PROCEDURE Sync_ruleset(x_ruleset_id_in cn_rulesets.ruleset_id%TYPE,

4: -- Function Name: Sync_ruleset
5: -- Purpose
6: -- This function is used to synchronize a ruleset
7:
8: PROCEDURE Sync_ruleset(x_ruleset_id_in cn_rulesets.ruleset_id%TYPE,
9: x_ruleset_status_in IN OUT NOCOPY cn_rulesets.ruleset_status%TYPE,
10: x_org_id cn_rulesets.org_id%TYPE) IS
11: CURSOR get_ruleset_data IS
12: SELECT *

Line 9: x_ruleset_status_in IN OUT NOCOPY cn_rulesets.ruleset_status%TYPE,

5: -- Purpose
6: -- This function is used to synchronize a ruleset
7:
8: PROCEDURE Sync_ruleset(x_ruleset_id_in cn_rulesets.ruleset_id%TYPE,
9: x_ruleset_status_in IN OUT NOCOPY cn_rulesets.ruleset_status%TYPE,
10: x_org_id cn_rulesets.org_id%TYPE) IS
11: CURSOR get_ruleset_data IS
12: SELECT *
13: FROM cn_rulesets

Line 10: x_org_id cn_rulesets.org_id%TYPE) IS

6: -- This function is used to synchronize a ruleset
7:
8: PROCEDURE Sync_ruleset(x_ruleset_id_in cn_rulesets.ruleset_id%TYPE,
9: x_ruleset_status_in IN OUT NOCOPY cn_rulesets.ruleset_status%TYPE,
10: x_org_id cn_rulesets.org_id%TYPE) IS
11: CURSOR get_ruleset_data IS
12: SELECT *
13: FROM cn_rulesets
14: WHERE ruleset_id = x_ruleset_id_in and

Line 13: FROM cn_rulesets

9: x_ruleset_status_in IN OUT NOCOPY cn_rulesets.ruleset_status%TYPE,
10: x_org_id cn_rulesets.org_id%TYPE) IS
11: CURSOR get_ruleset_data IS
12: SELECT *
13: FROM cn_rulesets
14: WHERE ruleset_id = x_ruleset_id_in and
15: org_id=x_org_id;
16:
17: l_get_ruleset_data_rec get_ruleset_data%ROWTYPE;

Line 56: PROCEDURE Unsync_ruleset(x_ruleset_id_in cn_rulesets.ruleset_id%TYPE,

52: -- Function Name: Unsync_ruleset
53: -- Purpose
54: -- This function is used to unsynchronize a ruleset
55:
56: PROCEDURE Unsync_ruleset(x_ruleset_id_in cn_rulesets.ruleset_id%TYPE,
57: x_ruleset_status_in IN OUT NOCOPY cn_rulesets.ruleset_status%TYPE,
58: x_org_id cn_rulesets.org_id%TYPE) IS
59:
60: CURSOR get_ruleset_data IS

Line 57: x_ruleset_status_in IN OUT NOCOPY cn_rulesets.ruleset_status%TYPE,

53: -- Purpose
54: -- This function is used to unsynchronize a ruleset
55:
56: PROCEDURE Unsync_ruleset(x_ruleset_id_in cn_rulesets.ruleset_id%TYPE,
57: x_ruleset_status_in IN OUT NOCOPY cn_rulesets.ruleset_status%TYPE,
58: x_org_id cn_rulesets.org_id%TYPE) IS
59:
60: CURSOR get_ruleset_data IS
61: SELECT *

Line 58: x_org_id cn_rulesets.org_id%TYPE) IS

54: -- This function is used to unsynchronize a ruleset
55:
56: PROCEDURE Unsync_ruleset(x_ruleset_id_in cn_rulesets.ruleset_id%TYPE,
57: x_ruleset_status_in IN OUT NOCOPY cn_rulesets.ruleset_status%TYPE,
58: x_org_id cn_rulesets.org_id%TYPE) IS
59:
60: CURSOR get_ruleset_data IS
61: SELECT *
62: FROM cn_rulesets

Line 62: FROM cn_rulesets

58: x_org_id cn_rulesets.org_id%TYPE) IS
59:
60: CURSOR get_ruleset_data IS
61: SELECT *
62: FROM cn_rulesets
63: WHERE ruleset_id = x_ruleset_id_in and org_id=x_org_id;
64:
65: l_get_ruleset_data_rec get_ruleset_data%ROWTYPE;
66: BEGIN

Line 94: END cn_rulesets_pkg;

90: CLOSE get_ruleset_data;
91: --COMMIT;
92: END Unsync_ruleset;
93:
94: END cn_rulesets_pkg;