2127: commitment_id = NULL,
2128: object_version_number = object_version_number +
2129: 1,
2130: last_update_date = SYSDATE,
2131: last_updated_by = fnd_global.user_id,
2132: last_update_login = fnd_global.login_id
2133: WHERE chr_id = p_chr_id;
2134:
2135: UPDATE okc_k_headers_all_b
2128: object_version_number = object_version_number +
2129: 1,
2130: last_update_date = SYSDATE,
2131: last_updated_by = fnd_global.user_id,
2132: last_update_login = fnd_global.login_id
2133: WHERE chr_id = p_chr_id;
2134:
2135: UPDATE okc_k_headers_all_b
2136: SET cust_po_number = NULL,
2140: NVL (x_rnrl_rec.payment_terms_id1, payment_term_id),
2141: object_version_number = object_version_number +
2142: 1,
2143: last_update_date = SYSDATE,
2144: last_updated_by = fnd_global.user_id,
2145: last_update_login = fnd_global.login_id
2146: WHERE ID = p_chr_id;
2147: ELSIF p_payment_type = 'COM' THEN
2148: UPDATE oks_k_headers_b
2141: object_version_number = object_version_number +
2142: 1,
2143: last_update_date = SYSDATE,
2144: last_updated_by = fnd_global.user_id,
2145: last_update_login = fnd_global.login_id
2146: WHERE ID = p_chr_id;
2147: ELSIF p_payment_type = 'COM' THEN
2148: UPDATE oks_k_headers_b
2149: SET payment_type = p_payment_type,
2151: trxn_extension_id = NULL,
2152: object_version_number = object_version_number +
2153: 1,
2154: last_update_date = SYSDATE,
2155: last_updated_by = fnd_global.user_id,
2156: last_update_login = fnd_global.login_id
2157: WHERE chr_id = p_chr_id;
2158:
2159: UPDATE okc_k_headers_all_b
2152: object_version_number = object_version_number +
2153: 1,
2154: last_update_date = SYSDATE,
2155: last_updated_by = fnd_global.user_id,
2156: last_update_login = fnd_global.login_id
2157: WHERE chr_id = p_chr_id;
2158:
2159: UPDATE okc_k_headers_all_b
2160: SET cust_po_number = NULL,
2162: cust_po_number_req_yn = 'N',
2163: object_version_number = object_version_number +
2164: 1,
2165: last_update_date = SYSDATE,
2166: last_updated_by = fnd_global.user_id,
2167: last_update_login = fnd_global.login_id
2168: WHERE ID = p_chr_id;
2169: ELSE
2170: UPDATE oks_k_headers_b
2163: object_version_number = object_version_number +
2164: 1,
2165: last_update_date = SYSDATE,
2166: last_updated_by = fnd_global.user_id,
2167: last_update_login = fnd_global.login_id
2168: WHERE ID = p_chr_id;
2169: ELSE
2170: UPDATE oks_k_headers_b
2171: SET payment_type = NULL,
2173: commitment_id = NULL,
2174: object_version_number = object_version_number +
2175: 1,
2176: last_update_date = SYSDATE,
2177: last_updated_by = fnd_global.user_id,
2178: last_update_login = fnd_global.login_id
2179: WHERE chr_id = p_chr_id;
2180:
2181: UPDATE okc_k_headers_all_b
2174: object_version_number = object_version_number +
2175: 1,
2176: last_update_date = SYSDATE,
2177: last_updated_by = fnd_global.user_id,
2178: last_update_login = fnd_global.login_id
2179: WHERE chr_id = p_chr_id;
2180:
2181: UPDATE okc_k_headers_all_b
2182: SET cust_po_number = p_payment_details,
2183: payment_instruction_type = p_payment_type,
2184: object_version_number = object_version_number +
2185: 1,
2186: last_update_date = SYSDATE,
2187: last_updated_by = fnd_global.user_id,
2188: last_update_login = fnd_global.login_id
2189: WHERE ID = p_chr_id;
2190: END IF;
2191:
2184: object_version_number = object_version_number +
2185: 1,
2186: last_update_date = SYSDATE,
2187: last_updated_by = fnd_global.user_id,
2188: last_update_login = fnd_global.login_id
2189: WHERE ID = p_chr_id;
2190: END IF;
2191:
2192: -- bump up the minor version number
2195: 1,
2196: object_version_number = object_version_number +
2197: 1,
2198: last_update_date = SYSDATE,
2199: last_updated_by = fnd_global.user_id,
2200: last_update_login = fnd_global.login_id
2201: WHERE chr_id = p_chr_id;
2202:
2203: -- Standard call to get message count and if count is 1, get message info.
2196: object_version_number = object_version_number +
2197: 1,
2198: last_update_date = SYSDATE,
2199: last_updated_by = fnd_global.user_id,
2200: last_update_login = fnd_global.login_id
2201: WHERE chr_id = p_chr_id;
2202:
2203: -- Standard call to get message count and if count is 1, get message info.
2204: fnd_msg_pub.count_and_get (p_encoded => 'F',