29:
30: procedure INSERT_ROW
31: (
32: X_ROWID in out NOCOPY VARCHAR2,
33: X_RULESET_ID in NUMBER := FND_API.G_MISS_NUM,
34: X_RULESET_STATUS in VARCHAR2 := FND_API.G_MISS_CHAR,
35: X_DESTINATION_COLUMN_ID in NUMBER := FND_API.G_MISS_NUM,
36: X_REPOSITORY_ID in NUMBER := FND_API.G_MISS_NUM,
37: X_NAME in VARCHAR2 := FND_API.G_MISS_CHAR,
30: procedure INSERT_ROW
31: (
32: X_ROWID in out NOCOPY VARCHAR2,
33: X_RULESET_ID in NUMBER := FND_API.G_MISS_NUM,
34: X_RULESET_STATUS in VARCHAR2 := FND_API.G_MISS_CHAR,
35: X_DESTINATION_COLUMN_ID in NUMBER := FND_API.G_MISS_NUM,
36: X_REPOSITORY_ID in NUMBER := FND_API.G_MISS_NUM,
37: X_NAME in VARCHAR2 := FND_API.G_MISS_CHAR,
38: x_module_type IN VARCHAR2 := fnd_api.g_miss_char,
31: (
32: X_ROWID in out NOCOPY VARCHAR2,
33: X_RULESET_ID in NUMBER := FND_API.G_MISS_NUM,
34: X_RULESET_STATUS in VARCHAR2 := FND_API.G_MISS_CHAR,
35: X_DESTINATION_COLUMN_ID in NUMBER := FND_API.G_MISS_NUM,
36: X_REPOSITORY_ID in NUMBER := FND_API.G_MISS_NUM,
37: X_NAME in VARCHAR2 := FND_API.G_MISS_CHAR,
38: x_module_type IN VARCHAR2 := fnd_api.g_miss_char,
39: x_start_date IN DATE := fnd_api.g_miss_date,
32: X_ROWID in out NOCOPY VARCHAR2,
33: X_RULESET_ID in NUMBER := FND_API.G_MISS_NUM,
34: X_RULESET_STATUS in VARCHAR2 := FND_API.G_MISS_CHAR,
35: X_DESTINATION_COLUMN_ID in NUMBER := FND_API.G_MISS_NUM,
36: X_REPOSITORY_ID in NUMBER := FND_API.G_MISS_NUM,
37: X_NAME in VARCHAR2 := FND_API.G_MISS_CHAR,
38: x_module_type IN VARCHAR2 := fnd_api.g_miss_char,
39: x_start_date IN DATE := fnd_api.g_miss_date,
40: x_end_date IN DATE := fnd_api.g_miss_date,
33: X_RULESET_ID in NUMBER := FND_API.G_MISS_NUM,
34: X_RULESET_STATUS in VARCHAR2 := FND_API.G_MISS_CHAR,
35: X_DESTINATION_COLUMN_ID in NUMBER := FND_API.G_MISS_NUM,
36: X_REPOSITORY_ID in NUMBER := FND_API.G_MISS_NUM,
37: X_NAME in VARCHAR2 := FND_API.G_MISS_CHAR,
38: x_module_type IN VARCHAR2 := fnd_api.g_miss_char,
39: x_start_date IN DATE := fnd_api.g_miss_date,
40: x_end_date IN DATE := fnd_api.g_miss_date,
41: X_CREATION_DATE in DATE := FND_API.G_MISS_DATE,
34: X_RULESET_STATUS in VARCHAR2 := FND_API.G_MISS_CHAR,
35: X_DESTINATION_COLUMN_ID in NUMBER := FND_API.G_MISS_NUM,
36: X_REPOSITORY_ID in NUMBER := FND_API.G_MISS_NUM,
37: X_NAME in VARCHAR2 := FND_API.G_MISS_CHAR,
38: x_module_type IN VARCHAR2 := fnd_api.g_miss_char,
39: x_start_date IN DATE := fnd_api.g_miss_date,
40: x_end_date IN DATE := fnd_api.g_miss_date,
41: X_CREATION_DATE in DATE := FND_API.G_MISS_DATE,
42: X_CREATED_BY in NUMBER := FND_API.G_MISS_NUM,
35: X_DESTINATION_COLUMN_ID in NUMBER := FND_API.G_MISS_NUM,
36: X_REPOSITORY_ID in NUMBER := FND_API.G_MISS_NUM,
37: X_NAME in VARCHAR2 := FND_API.G_MISS_CHAR,
38: x_module_type IN VARCHAR2 := fnd_api.g_miss_char,
39: x_start_date IN DATE := fnd_api.g_miss_date,
40: x_end_date IN DATE := fnd_api.g_miss_date,
41: X_CREATION_DATE in DATE := FND_API.G_MISS_DATE,
42: X_CREATED_BY in NUMBER := FND_API.G_MISS_NUM,
43: X_LAST_UPDATE_DATE in DATE := FND_API.G_MISS_DATE,
36: X_REPOSITORY_ID in NUMBER := FND_API.G_MISS_NUM,
37: X_NAME in VARCHAR2 := FND_API.G_MISS_CHAR,
38: x_module_type IN VARCHAR2 := fnd_api.g_miss_char,
39: x_start_date IN DATE := fnd_api.g_miss_date,
40: x_end_date IN DATE := fnd_api.g_miss_date,
41: X_CREATION_DATE in DATE := FND_API.G_MISS_DATE,
42: X_CREATED_BY in NUMBER := FND_API.G_MISS_NUM,
43: X_LAST_UPDATE_DATE in DATE := FND_API.G_MISS_DATE,
44: X_LAST_UPDATED_BY in NUMBER := FND_API.G_MISS_NUM,
37: X_NAME in VARCHAR2 := FND_API.G_MISS_CHAR,
38: x_module_type IN VARCHAR2 := fnd_api.g_miss_char,
39: x_start_date IN DATE := fnd_api.g_miss_date,
40: x_end_date IN DATE := fnd_api.g_miss_date,
41: X_CREATION_DATE in DATE := FND_API.G_MISS_DATE,
42: X_CREATED_BY in NUMBER := FND_API.G_MISS_NUM,
43: X_LAST_UPDATE_DATE in DATE := FND_API.G_MISS_DATE,
44: X_LAST_UPDATED_BY in NUMBER := FND_API.G_MISS_NUM,
45: X_LAST_UPDATE_LOGIN in NUMBER := FND_API.G_MISS_NUM,
38: x_module_type IN VARCHAR2 := fnd_api.g_miss_char,
39: x_start_date IN DATE := fnd_api.g_miss_date,
40: x_end_date IN DATE := fnd_api.g_miss_date,
41: X_CREATION_DATE in DATE := FND_API.G_MISS_DATE,
42: X_CREATED_BY in NUMBER := FND_API.G_MISS_NUM,
43: X_LAST_UPDATE_DATE in DATE := FND_API.G_MISS_DATE,
44: X_LAST_UPDATED_BY in NUMBER := FND_API.G_MISS_NUM,
45: X_LAST_UPDATE_LOGIN in NUMBER := FND_API.G_MISS_NUM,
46: X_ORG_ID in NUMBER := FND_API.G_MISS_NUM)
39: x_start_date IN DATE := fnd_api.g_miss_date,
40: x_end_date IN DATE := fnd_api.g_miss_date,
41: X_CREATION_DATE in DATE := FND_API.G_MISS_DATE,
42: X_CREATED_BY in NUMBER := FND_API.G_MISS_NUM,
43: X_LAST_UPDATE_DATE in DATE := FND_API.G_MISS_DATE,
44: X_LAST_UPDATED_BY in NUMBER := FND_API.G_MISS_NUM,
45: X_LAST_UPDATE_LOGIN in NUMBER := FND_API.G_MISS_NUM,
46: X_ORG_ID in NUMBER := FND_API.G_MISS_NUM)
47: IS
40: x_end_date IN DATE := fnd_api.g_miss_date,
41: X_CREATION_DATE in DATE := FND_API.G_MISS_DATE,
42: X_CREATED_BY in NUMBER := FND_API.G_MISS_NUM,
43: X_LAST_UPDATE_DATE in DATE := FND_API.G_MISS_DATE,
44: X_LAST_UPDATED_BY in NUMBER := FND_API.G_MISS_NUM,
45: X_LAST_UPDATE_LOGIN in NUMBER := FND_API.G_MISS_NUM,
46: X_ORG_ID in NUMBER := FND_API.G_MISS_NUM)
47: IS
48:
41: X_CREATION_DATE in DATE := FND_API.G_MISS_DATE,
42: X_CREATED_BY in NUMBER := FND_API.G_MISS_NUM,
43: X_LAST_UPDATE_DATE in DATE := FND_API.G_MISS_DATE,
44: X_LAST_UPDATED_BY in NUMBER := FND_API.G_MISS_NUM,
45: X_LAST_UPDATE_LOGIN in NUMBER := FND_API.G_MISS_NUM,
46: X_ORG_ID in NUMBER := FND_API.G_MISS_NUM)
47: IS
48:
49:
42: X_CREATED_BY in NUMBER := FND_API.G_MISS_NUM,
43: X_LAST_UPDATE_DATE in DATE := FND_API.G_MISS_DATE,
44: X_LAST_UPDATED_BY in NUMBER := FND_API.G_MISS_NUM,
45: X_LAST_UPDATE_LOGIN in NUMBER := FND_API.G_MISS_NUM,
46: X_ORG_ID in NUMBER := FND_API.G_MISS_NUM)
47: IS
48:
49:
50: l_rowid ROWID;