DBA Data[Home] [Help]

APPS.OKS_K_ACTIONS_PVT dependencies on FND_GLOBAL

Line 828: FND_GLOBAL.USER_ID, -- CREATED_BY

824: p_attachment_template_id,
825: p_email_subject,
826: TO_CLOB(p_email_body),
827: p_email_contract_status,
828: FND_GLOBAL.USER_ID, -- CREATED_BY
829: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY
830: SYSDATE, -- CREATION_DATE
831: SYSDATE, -- LAST_UPDATE_DATE
832: FND_GLOBAL.LOGIN_ID --LAST_UPDATE_LOGIN

Line 829: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY

825: p_email_subject,
826: TO_CLOB(p_email_body),
827: p_email_contract_status,
828: FND_GLOBAL.USER_ID, -- CREATED_BY
829: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY
830: SYSDATE, -- CREATION_DATE
831: SYSDATE, -- LAST_UPDATE_DATE
832: FND_GLOBAL.LOGIN_ID --LAST_UPDATE_LOGIN
833: )

Line 832: FND_GLOBAL.LOGIN_ID --LAST_UPDATE_LOGIN

828: FND_GLOBAL.USER_ID, -- CREATED_BY
829: FND_GLOBAL.USER_ID, -- LAST_UPDATED_BY
830: SYSDATE, -- CREATION_DATE
831: SYSDATE, -- LAST_UPDATE_DATE
832: FND_GLOBAL.LOGIN_ID --LAST_UPDATE_LOGIN
833: )
834: RETURNING email_id
835: INTO l_email_id;
836:

Line 1466: p_entered_by => FND_GLOBAL.USER_ID,

1462: p_source_object_id => p_chr_id,
1463: p_source_object_code => 'OKS_HDR_NOTE',
1464: p_notes => p_contract_notes,
1465: p_note_status => 'I', --public status
1466: p_entered_by => FND_GLOBAL.USER_ID,
1467: p_entered_date => SYSDATE ,
1468: x_jtf_note_id => l_jtf_note_id,
1469: p_last_update_date => sysdate,
1470: p_last_updated_by => FND_GLOBAL.USER_ID,

Line 1470: p_last_updated_by => FND_GLOBAL.USER_ID,

1466: p_entered_by => FND_GLOBAL.USER_ID,
1467: p_entered_date => SYSDATE ,
1468: x_jtf_note_id => l_jtf_note_id,
1469: p_last_update_date => sysdate,
1470: p_last_updated_by => FND_GLOBAL.USER_ID,
1471: p_creation_date => SYSDATE,
1472: p_created_by => FND_GLOBAL.USER_ID,
1473: p_last_update_login => FND_GLOBAL.LOGIN_ID,
1474: p_note_type => 'OKS_ADMIN');

Line 1472: p_created_by => FND_GLOBAL.USER_ID,

1468: x_jtf_note_id => l_jtf_note_id,
1469: p_last_update_date => sysdate,
1470: p_last_updated_by => FND_GLOBAL.USER_ID,
1471: p_creation_date => SYSDATE,
1472: p_created_by => FND_GLOBAL.USER_ID,
1473: p_last_update_login => FND_GLOBAL.LOGIN_ID,
1474: p_note_type => 'OKS_ADMIN');
1475:
1476: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)

Line 1473: p_last_update_login => FND_GLOBAL.LOGIN_ID,

1469: p_last_update_date => sysdate,
1470: p_last_updated_by => FND_GLOBAL.USER_ID,
1471: p_creation_date => SYSDATE,
1472: p_created_by => FND_GLOBAL.USER_ID,
1473: p_last_update_login => FND_GLOBAL.LOGIN_ID,
1474: p_note_type => 'OKS_ADMIN');
1475:
1476: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)
1477: THEN

Line 1536: last_updated_by = FND_GLOBAL.USER_ID,

1532: follow_up_action = p_action,
1533: est_rev_percent = p_est_percent,
1534: est_rev_date = p_est_date,
1535: last_update_date = SYSDATE,
1536: last_updated_by = FND_GLOBAL.USER_ID,
1537: last_update_login = FND_GLOBAL.LOGIN_ID
1538: where chr_id = p_chr_id;
1539: /*added for bug7034006*/
1540: Update okc_k_headers_all_b okcb

Line 1537: last_update_login = FND_GLOBAL.LOGIN_ID

1533: est_rev_percent = p_est_percent,
1534: est_rev_date = p_est_date,
1535: last_update_date = SYSDATE,
1536: last_updated_by = FND_GLOBAL.USER_ID,
1537: last_update_login = FND_GLOBAL.LOGIN_ID
1538: where chr_id = p_chr_id;
1539: /*added for bug7034006*/
1540: Update okc_k_headers_all_b okcb
1541: set last_update_date = SYSDATE,

Line 1542: last_updated_by = FND_GLOBAL.USER_ID,

1538: where chr_id = p_chr_id;
1539: /*added for bug7034006*/
1540: Update okc_k_headers_all_b okcb
1541: set last_update_date = SYSDATE,
1542: last_updated_by = FND_GLOBAL.USER_ID,
1543: last_update_login = FND_GLOBAL.LOGIN_ID
1544: where okcb.id = p_chr_id;
1545:
1546: if(SQL%ROWCOUNT =1) then

Line 1543: last_update_login = FND_GLOBAL.LOGIN_ID

1539: /*added for bug7034006*/
1540: Update okc_k_headers_all_b okcb
1541: set last_update_date = SYSDATE,
1542: last_updated_by = FND_GLOBAL.USER_ID,
1543: last_update_login = FND_GLOBAL.LOGIN_ID
1544: where okcb.id = p_chr_id;
1545:
1546: if(SQL%ROWCOUNT =1) then
1547: x_return_status := fnd_api.g_ret_sts_success;