APPS.CS_TRANSACTION_TYPES_PKG dependencies on CS_TRANSACTION_TYPES_B

Line 49: cursor C is select ROWID from CS_TRANSACTION_TYPES_B

45: X_MOVE_COUNTERS_FLAG in VARCHAR2,
46: X_OBJECT_VERSION_NUMBER in NUMBER,
47: X_INTERFACE_TO_OE_FLAG in VARCHAR2
48: ) is
49: cursor C is select ROWID from CS_TRANSACTION_TYPES_B
50: where TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID
51: ;
52: begin
53: insert into CS_TRANSACTION_TYPES_B (

Line 53: insert into CS_TRANSACTION_TYPES_B (

49: cursor C is select ROWID from CS_TRANSACTION_TYPES_B
50: where TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID
51: ;
52: begin
53: insert into CS_TRANSACTION_TYPES_B (
54: TRANSACTION_TYPE_ID,
55: LINE_ORDER_CATEGORY_CODE,
56: SEEDED_FLAG,
57: REVISION_FLAG,

Line 256: from CS_TRANSACTION_TYPES_B

252: NEW_CP_RETURN_REQUIRED,
253: MOVE_COUNTERS_FLAG,
254: OBJECT_VERSION_NUMBER,
255: INTERFACE_TO_OE_FLAG
256: from CS_TRANSACTION_TYPES_B
257: where TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID
258: for update of TRANSACTION_TYPE_ID nowait;
259: recinfo c%rowtype;
260:

Line 412: update CS_TRANSACTION_TYPES_B set

408: X_OBJECT_VERSION_NUMBER in NUMBER,
409: X_INTERFACE_TO_OE_FLAG in VARCHAR2
410: ) is
411: begin
412: update CS_TRANSACTION_TYPES_B set
413: LINE_ORDER_CATEGORY_CODE = X_LINE_ORDER_CATEGORY_CODE,
414: SEEDED_FLAG = X_SEEDED_FLAG,
415: REVISION_FLAG = X_REVISION_FLAG,
416: END_DATE_ACTIVE = X_END_DATE_ACTIVE,

Line 483: delete from CS_TRANSACTION_TYPES_B

479: if (sql%notfound) then
480: raise no_data_found;
481: end if;
482:
483: delete from CS_TRANSACTION_TYPES_B
484: where TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID;
485:
486: if (sql%notfound) then
487: raise no_data_found;

Line 497: from CS_TRANSACTION_TYPES_B B

493: begin
494: delete from CS_TRANSACTION_TYPES_TL T
495: where not exists
496: (select NULL
497: from CS_TRANSACTION_TYPES_B B
498: where B.TRANSACTION_TYPE_ID = T.TRANSACTION_TYPE_ID
499: );
500:
501: update CS_TRANSACTION_TYPES_TL T set (

Line 629: from cs_transaction_types_b

625: l_user_id := 1;
626: end if;
627:
628: select last_updated_by into luby
629: from cs_transaction_types_b
630: where transaction_type_id = x_transaction_type_id;
631:
632: IF luby = 1 THEN
633: select object_version_number,rowid into l_object_ver,l_row_id

Line 634: from cs_transaction_types_b where transaction_type_id = x_transaction_type_id

630: where transaction_type_id = x_transaction_type_id;
631:
632: IF luby = 1 THEN
633: select object_version_number,rowid into l_object_ver,l_row_id
634: from cs_transaction_types_b where transaction_type_id = x_transaction_type_id
635: for update nowait;
636: l_object_ver := l_object_ver + 1;
637:
638: UPDATE_ROW (