DBA Data[Home] [Help]

APPS.OKS_CUSTOMER_ACCEPTANCE_PVT dependencies on FND_GLOBAL

Line 2132: last_updated_by = fnd_global.user_id,

2128: commitment_id = NULL,
2129: object_version_number = object_version_number +
2130: 1,
2131: last_update_date = SYSDATE,
2132: last_updated_by = fnd_global.user_id,
2133: last_update_login = fnd_global.login_id
2134: WHERE chr_id = p_chr_id;
2135:
2136: UPDATE okc_k_headers_all_b

Line 2133: last_update_login = fnd_global.login_id

2129: object_version_number = object_version_number +
2130: 1,
2131: last_update_date = SYSDATE,
2132: last_updated_by = fnd_global.user_id,
2133: last_update_login = fnd_global.login_id
2134: WHERE chr_id = p_chr_id;
2135:
2136: UPDATE okc_k_headers_all_b
2137: SET cust_po_number = NULL,

Line 2145: last_updated_by = fnd_global.user_id,

2141: NVL (x_rnrl_rec.payment_terms_id1, payment_term_id),
2142: object_version_number = object_version_number +
2143: 1,
2144: last_update_date = SYSDATE,
2145: last_updated_by = fnd_global.user_id,
2146: last_update_login = fnd_global.login_id
2147: WHERE ID = p_chr_id;
2148: ELSIF p_payment_type = 'COM' THEN
2149: UPDATE oks_k_headers_b

Line 2146: last_update_login = fnd_global.login_id

2142: object_version_number = object_version_number +
2143: 1,
2144: last_update_date = SYSDATE,
2145: last_updated_by = fnd_global.user_id,
2146: last_update_login = fnd_global.login_id
2147: WHERE ID = p_chr_id;
2148: ELSIF p_payment_type = 'COM' THEN
2149: UPDATE oks_k_headers_b
2150: SET payment_type = p_payment_type,

Line 2156: last_updated_by = fnd_global.user_id,

2152: trxn_extension_id = NULL,
2153: object_version_number = object_version_number +
2154: 1,
2155: last_update_date = SYSDATE,
2156: last_updated_by = fnd_global.user_id,
2157: last_update_login = fnd_global.login_id
2158: WHERE chr_id = p_chr_id;
2159:
2160: UPDATE okc_k_headers_all_b

Line 2157: last_update_login = fnd_global.login_id

2153: object_version_number = object_version_number +
2154: 1,
2155: last_update_date = SYSDATE,
2156: last_updated_by = fnd_global.user_id,
2157: last_update_login = fnd_global.login_id
2158: WHERE chr_id = p_chr_id;
2159:
2160: UPDATE okc_k_headers_all_b
2161: SET cust_po_number = NULL,

Line 2167: last_updated_by = fnd_global.user_id,

2163: cust_po_number_req_yn = 'N',
2164: object_version_number = object_version_number +
2165: 1,
2166: last_update_date = SYSDATE,
2167: last_updated_by = fnd_global.user_id,
2168: last_update_login = fnd_global.login_id
2169: WHERE ID = p_chr_id;
2170: ELSE
2171: UPDATE oks_k_headers_b

Line 2168: last_update_login = fnd_global.login_id

2164: object_version_number = object_version_number +
2165: 1,
2166: last_update_date = SYSDATE,
2167: last_updated_by = fnd_global.user_id,
2168: last_update_login = fnd_global.login_id
2169: WHERE ID = p_chr_id;
2170: ELSE
2171: UPDATE oks_k_headers_b
2172: SET payment_type = NULL,

Line 2178: last_updated_by = fnd_global.user_id,

2174: commitment_id = NULL,
2175: object_version_number = object_version_number +
2176: 1,
2177: last_update_date = SYSDATE,
2178: last_updated_by = fnd_global.user_id,
2179: last_update_login = fnd_global.login_id
2180: WHERE chr_id = p_chr_id;
2181:
2182: UPDATE okc_k_headers_all_b

Line 2179: last_update_login = fnd_global.login_id

2175: object_version_number = object_version_number +
2176: 1,
2177: last_update_date = SYSDATE,
2178: last_updated_by = fnd_global.user_id,
2179: last_update_login = fnd_global.login_id
2180: WHERE chr_id = p_chr_id;
2181:
2182: UPDATE okc_k_headers_all_b
2183: SET cust_po_number = p_payment_details,

Line 2188: last_updated_by = fnd_global.user_id,

2184: payment_instruction_type = p_payment_type,
2185: object_version_number = object_version_number +
2186: 1,
2187: last_update_date = SYSDATE,
2188: last_updated_by = fnd_global.user_id,
2189: last_update_login = fnd_global.login_id
2190: WHERE ID = p_chr_id;
2191: END IF;
2192:

Line 2189: last_update_login = fnd_global.login_id

2185: object_version_number = object_version_number +
2186: 1,
2187: last_update_date = SYSDATE,
2188: last_updated_by = fnd_global.user_id,
2189: last_update_login = fnd_global.login_id
2190: WHERE ID = p_chr_id;
2191: END IF;
2192:
2193: -- bump up the minor version number

Line 2200: last_updated_by = fnd_global.user_id,

2196: 1,
2197: object_version_number = object_version_number +
2198: 1,
2199: last_update_date = SYSDATE,
2200: last_updated_by = fnd_global.user_id,
2201: last_update_login = fnd_global.login_id
2202: WHERE chr_id = p_chr_id;
2203:
2204: -- Standard call to get message count and if count is 1, get message info.

Line 2201: last_update_login = fnd_global.login_id

2197: object_version_number = object_version_number +
2198: 1,
2199: last_update_date = SYSDATE,
2200: last_updated_by = fnd_global.user_id,
2201: last_update_login = fnd_global.login_id
2202: WHERE chr_id = p_chr_id;
2203:
2204: -- Standard call to get message count and if count is 1, get message info.
2205: fnd_msg_pub.count_and_get (p_encoded => 'F',