DBA Data[Home] [Help]

APPS.OKC_ARTICLES_ALL_PVT dependencies on FND_GLOBAL

Line 1502: IF FND_GLOBAL.CONC_PROGRAM_ID = -1 THEN

1498: Okc_Debug.Log('3600: Entered Insert_Row function', 2);
1499: END IF;
1500:
1501:
1502: IF FND_GLOBAL.CONC_PROGRAM_ID = -1 THEN
1503: l_program_id := NULL;
1504: l_program_login_id := NULL;
1505: ELSE
1506: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;

Line 1506: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;

1502: IF FND_GLOBAL.CONC_PROGRAM_ID = -1 THEN
1503: l_program_id := NULL;
1504: l_program_login_id := NULL;
1505: ELSE
1506: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1507: l_program_login_id := FND_GLOBAL.CONC_LOGIN_ID;
1508: END IF;
1509: IF FND_GLOBAL.PROG_APPL_ID = -1 THEN
1510: l_program_appl_id := NULL;

Line 1507: l_program_login_id := FND_GLOBAL.CONC_LOGIN_ID;

1503: l_program_id := NULL;
1504: l_program_login_id := NULL;
1505: ELSE
1506: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1507: l_program_login_id := FND_GLOBAL.CONC_LOGIN_ID;
1508: END IF;
1509: IF FND_GLOBAL.PROG_APPL_ID = -1 THEN
1510: l_program_appl_id := NULL;
1511: ELSE

Line 1509: IF FND_GLOBAL.PROG_APPL_ID = -1 THEN

1505: ELSE
1506: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
1507: l_program_login_id := FND_GLOBAL.CONC_LOGIN_ID;
1508: END IF;
1509: IF FND_GLOBAL.PROG_APPL_ID = -1 THEN
1510: l_program_appl_id := NULL;
1511: ELSE
1512: l_program_appl_id := FND_GLOBAL.PROG_APPL_ID;
1513: END IF;

Line 1512: l_program_appl_id := FND_GLOBAL.PROG_APPL_ID;

1508: END IF;
1509: IF FND_GLOBAL.PROG_APPL_ID = -1 THEN
1510: l_program_appl_id := NULL;
1511: ELSE
1512: l_program_appl_id := FND_GLOBAL.PROG_APPL_ID;
1513: END IF;
1514: IF FND_GLOBAL.CONC_REQUEST_ID = -1 THEN
1515: l_request_id := NULL;
1516: ELSE

Line 1514: IF FND_GLOBAL.CONC_REQUEST_ID = -1 THEN

1510: l_program_appl_id := NULL;
1511: ELSE
1512: l_program_appl_id := FND_GLOBAL.PROG_APPL_ID;
1513: END IF;
1514: IF FND_GLOBAL.CONC_REQUEST_ID = -1 THEN
1515: l_request_id := NULL;
1516: ELSE
1517: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
1518: END IF;

Line 1517: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;

