DBA Data[Home] [Help]

APPS.PO_CONTERMS_UTL_GRP dependencies on FND_GLOBAL

Line 1485: Last_updated_by = FND_GLOBAl.USER_ID,

1481: Set conterms_exist_flag = l_conterms_exist_flag,
1482: Conterms_articles_upd_date = l_date,
1483: Conterms_DELIV_upd_date = l_date,
1484: Last_update_date = sysdate,
1485: Last_updated_by = FND_GLOBAl.USER_ID,
1486: Last_update_login = FND_GLOBAL.LOGIN_ID
1487: WHERE po_header_id= p_header_id;
1488: ELSE --CLM Mod
1489: -- SQL WHAT-Update the conterms_exist_flag and the contract terms dates in po_headers_all

Line 1486: Last_update_login = FND_GLOBAL.LOGIN_ID

1482: Conterms_articles_upd_date = l_date,
1483: Conterms_DELIV_upd_date = l_date,
1484: Last_update_date = sysdate,
1485: Last_updated_by = FND_GLOBAl.USER_ID,
1486: Last_update_login = FND_GLOBAL.LOGIN_ID
1487: WHERE po_header_id= p_header_id;
1488: ELSE --CLM Mod
1489: -- SQL WHAT-Update the conterms_exist_flag and the contract terms dates in po_headers_all
1490: -- SQL WHY - Update the flag based on if contract terms template attached or removed

Line 1497: Last_updated_by = FND_GLOBAl.USER_ID,

1493: Set conterms_exist_flag = l_conterms_exist_flag,
1494: Conterms_articles_upd_date = l_date,
1495: Conterms_DELIV_upd_date = l_date,
1496: Last_update_date = sysdate,
1497: Last_updated_by = FND_GLOBAl.USER_ID,
1498: Last_update_login = FND_GLOBAL.LOGIN_ID
1499: WHERE draft_id= p_header_id;
1500: END IF; --CLM Mod
1501:

Line 1498: Last_update_login = FND_GLOBAL.LOGIN_ID

1494: Conterms_articles_upd_date = l_date,
1495: Conterms_DELIV_upd_date = l_date,
1496: Last_update_date = sysdate,
1497: Last_updated_by = FND_GLOBAl.USER_ID,
1498: Last_update_login = FND_GLOBAL.LOGIN_ID
1499: WHERE draft_id= p_header_id;
1500: END IF; --CLM Mod
1501:
1502: IF g_fnd_debug = 'Y' then