APPS.IGF_AP_ISIR_IMPORT_PKG dependencies on FND_GLOBAL

Line 881: g_parent_req_number := fnd_global.conc_request_id; -- get the current request id as this would be the parent request id for the sub requests.

877: g_rec_type := p_rec_type ;
878: g_message_class := p_message_class ;
879: g_school_code := p_school_code ;
880: g_del_int := NVL(p_del_int, 'N');
881: g_parent_req_number := fnd_global.conc_request_id; -- get the current request id as this would be the parent request id for the sub requests.
882:
883: OPEN c_batch(l_cal_type,l_seq_number) ;
884: FETCH c_batch INTO l_batch;
885: CLOSE c_batch;

Line 1810: document := document||l_msg_body.person_number||fnd_global.tab||

1806: LOOP
1807: FETCH cur_get_data INTO l_msg_body;
1808: EXIT WHEN cur_get_data%NOTFOUND;
1809: l_given_names := SUBSTR(l_msg_body.given_names,1,LENGTH(LTRIM(RTRIM(l_msg_body.given_names))));
1810: document := document||l_msg_body.person_number||fnd_global.tab||
1811: l_given_names||fnd_global.tab||l_msg_body.transaction_number;
1812: document := document||fnd_global.newline;
1813: END LOOP;
1814: CLOSE cur_get_data;

Line 1811: l_given_names||fnd_global.tab||l_msg_body.transaction_number;

1807: FETCH cur_get_data INTO l_msg_body;
1808: EXIT WHEN cur_get_data%NOTFOUND;
1809: l_given_names := SUBSTR(l_msg_body.given_names,1,LENGTH(LTRIM(RTRIM(l_msg_body.given_names))));
1810: document := document||l_msg_body.person_number||fnd_global.tab||
1811: l_given_names||fnd_global.tab||l_msg_body.transaction_number;
1812: document := document||fnd_global.newline;
1813: END LOOP;
1814: CLOSE cur_get_data;
1815:

Line 1812: document := document||fnd_global.newline;

1808: EXIT WHEN cur_get_data%NOTFOUND;
1809: l_given_names := SUBSTR(l_msg_body.given_names,1,LENGTH(LTRIM(RTRIM(l_msg_body.given_names))));
1810: document := document||l_msg_body.person_number||fnd_global.tab||
1811: l_given_names||fnd_global.tab||l_msg_body.transaction_number;
1812: document := document||fnd_global.newline;
1813: END LOOP;
1814: CLOSE cur_get_data;
1815:
1816: END IF;

Line 1859: l_user := fnd_global.user_name;

1855: l_user VARCHAR2(80);
1856:
1857: BEGIN
1858: IF funcmode='RUN' THEN
1859: l_user := fnd_global.user_name;
1860: l_user := LTRIM(RTRIM(l_user));
1861:
1862: wf_engine.setitemattrtext(itemtype,
1863: itemkey,