1513: END IF;
1514: IF FND_GLOBAL.CONC_REQUEST_ID = -1 THEN
1515: l_request_id := NULL;
1516: ELSE
1517: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
1518: END IF;
1519:
1520:
1521: INSERT INTO OKC_ARTICLES_ALL(

Line 1706: l_created_by := Fnd_Global.User_Id;

1702: END IF;
1703: -- Set Internal columns
1704: l_object_version_number := 1;
1705: l_creation_date := Sysdate;
1706: l_created_by := Fnd_Global.User_Id;
1707: l_last_update_date := l_creation_date;
1708: l_last_updated_by := l_created_by;
1709: l_last_update_login := Fnd_Global.Login_Id;
1710: x_article_number := p_article_number;

Line 1709: l_last_update_login := Fnd_Global.Login_Id;

1705: l_creation_date := Sysdate;
1706: l_created_by := Fnd_Global.User_Id;
1707: l_last_update_date := l_creation_date;
1708: l_last_updated_by := l_created_by;
1709: l_last_update_login := Fnd_Global.Login_Id;
1710: x_article_number := p_article_number;
1711:
1712: --- Validate all non-missing attributes
1713: x_return_status := Validate_Record(

Line 2071: IF FND_GLOBAL.CONC_PROGRAM_ID = -1 THEN

2067: Okc_Debug.Log('6400: Entered Update_Row', 2);
2068: END IF;
2069:
2070:
2071: IF FND_GLOBAL.CONC_PROGRAM_ID = -1 THEN
2072: l_program_id := NULL;
2073: l_program_login_id := NULL;
2074: ELSE
2075: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;

Line 2075: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;

2071: IF FND_GLOBAL.CONC_PROGRAM_ID = -1 THEN
2072: l_program_id := NULL;
2073: l_program_login_id := NULL;
2074: ELSE
2075: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
2076: l_program_login_id := FND_GLOBAL.CONC_LOGIN_ID;
2077: END IF;
2078: IF FND_GLOBAL.PROG_APPL_ID = -1 THEN
2079: l_program_appl_id := NULL;

Line 2076: l_program_login_id := FND_GLOBAL.CONC_LOGIN_ID;

2072: l_program_id := NULL;
2073: l_program_login_id := NULL;
2074: ELSE
2075: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
2076: l_program_login_id := FND_GLOBAL.CONC_LOGIN_ID;
2077: END IF;
2078: IF FND_GLOBAL.PROG_APPL_ID = -1 THEN
2079: l_program_appl_id := NULL;
2080: ELSE

Line 2078: IF FND_GLOBAL.PROG_APPL_ID = -1 THEN

2074: ELSE
2075: l_program_id := FND_GLOBAL.CONC_PROGRAM_ID;
2076: l_program_login_id := FND_GLOBAL.CONC_LOGIN_ID;
2077: END IF;
2078: IF FND_GLOBAL.PROG_APPL_ID = -1 THEN
2079: l_program_appl_id := NULL;
2080: ELSE
2081: l_program_appl_id := FND_GLOBAL.PROG_APPL_ID;
2082: END IF;

Line 2081: l_program_appl_id := FND_GLOBAL.PROG_APPL_ID;

2077: END IF;
2078: IF FND_GLOBAL.PROG_APPL_ID = -1 THEN
2079: l_program_appl_id := NULL;
2080: ELSE
2081: l_program_appl_id := FND_GLOBAL.PROG_APPL_ID;
2082: END IF;
2083: IF FND_GLOBAL.CONC_REQUEST_ID = -1 THEN
2084: l_request_id := NULL;
2085: ELSE

Line 2083: IF FND_GLOBAL.CONC_REQUEST_ID = -1 THEN

2079: l_program_appl_id := NULL;
2080: ELSE
2081: l_program_appl_id := FND_GLOBAL.PROG_APPL_ID;
2082: END IF;
2083: IF FND_GLOBAL.CONC_REQUEST_ID = -1 THEN
2084: l_request_id := NULL;
2085: ELSE
2086: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
2087: END IF;

Line 2086: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;

2082: END IF;
2083: IF FND_GLOBAL.CONC_REQUEST_ID = -1 THEN
2084: l_request_id := NULL;
2085: ELSE
2086: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
2087: END IF;
2088:
2089: UPDATE OKC_ARTICLES_ALL
2090: SET ARTICLE_TITLE = p_article_title,

Line 2390: l_last_updated_by := FND_GLOBAL.USER_ID;

2386: END IF;
2387:
2388: -- Filling who columns
2389: l_last_update_date := SYSDATE;
2390: l_last_updated_by := FND_GLOBAL.USER_ID;
2391: l_last_update_login := FND_GLOBAL.LOGIN_ID;
2392:
2393: -- Object version increment
2394: IF Nvl(l_object_version_number, 0) >= 0 THEN

Line 2391: l_last_update_login := FND_GLOBAL.LOGIN_ID;

2387:
2388: -- Filling who columns
2389: l_last_update_date := SYSDATE;
2390: l_last_updated_by := FND_GLOBAL.USER_ID;
2391: l_last_update_login := FND_GLOBAL.LOGIN_ID;
2392:
2393: -- Object version increment
2394: IF Nvl(l_object_version_number, 0) >= 0 THEN
2395: l_object_version_number := Nvl(l_object_version_number, 0) + 1;