APPS.SY_ORGN_MST_PKG dependencies on SY_ORGN_MST_B

Line 59: cursor C is select ROWID from SY_ORGN_MST_B

55: X_LAST_UPDATE_LOGIN in NUMBER,
56: X_MFG_CALENDAR_ID in NUMBER
57:
58: ) is
59: cursor C is select ROWID from SY_ORGN_MST_B
60: where ORGN_CODE = X_ORGN_CODE
61: ;
62: begin
63: insert into SY_ORGN_MST_B (

Line 63: insert into SY_ORGN_MST_B (

59: cursor C is select ROWID from SY_ORGN_MST_B
60: where ORGN_CODE = X_ORGN_CODE
61: ;
62: begin
63: insert into SY_ORGN_MST_B (
64: ATTRIBUTE12,
65: ATTRIBUTE13,
66: ATTRIBUTE14,
67: ATTRIBUTE15,

Line 302: from SY_ORGN_MST_B

298: ATTRIBUTE9,
299: ATTRIBUTE10,
300: ATTRIBUTE11 ,
301: MFG_CALENDAR_ID
302: from SY_ORGN_MST_B
303: where ORGN_CODE = X_ORGN_CODE
304: for update of ORGN_CODE nowait;
305: recinfo c%rowtype;
306:

Line 481: update SY_ORGN_MST_B set

477: X_LAST_UPDATE_LOGIN in NUMBER,
478: X_MFG_CALENDAR_ID in NUMBER
479: ) is
480: begin
481: update SY_ORGN_MST_B set
482: ATTRIBUTE12 = X_ATTRIBUTE12,
483: ATTRIBUTE13 = X_ATTRIBUTE13,
484: ATTRIBUTE14 = X_ATTRIBUTE14,
485: ATTRIBUTE15 = X_ATTRIBUTE15,

Line 564: UPDATE SY_ORGN_MST_B set delete_mark = 1

560: end if;
561:
562: ************************ */
563:
564: UPDATE SY_ORGN_MST_B set delete_mark = 1
565: where ORGN_CODE = X_ORGN_CODE;
566:
567: if (sql%notfound) then
568: raise no_data_found;

Line 578: from SY_ORGN_MST_B B

574: begin
575: delete from SY_ORGN_MST_TL T
576: where not exists
577: (select NULL
578: from SY_ORGN_MST_B B
579: where B.ORGN_CODE = T.ORGN_CODE
580: );
581:
582: update SY_ORGN_MST_TL T set (