DBA Data[Home] [Help]

APPS.POS_PRODUCT_SERVICE_UTL_PKG dependencies on FND_GLOBAL

Line 1109: fnd_global.user_id,

1105: null,
1106: null,
1107: l_value_id,
1108: sysdate,
1109: fnd_global.user_id,
1110: fnd_global.login_id,
1111: sysdate,
1112: fnd_global.user_id);
1113: END IF;

Line 1110: fnd_global.login_id,

1106: null,
1107: l_value_id,
1108: sysdate,
1109: fnd_global.user_id,
1110: fnd_global.login_id,
1111: sysdate,
1112: fnd_global.user_id);
1113: END IF;
1114:

Line 1112: fnd_global.user_id);

1108: sysdate,
1109: fnd_global.user_id,
1110: fnd_global.login_id,
1111: sysdate,
1112: fnd_global.user_id);
1113: END IF;
1114:
1115: end loop;
1116: CLOSE l_tblcur;

Line 1193: fnd_global.user_id,

1189: l_parent_value_id,
1190: null,
1191: l_value_id,
1192: sysdate,
1193: fnd_global.user_id,
1194: fnd_global.login_id,
1195: sysdate,
1196: fnd_global.user_id);
1197:

Line 1194: fnd_global.login_id,

1190: null,
1191: l_value_id,
1192: sysdate,
1193: fnd_global.user_id,
1194: fnd_global.login_id,
1195: sysdate,
1196: fnd_global.user_id);
1197:
1198: END IF;

Line 1196: fnd_global.user_id);

1192: sysdate,
1193: fnd_global.user_id,
1194: fnd_global.login_id,
1195: sysdate,
1196: fnd_global.user_id);
1197:
1198: END IF;
1199: end loop;
1200: CLOSE l_tblcur;

Line 1273: fnd_global.user_id,

1269: null,
1270: null,
1271: l_value,
1272: sysdate,
1273: fnd_global.user_id,
1274: fnd_global.login_id,
1275: sysdate,
1276: fnd_global.user_id);
1277:

Line 1274: fnd_global.login_id,

1270: null,
1271: l_value,
1272: sysdate,
1273: fnd_global.user_id,
1274: fnd_global.login_id,
1275: sysdate,
1276: fnd_global.user_id);
1277:
1278: end loop;

Line 1276: fnd_global.user_id);

1272: sysdate,
1273: fnd_global.user_id,
1274: fnd_global.login_id,
1275: sysdate,
1276: fnd_global.user_id);
1277:
1278: end loop;
1279: CLOSE l_tblcur;
1280: end if;

Line 1769: fnd_global.user_id, sysdate,

1765: )
1766: VALUES
1767: (
1768: pos_supplier_mapping_s.nextval, l_party_id, p_vendor_id,
1769: fnd_global.user_id, sysdate,
1770: fnd_global.user_id, sysdate, fnd_global.login_id
1771: );
1772: END IF;
1773:

Line 1770: fnd_global.user_id, sysdate, fnd_global.login_id

1766: VALUES
1767: (
1768: pos_supplier_mapping_s.nextval, l_party_id, p_vendor_id,
1769: fnd_global.user_id, sysdate,
1770: fnd_global.user_id, sysdate, fnd_global.login_id
1771: );
1772: END IF;
1773:
1774: select mapping_id

Line 1839: , fnd_global.user_id

1835: , p_segment20
1836: , 'PENDING'
1837: , 'ADD'
1838: , p_segment_definition
1839: , fnd_global.user_id
1840: , Sysdate
1841: , fnd_global.user_id
1842: , Sysdate
1843: , fnd_global.login_id

Line 1841: , fnd_global.user_id

1837: , 'ADD'
1838: , p_segment_definition
1839: , fnd_global.user_id
1840: , Sysdate
1841: , fnd_global.user_id
1842: , Sysdate
1843: , fnd_global.login_id
1844: );
1845: x_return_status := fnd_api.g_ret_sts_success;

Line 1843: , fnd_global.login_id

1839: , fnd_global.user_id
1840: , Sysdate
1841: , fnd_global.user_id
1842: , Sysdate
1843: , fnd_global.login_id
1844: );
1845: x_return_status := fnd_api.g_ret_sts_success;
1846:
1847: end add_new_ps_req;

Line 1863: last_updated_by = fnd_global.user_id,

1859: for i in 1..p_req_id_tbl.COUNT LOOP
1860:
1861: UPDATE POS_SUP_PRODUCTS_SERVICES
1862: SET status = p_status,
1863: last_updated_by = fnd_global.user_id,
1864: last_update_date = Sysdate,
1865: last_update_login = fnd_global.login_id
1866: WHERE classification_id = p_req_id_tbl(i);
1867:

Line 1865: last_update_login = fnd_global.login_id

1861: UPDATE POS_SUP_PRODUCTS_SERVICES
1862: SET status = p_status,
1863: last_updated_by = fnd_global.user_id,
1864: last_update_date = Sysdate,
1865: last_update_login = fnd_global.login_id
1866: WHERE classification_id = p_req_id_tbl(i);
1867:
1868: END LOOP;
1869:

Line 1886: last_updated_by = fnd_global.user_id,

1882:
1883: for i in 1..p_req_id_tbl.COUNT LOOP
1884: UPDATE POS_PRODUCT_SERVICE_REQUESTS
1885: SET request_status = 'DELETED',
1886: last_updated_by = fnd_global.user_id,
1887: last_update_date = Sysdate,
1888: last_update_login = fnd_global.login_id
1889: WHERE PS_REQUEST_ID = p_req_id_tbl(i);
1890: END LOOP;

Line 1888: last_update_login = fnd_global.login_id

1884: UPDATE POS_PRODUCT_SERVICE_REQUESTS
1885: SET request_status = 'DELETED',
1886: last_updated_by = fnd_global.user_id,
1887: last_update_date = Sysdate,
1888: last_update_login = fnd_global.login_id
1889: WHERE PS_REQUEST_ID = p_req_id_tbl(i);
1890: END LOOP;
1891:
1892: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1908: last_updated_by = fnd_global.user_id,

1904: for i in 1..p_req_id_tbl.COUNT LOOP
1905: UPDATE POS_PRODUCT_SERVICE_REQUESTS
1906: SET request_status = 'PENDING',
1907: request_type = 'ADD',
1908: last_updated_by = fnd_global.user_id,
1909: last_update_date = Sysdate,
1910: last_update_login = fnd_global.login_id
1911: WHERE PS_REQUEST_ID = p_req_id_tbl(i);
1912: END LOOP;

Line 1910: last_update_login = fnd_global.login_id

1906: SET request_status = 'PENDING',
1907: request_type = 'ADD',
1908: last_updated_by = fnd_global.user_id,
1909: last_update_date = Sysdate,
1910: last_update_login = fnd_global.login_id
1911: WHERE PS_REQUEST_ID = p_req_id_tbl(i);
1912: END LOOP;
1913:
1914: pos_profile_change_request_pkg.approve_mult_ps_reqs( p_req_id_tbl, x_return_status, x_msg_count, x_msg_data) ;