DBA Data[Home] [Help]

APPS.OZF_PRICELIST_PVT dependencies on FND_GLOBAL

Line 219: l_resource_id NUMBER := OZF_UTILITY_PVT.get_resource_id(FND_GLOBAL.user_id);

215: SELECT user_status_id,custom_setup_id,owner_id
216: FROM OZF_price_list_attributes
217: WHERE qp_list_header_id = l_id;
218:
219: l_resource_id NUMBER := OZF_UTILITY_PVT.get_resource_id(FND_GLOBAL.user_id);
220:
221: l_new_status_code VARCHAR2(30);
222: l_existing_status_code VARCHAR2(30);
223: l_old_status_id NUMBER;

Line 764: ,p_requester_userid => OZF_Utility_PVT.get_resource_id(FND_GLOBAL.user_id)

760: ,p_object_version_number => p_price_list_rec.object_version_number
761: ,p_orig_stat_id => l_old_status_id
762: ,p_new_stat_id => p_price_list_rec.user_status_id
763: ,p_reject_stat_id => ozf_utility_pvt.get_default_user_status('OZF_PRICELIST_STATUS','REJECTED')
764: ,p_requester_userid => OZF_Utility_PVT.get_resource_id(FND_GLOBAL.user_id)
765: ,p_workflowprocess => 'AMSGAPP'
766: ,p_item_type => 'AMSGAPP');
767: END IF;
768:

Line 795: p_entered_by => FND_GLOBAL.user_id,

791: p_source_object_code => 'OZF_PRIC_LINE',
792: p_notes => p_price_list_line_tbl(i).note,
793: p_notes_detail => NULL,
794: p_note_status => 'I',
795: p_entered_by => FND_GLOBAL.user_id,
796: p_entered_date => SYSDATE,
797: x_jtf_note_id => l_jtf_note_id,
798: p_last_update_date => SYSDATE,
799: p_last_updated_by => FND_GLOBAL.user_id,

Line 799: p_last_updated_by => FND_GLOBAL.user_id,

795: p_entered_by => FND_GLOBAL.user_id,
796: p_entered_date => SYSDATE,
797: x_jtf_note_id => l_jtf_note_id,
798: p_last_update_date => SYSDATE,
799: p_last_updated_by => FND_GLOBAL.user_id,
800: p_creation_date => SYSDATE,
801: p_created_by => FND_GLOBAL.user_id,
802: p_last_update_login => FND_GLOBAL.login_id,
803: p_attribute1 => NULL,

Line 801: p_created_by => FND_GLOBAL.user_id,

797: x_jtf_note_id => l_jtf_note_id,
798: p_last_update_date => SYSDATE,
799: p_last_updated_by => FND_GLOBAL.user_id,
800: p_creation_date => SYSDATE,
801: p_created_by => FND_GLOBAL.user_id,
802: p_last_update_login => FND_GLOBAL.login_id,
803: p_attribute1 => NULL,
804: p_attribute2 => NULL,
805: p_attribute3 => NULL,

Line 802: p_last_update_login => FND_GLOBAL.login_id,

798: p_last_update_date => SYSDATE,
799: p_last_updated_by => FND_GLOBAL.user_id,
800: p_creation_date => SYSDATE,
801: p_created_by => FND_GLOBAL.user_id,
802: p_last_update_login => FND_GLOBAL.login_id,
803: p_attribute1 => NULL,
804: p_attribute2 => NULL,
805: p_attribute3 => NULL,
806: p_attribute4 => NULL,

Line 846: p_entered_by => FND_GLOBAL.user_id,

842: x_return_status => l_return_status,
843: x_msg_count => l_msg_count,
844: x_msg_data => l_msg_data,
845: p_jtf_note_id => p_price_list_line_tbl(i).jtf_note_id,
846: p_entered_by => FND_GLOBAL.user_id,
847: p_last_updated_by => FND_GLOBAL.user_id,
848: p_last_update_date => SYSDATE,
849: p_last_update_login => FND_GLOBAL.login_id,
850: p_notes => p_price_list_line_tbl(i).note,

