3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_UN_PROC_PUB';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cnunprob.pls';
6: G_LAST_UPDATE_DATE DATE := sysdate;
7: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
8: G_CREATION_DATE DATE := sysdate;
9: G_CREATED_BY NUMBER := fnd_global.user_id;
10: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
11:
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cnunprob.pls';
6: G_LAST_UPDATE_DATE DATE := sysdate;
7: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
8: G_CREATION_DATE DATE := sysdate;
9: G_CREATED_BY NUMBER := fnd_global.user_id;
10: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
11:
12: PROCEDURE get_adj(
13: p_api_version IN NUMBER,
6: G_LAST_UPDATE_DATE DATE := sysdate;
7: G_LAST_UPDATED_BY NUMBER := fnd_global.user_id;
8: G_CREATION_DATE DATE := sysdate;
9: G_CREATED_BY NUMBER := fnd_global.user_id;
10: G_LAST_UPDATE_LOGIN NUMBER := fnd_global.login_id;
11:
12: PROCEDURE get_adj(
13: p_api_version IN NUMBER,
14: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,