APPS.CS_TRANSACTION_TYPES_PKG dependencies on CS_TRANSACTION_TYPES_B

Line 52: cursor C is select ROWID from CS_TRANSACTION_TYPES_B

48: X_TRAVEL_FLAG in VARCHAR2, -- SHACHOUD
49: X_CALCULATE_PRICE_FLAG in VARCHAR2, -- shachoud 12.2 Charges Logistics
50: X_UPDATE_TASK_ACTUALS_FLAG in VARCHAR2 -- Added by nic for SUN 12.1.3 ER
51: ) is
52: cursor C is select ROWID from CS_TRANSACTION_TYPES_B
53: where TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID
54: ;
55: begin
56: insert into CS_TRANSACTION_TYPES_B (

Line 56: insert into CS_TRANSACTION_TYPES_B (

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

Line 271: from CS_TRANSACTION_TYPES_B

267: INTERFACE_TO_OE_FLAG,
268: TRAVEL_FLAG, -- shachoud
269: CALCULATE_PRICE_FLAG, -- shachoud 12.2 Charges Logistics
270: UPDATE_TASK_ACTUALS_FLAG --added by nic for sun 12.1.3 ER
271: from CS_TRANSACTION_TYPES_B
272: where TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID
273: for update of TRANSACTION_TYPE_ID nowait;
274: recinfo c%rowtype;
275:

Line 433: update CS_TRANSACTION_TYPES_B set

429: X_UPDATE_TASK_ACTUALS_FLAG in VARCHAR2 -- added by nic for 12.1.3 SUN ER
430:
431: ) is
432: begin
433: update CS_TRANSACTION_TYPES_B set
434: LINE_ORDER_CATEGORY_CODE = X_LINE_ORDER_CATEGORY_CODE,
435: SEEDED_FLAG = X_SEEDED_FLAG,
436: REVISION_FLAG = X_REVISION_FLAG,
437: END_DATE_ACTIVE = X_END_DATE_ACTIVE,

Line 507: delete from CS_TRANSACTION_TYPES_B

503: if (sql%notfound) then
504: raise no_data_found;
505: end if;
506:
507: delete from CS_TRANSACTION_TYPES_B
508: where TRANSACTION_TYPE_ID = X_TRANSACTION_TYPE_ID;
509:
510: if (sql%notfound) then
511: raise no_data_found;

Line 521: from CS_TRANSACTION_TYPES_B B

517: begin
518: delete from CS_TRANSACTION_TYPES_TL T
519: where not exists
520: (select NULL
521: from CS_TRANSACTION_TYPES_B B
522: where B.TRANSACTION_TYPE_ID = T.TRANSACTION_TYPE_ID
523: );
524:
525: update CS_TRANSACTION_TYPES_TL T set (

Line 656: from cs_transaction_types_b

652: l_user_id := 1;
653: end if;
654:
655: select last_updated_by into luby
656: from cs_transaction_types_b
657: where transaction_type_id = x_transaction_type_id;
658:
659: IF luby = 1 THEN
660: select object_version_number,rowid into l_object_ver,l_row_id

Line 661: from cs_transaction_types_b where transaction_type_id = x_transaction_type_id

657: where transaction_type_id = x_transaction_type_id;
658:
659: IF luby = 1 THEN
660: select object_version_number,rowid into l_object_ver,l_row_id
661: from cs_transaction_types_b where transaction_type_id = x_transaction_type_id
662: for update nowait;
663: l_object_ver := l_object_ver + 1;
664:
665: UPDATE_ROW (