Line 847: p_last_updated_by => FND_GLOBAL.user_id,

843: x_msg_count => l_msg_count,
844: x_msg_data => l_msg_data,
845: p_jtf_note_id => p_price_list_line_tbl(i).jtf_note_id,
846: p_entered_by => FND_GLOBAL.user_id,
847: p_last_updated_by => FND_GLOBAL.user_id,
848: p_last_update_date => SYSDATE,
849: p_last_update_login => FND_GLOBAL.login_id,
850: p_notes => p_price_list_line_tbl(i).note,
851: p_notes_detail => NULL,

Line 849: p_last_update_login => FND_GLOBAL.login_id,

845: p_jtf_note_id => p_price_list_line_tbl(i).jtf_note_id,
846: p_entered_by => FND_GLOBAL.user_id,
847: p_last_updated_by => FND_GLOBAL.user_id,
848: p_last_update_date => SYSDATE,
849: p_last_update_login => FND_GLOBAL.login_id,
850: p_notes => p_price_list_line_tbl(i).note,
851: p_notes_detail => NULL,
852: p_append_flag => FND_API.g_miss_char,
853: p_note_status => 'I',

Line 1378: ,FND_GLOBAL.user_id

1374: ,l_list_line_detail.base_qty
1375: ,l_list_line_detail.base_uom_code
1376: ,l_list_line_detail.comments
1377: ,l_list_line_detail.context
1378: ,FND_GLOBAL.user_id
1379: ,SYSDATE
1380: ,FND_GLOBAL.user_id
1381: ,SYSDATE
1382: ,FND_GLOBAL.conc_login_id

Line 1380: ,FND_GLOBAL.user_id

1376: ,l_list_line_detail.comments
1377: ,l_list_line_detail.context
1378: ,FND_GLOBAL.user_id
1379: ,SYSDATE
1380: ,FND_GLOBAL.user_id
1381: ,SYSDATE
1382: ,FND_GLOBAL.conc_login_id
1383: ,l_list_line_detail.effective_period_uom
1384: ,l_list_line_detail.end_date_active

Line 1382: ,FND_GLOBAL.conc_login_id

1378: ,FND_GLOBAL.user_id
1379: ,SYSDATE
1380: ,FND_GLOBAL.user_id
1381: ,SYSDATE
1382: ,FND_GLOBAL.conc_login_id
1383: ,l_list_line_detail.effective_period_uom
1384: ,l_list_line_detail.end_date_active
1385: ,l_list_line_detail.estim_accrual_rate
1386: ,l_list_line_detail.inventory_item_id

Line 1511: ,FND_GLOBAL.user_id

1507: ,l_pricing_detail.pricing_phase_id
1508: ,l_list_header_line_id.list_header_id
1509: ,l_list_line_id
1510: -- ,l_list_line_id
1511: ,FND_GLOBAL.user_id
1512: ,SYSDATE
1513: ,FND_GLOBAL.user_id
1514: ,SYSDATE
1515: ,FND_GLOBAL.conc_login_id);

Line 1513: ,FND_GLOBAL.user_id

1509: ,l_list_line_id
1510: -- ,l_list_line_id
1511: ,FND_GLOBAL.user_id
1512: ,SYSDATE
1513: ,FND_GLOBAL.user_id
1514: ,SYSDATE
1515: ,FND_GLOBAL.conc_login_id);
1516: END IF;
1517: END LOOP;

Line 1515: ,FND_GLOBAL.conc_login_id);

1511: ,FND_GLOBAL.user_id
1512: ,SYSDATE
1513: ,FND_GLOBAL.user_id
1514: ,SYSDATE
1515: ,FND_GLOBAL.conc_login_id);
1516: END IF;
1517: END LOOP;
1518: END LOOP;
1519: /*