24:
25: procedure INSERT_ROW
26: (
27: X_ROWID in out NOCOPY VARCHAR2,
28: X_RULESET_ID in NUMBER := FND_API.G_MISS_NUM,
29: X_RULESET_STATUS in VARCHAR2 := FND_API.G_MISS_CHAR,
30: X_DESTINATION_COLUMN_ID in NUMBER := FND_API.G_MISS_NUM,
31: X_REPOSITORY_ID in NUMBER := FND_API.G_MISS_NUM,
32: X_NAME in VARCHAR2 := FND_API.G_MISS_CHAR,
25: procedure INSERT_ROW
26: (
27: X_ROWID in out NOCOPY VARCHAR2,
28: X_RULESET_ID in NUMBER := FND_API.G_MISS_NUM,
29: X_RULESET_STATUS in VARCHAR2 := FND_API.G_MISS_CHAR,
30: X_DESTINATION_COLUMN_ID in NUMBER := FND_API.G_MISS_NUM,
31: X_REPOSITORY_ID in NUMBER := FND_API.G_MISS_NUM,
32: X_NAME in VARCHAR2 := FND_API.G_MISS_CHAR,
33: x_module_type IN VARCHAR2 := fnd_api.g_miss_char,
26: (
27: X_ROWID in out NOCOPY VARCHAR2,
28: X_RULESET_ID in NUMBER := FND_API.G_MISS_NUM,
29: X_RULESET_STATUS in VARCHAR2 := FND_API.G_MISS_CHAR,
30: X_DESTINATION_COLUMN_ID in NUMBER := FND_API.G_MISS_NUM,
31: X_REPOSITORY_ID in NUMBER := FND_API.G_MISS_NUM,
32: X_NAME in VARCHAR2 := FND_API.G_MISS_CHAR,
33: x_module_type IN VARCHAR2 := fnd_api.g_miss_char,
34: x_start_date IN DATE := fnd_api.g_miss_date,
27: X_ROWID in out NOCOPY VARCHAR2,
28: X_RULESET_ID in NUMBER := FND_API.G_MISS_NUM,
29: X_RULESET_STATUS in VARCHAR2 := FND_API.G_MISS_CHAR,
30: X_DESTINATION_COLUMN_ID in NUMBER := FND_API.G_MISS_NUM,
31: X_REPOSITORY_ID in NUMBER := FND_API.G_MISS_NUM,
32: X_NAME in VARCHAR2 := FND_API.G_MISS_CHAR,
33: x_module_type IN VARCHAR2 := fnd_api.g_miss_char,
34: x_start_date IN DATE := fnd_api.g_miss_date,
35: x_end_date IN DATE := fnd_api.g_miss_date,
28: X_RULESET_ID in NUMBER := FND_API.G_MISS_NUM,
29: X_RULESET_STATUS in VARCHAR2 := FND_API.G_MISS_CHAR,
30: X_DESTINATION_COLUMN_ID in NUMBER := FND_API.G_MISS_NUM,
31: X_REPOSITORY_ID in NUMBER := FND_API.G_MISS_NUM,
32: X_NAME in VARCHAR2 := FND_API.G_MISS_CHAR,
33: x_module_type IN VARCHAR2 := fnd_api.g_miss_char,
34: x_start_date IN DATE := fnd_api.g_miss_date,
35: x_end_date IN DATE := fnd_api.g_miss_date,
36: X_CREATION_DATE in DATE := FND_API.G_MISS_DATE,
29: X_RULESET_STATUS in VARCHAR2 := FND_API.G_MISS_CHAR,
30: X_DESTINATION_COLUMN_ID in NUMBER := FND_API.G_MISS_NUM,
31: X_REPOSITORY_ID in NUMBER := FND_API.G_MISS_NUM,
32: X_NAME in VARCHAR2 := FND_API.G_MISS_CHAR,
33: x_module_type IN VARCHAR2 := fnd_api.g_miss_char,
34: x_start_date IN DATE := fnd_api.g_miss_date,
35: x_end_date IN DATE := fnd_api.g_miss_date,
36: X_CREATION_DATE in DATE := FND_API.G_MISS_DATE,
37: X_CREATED_BY in NUMBER := FND_API.G_MISS_NUM,
30: X_DESTINATION_COLUMN_ID in NUMBER := FND_API.G_MISS_NUM,
31: X_REPOSITORY_ID in NUMBER := FND_API.G_MISS_NUM,
32: X_NAME in VARCHAR2 := FND_API.G_MISS_CHAR,
33: x_module_type IN VARCHAR2 := fnd_api.g_miss_char,
34: x_start_date IN DATE := fnd_api.g_miss_date,
35: x_end_date IN DATE := fnd_api.g_miss_date,
36: X_CREATION_DATE in DATE := FND_API.G_MISS_DATE,
37: X_CREATED_BY in NUMBER := FND_API.G_MISS_NUM,
38: X_LAST_UPDATE_DATE in DATE := FND_API.G_MISS_DATE,
31: X_REPOSITORY_ID in NUMBER := FND_API.G_MISS_NUM,
32: X_NAME in VARCHAR2 := FND_API.G_MISS_CHAR,
33: x_module_type IN VARCHAR2 := fnd_api.g_miss_char,
34: x_start_date IN DATE := fnd_api.g_miss_date,
35: x_end_date IN DATE := fnd_api.g_miss_date,
36: X_CREATION_DATE in DATE := FND_API.G_MISS_DATE,
37: X_CREATED_BY in NUMBER := FND_API.G_MISS_NUM,
38: X_LAST_UPDATE_DATE in DATE := FND_API.G_MISS_DATE,
39: X_LAST_UPDATED_BY in NUMBER := FND_API.G_MISS_NUM,
32: X_NAME in VARCHAR2 := FND_API.G_MISS_CHAR,
33: x_module_type IN VARCHAR2 := fnd_api.g_miss_char,
34: x_start_date IN DATE := fnd_api.g_miss_date,
35: x_end_date IN DATE := fnd_api.g_miss_date,
36: X_CREATION_DATE in DATE := FND_API.G_MISS_DATE,
37: X_CREATED_BY in NUMBER := FND_API.G_MISS_NUM,
38: X_LAST_UPDATE_DATE in DATE := FND_API.G_MISS_DATE,
39: X_LAST_UPDATED_BY in NUMBER := FND_API.G_MISS_NUM,
40: X_LAST_UPDATE_LOGIN in NUMBER := FND_API.G_MISS_NUM,
33: x_module_type IN VARCHAR2 := fnd_api.g_miss_char,
34: x_start_date IN DATE := fnd_api.g_miss_date,
35: x_end_date IN DATE := fnd_api.g_miss_date,
36: X_CREATION_DATE in DATE := FND_API.G_MISS_DATE,
37: X_CREATED_BY in NUMBER := FND_API.G_MISS_NUM,
38: X_LAST_UPDATE_DATE in DATE := FND_API.G_MISS_DATE,
39: X_LAST_UPDATED_BY in NUMBER := FND_API.G_MISS_NUM,
40: X_LAST_UPDATE_LOGIN in NUMBER := FND_API.G_MISS_NUM,
41: X_ORG_ID in NUMBER := FND_API.G_MISS_NUM);
34: x_start_date IN DATE := fnd_api.g_miss_date,
35: x_end_date IN DATE := fnd_api.g_miss_date,
36: X_CREATION_DATE in DATE := FND_API.G_MISS_DATE,
37: X_CREATED_BY in NUMBER := FND_API.G_MISS_NUM,
38: X_LAST_UPDATE_DATE in DATE := FND_API.G_MISS_DATE,
39: X_LAST_UPDATED_BY in NUMBER := FND_API.G_MISS_NUM,
40: X_LAST_UPDATE_LOGIN in NUMBER := FND_API.G_MISS_NUM,
41: X_ORG_ID in NUMBER := FND_API.G_MISS_NUM);
42:
35: x_end_date IN DATE := fnd_api.g_miss_date,
36: X_CREATION_DATE in DATE := FND_API.G_MISS_DATE,
37: X_CREATED_BY in NUMBER := FND_API.G_MISS_NUM,
38: X_LAST_UPDATE_DATE in DATE := FND_API.G_MISS_DATE,
39: X_LAST_UPDATED_BY in NUMBER := FND_API.G_MISS_NUM,
40: X_LAST_UPDATE_LOGIN in NUMBER := FND_API.G_MISS_NUM,
41: X_ORG_ID in NUMBER := FND_API.G_MISS_NUM);
42:
43:
36: X_CREATION_DATE in DATE := FND_API.G_MISS_DATE,
37: X_CREATED_BY in NUMBER := FND_API.G_MISS_NUM,
38: X_LAST_UPDATE_DATE in DATE := FND_API.G_MISS_DATE,
39: X_LAST_UPDATED_BY in NUMBER := FND_API.G_MISS_NUM,
40: X_LAST_UPDATE_LOGIN in NUMBER := FND_API.G_MISS_NUM,
41: X_ORG_ID in NUMBER := FND_API.G_MISS_NUM);
42:
43:
44:
37: X_CREATED_BY in NUMBER := FND_API.G_MISS_NUM,
38: X_LAST_UPDATE_DATE in DATE := FND_API.G_MISS_DATE,
39: X_LAST_UPDATED_BY in NUMBER := FND_API.G_MISS_NUM,
40: X_LAST_UPDATE_LOGIN in NUMBER := FND_API.G_MISS_NUM,
41: X_ORG_ID in NUMBER := FND_API.G_MISS_NUM);
42:
43:
44:
45: procedure UPDATE_ROW