APPS.OKC_ARTICLES_GRP dependencies on FND_GLOBAL

Line 2298: l_user_id NUMBER := FND_GLOBAL.USER_ID;

2294: l_article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE;
2295: i NUMBER := 0;
2296: l_clob CLOB;
2297: -- Bug 3917777
2298: l_user_id NUMBER := FND_GLOBAL.USER_ID;
2299: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
2300: BEGIN
2301:
2302: IF (l_debug = 'Y') THEN

Line 2299: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

2295: i NUMBER := 0;
2296: l_clob CLOB;
2297: -- Bug 3917777
2298: l_user_id NUMBER := FND_GLOBAL.USER_ID;
2299: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
2300: BEGIN
2301:
2302: IF (l_debug = 'Y') THEN
2303: okc_debug.log('600: Entered create_article_version', 2);

Line 2657: l_user_id NUMBER := FND_GLOBAL.USER_ID;

2653: k number := 0;
2654: l_existing_variables_tbl variable_code_tbl_type;
2655: l_variable_found VARCHAR2(1) := 'F';
2656: -- Bug 3917777
2657: l_user_id NUMBER := FND_GLOBAL.USER_ID;
2658: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
2659:
2660: CURSOR existing_art_variable_csr (cp_article_version_id IN NUMBER) IS
2661: SELECT VARIABLE_CODE FROM OKC_ARTICLE_VARIABLES

Line 2658: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

2654: l_existing_variables_tbl variable_code_tbl_type;
2655: l_variable_found VARCHAR2(1) := 'F';
2656: -- Bug 3917777
2657: l_user_id NUMBER := FND_GLOBAL.USER_ID;
2658: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
2659:
2660: CURSOR existing_art_variable_csr (cp_article_version_id IN NUMBER) IS
2661: SELECT VARIABLE_CODE FROM OKC_ARTICLE_VARIABLES
2662: WHERE ARTICLE_VERSION_ID = cp_article_version_id;

Line 3192: l_user_id NUMBER := FND_GLOBAL.USER_ID;

3188: FROM OKC_ARTICLE_RELATNS_ALL
3189: WHERE source_article_id = cp_article_id
3190: AND org_id = cp_org_id;
3191:
3192: l_user_id NUMBER := FND_GLOBAL.USER_ID;
3193: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
3194: BEGIN
3195: IF (l_debug = 'Y') THEN
3196: Okc_Debug.Log('2700: Entered Copy_Articles ', 2);

Line 3193: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

3189: WHERE source_article_id = cp_article_id
3190: AND org_id = cp_org_id;
3191:
3192: l_user_id NUMBER := FND_GLOBAL.USER_ID;
3193: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
3194: BEGIN
3195: IF (l_debug = 'Y') THEN
3196: Okc_Debug.Log('2700: Entered Copy_Articles ', 2);
3197: END IF;

Line 3932: l_user_id NUMBER := FND_GLOBAL.USER_ID;

3928: AND V1.ARTICLE_STATUS = 'APPROVED'
3929: AND NVL(V1.END_DATE,SYSDATE + 1) > SYSDATE
3930: );
3931:
3932: l_user_id NUMBER := FND_GLOBAL.USER_ID;
3933: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
3934: l_src_local_article_id NUMBER;
3935: l_tar_local_article_id NUMBER;
3936: l_rownotfound BOOLEAN := FALSE;

Line 3933: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;

3929: AND NVL(V1.END_DATE,SYSDATE + 1) > SYSDATE
3930: );
3931:
3932: l_user_id NUMBER := FND_GLOBAL.USER_ID;
3933: l_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
3934: l_src_local_article_id NUMBER;
3935: l_tar_local_article_id NUMBER;
3936: l_rownotfound BOOLEAN := FALSE;
3937: