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;
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;
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
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;
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
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;
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(
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;
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(
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;
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;
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
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;
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
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;
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,
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
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;