eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMIVDBL dependencies on IC_JRNL_MST

Line 41: | Modified ic_jrnl_mst insert to not insert journal no |

37: | added - (validation (default is 0))in |
38: | item_rec_typ record for the |
39: | Pricing by Quantity 2 project. |
40: | 07/24/02 Jalaj Srivastava BUg 2483656 |
41: | Modified ic_jrnl_mst insert to not insert journal no |
42: | if it already exists |
43: | 17-Nov-2002 Joe DiIorio Bug 1977956 11.5.1J - added nocopy. |
44: | 15-Apr-2003 Joe DiIorio Bug 2880585 11.5.1K - added conversion_id |
45: | to insert of ic_item_cnv. Added insert of |

Line 1219: FUNCTION ic_jrnl_mst_insert

1215: GMIGUTL.DB_ERRMSG:= SQLERRM;
1216: RETURN FALSE;
1217: END ic_lots_sts_select;
1218:
1219: FUNCTION ic_jrnl_mst_insert
1220: (p_ic_jrnl_mst_row IN ic_jrnl_mst%ROWTYPE, x_ic_jrnl_mst_row IN OUT NOCOPY ic_jrnl_mst%ROWTYPE)
1221: RETURN BOOLEAN
1222: IS
1223: BEGIN

Line 1220: (p_ic_jrnl_mst_row IN ic_jrnl_mst%ROWTYPE, x_ic_jrnl_mst_row IN OUT NOCOPY ic_jrnl_mst%ROWTYPE)

1216: RETURN FALSE;
1217: END ic_lots_sts_select;
1218:
1219: FUNCTION ic_jrnl_mst_insert
1220: (p_ic_jrnl_mst_row IN ic_jrnl_mst%ROWTYPE, x_ic_jrnl_mst_row IN OUT NOCOPY ic_jrnl_mst%ROWTYPE)
1221: RETURN BOOLEAN
1222: IS
1223: BEGIN
1224: /* Copy input to output */

Line 1227: IF ( NOT ic_jrnl_mst_select

1223: BEGIN
1224: /* Copy input to output */
1225: --Jalaj Srivastava Bug 2483656
1226: --If journal no exists, no need to insert it
1227: IF ( NOT ic_jrnl_mst_select
1228: (p_ic_jrnl_mst_row => p_ic_jrnl_mst_row,
1229: x_ic_jrnl_mst_row => x_ic_jrnl_mst_row
1230: )
1231: ) THEN

Line 1228: (p_ic_jrnl_mst_row => p_ic_jrnl_mst_row,

1224: /* Copy input to output */
1225: --Jalaj Srivastava Bug 2483656
1226: --If journal no exists, no need to insert it
1227: IF ( NOT ic_jrnl_mst_select
1228: (p_ic_jrnl_mst_row => p_ic_jrnl_mst_row,
1229: x_ic_jrnl_mst_row => x_ic_jrnl_mst_row
1230: )
1231: ) THEN
1232: x_ic_jrnl_mst_row := p_ic_jrnl_mst_row;

Line 1229: x_ic_jrnl_mst_row => x_ic_jrnl_mst_row

1225: --Jalaj Srivastava Bug 2483656
1226: --If journal no exists, no need to insert it
1227: IF ( NOT ic_jrnl_mst_select
1228: (p_ic_jrnl_mst_row => p_ic_jrnl_mst_row,
1229: x_ic_jrnl_mst_row => x_ic_jrnl_mst_row
1230: )
1231: ) THEN
1232: x_ic_jrnl_mst_row := p_ic_jrnl_mst_row;
1233:

Line 1232: x_ic_jrnl_mst_row := p_ic_jrnl_mst_row;

1228: (p_ic_jrnl_mst_row => p_ic_jrnl_mst_row,
1229: x_ic_jrnl_mst_row => x_ic_jrnl_mst_row
1230: )
1231: ) THEN
1232: x_ic_jrnl_mst_row := p_ic_jrnl_mst_row;
1233:
1234: IF x_ic_jrnl_mst_row.journal_id IS NULL
1235: THEN
1236: SELECT gem5_journal_id_s.nextval INTO x_ic_jrnl_mst_row.journal_id FROM DUAL;

Line 1234: IF x_ic_jrnl_mst_row.journal_id IS NULL

1230: )
1231: ) THEN
1232: x_ic_jrnl_mst_row := p_ic_jrnl_mst_row;
1233:
1234: IF x_ic_jrnl_mst_row.journal_id IS NULL
1235: THEN
1236: SELECT gem5_journal_id_s.nextval INTO x_ic_jrnl_mst_row.journal_id FROM DUAL;
1237: END IF;
1238:

Line 1236: SELECT gem5_journal_id_s.nextval INTO x_ic_jrnl_mst_row.journal_id FROM DUAL;

1232: x_ic_jrnl_mst_row := p_ic_jrnl_mst_row;
1233:
1234: IF x_ic_jrnl_mst_row.journal_id IS NULL
1235: THEN
1236: SELECT gem5_journal_id_s.nextval INTO x_ic_jrnl_mst_row.journal_id FROM DUAL;
1237: END IF;
1238:
1239: INSERT INTO ic_jrnl_mst
1240: ( journal_id

Line 1239: INSERT INTO ic_jrnl_mst

1235: THEN
1236: SELECT gem5_journal_id_s.nextval INTO x_ic_jrnl_mst_row.journal_id FROM DUAL;
1237: END IF;
1238:
1239: INSERT INTO ic_jrnl_mst
1240: ( journal_id
1241: , journal_no
1242: , journal_comment
1243: , posting_id

Line 1287: ( x_ic_jrnl_mst_row.journal_id

1283: , attribute30
1284: , attribute_category
1285: )
1286: VALUES
1287: ( x_ic_jrnl_mst_row.journal_id
1288: , x_ic_jrnl_mst_row.journal_no
1289: , x_ic_jrnl_mst_row.journal_comment
1290: , x_ic_jrnl_mst_row.posting_id
1291: , x_ic_jrnl_mst_row.print_cnt

Line 1288: , x_ic_jrnl_mst_row.journal_no

1284: , attribute_category
1285: )
1286: VALUES
1287: ( x_ic_jrnl_mst_row.journal_id
1288: , x_ic_jrnl_mst_row.journal_no
1289: , x_ic_jrnl_mst_row.journal_comment
1290: , x_ic_jrnl_mst_row.posting_id
1291: , x_ic_jrnl_mst_row.print_cnt
1292: , x_ic_jrnl_mst_row.posted_ind

Line 1289: , x_ic_jrnl_mst_row.journal_comment

1285: )
1286: VALUES
1287: ( x_ic_jrnl_mst_row.journal_id
1288: , x_ic_jrnl_mst_row.journal_no
1289: , x_ic_jrnl_mst_row.journal_comment
1290: , x_ic_jrnl_mst_row.posting_id
1291: , x_ic_jrnl_mst_row.print_cnt
1292: , x_ic_jrnl_mst_row.posted_ind
1293: , x_ic_jrnl_mst_row.orgn_code

Line 1290: , x_ic_jrnl_mst_row.posting_id

1286: VALUES
1287: ( x_ic_jrnl_mst_row.journal_id
1288: , x_ic_jrnl_mst_row.journal_no
1289: , x_ic_jrnl_mst_row.journal_comment
1290: , x_ic_jrnl_mst_row.posting_id
1291: , x_ic_jrnl_mst_row.print_cnt
1292: , x_ic_jrnl_mst_row.posted_ind
1293: , x_ic_jrnl_mst_row.orgn_code
1294: , x_ic_jrnl_mst_row.creation_date

Line 1291: , x_ic_jrnl_mst_row.print_cnt

1287: ( x_ic_jrnl_mst_row.journal_id
1288: , x_ic_jrnl_mst_row.journal_no
1289: , x_ic_jrnl_mst_row.journal_comment
1290: , x_ic_jrnl_mst_row.posting_id
1291: , x_ic_jrnl_mst_row.print_cnt
1292: , x_ic_jrnl_mst_row.posted_ind
1293: , x_ic_jrnl_mst_row.orgn_code
1294: , x_ic_jrnl_mst_row.creation_date
1295: , x_ic_jrnl_mst_row.last_update_date

Line 1292: , x_ic_jrnl_mst_row.posted_ind

1288: , x_ic_jrnl_mst_row.journal_no
1289: , x_ic_jrnl_mst_row.journal_comment
1290: , x_ic_jrnl_mst_row.posting_id
1291: , x_ic_jrnl_mst_row.print_cnt
1292: , x_ic_jrnl_mst_row.posted_ind
1293: , x_ic_jrnl_mst_row.orgn_code
1294: , x_ic_jrnl_mst_row.creation_date
1295: , x_ic_jrnl_mst_row.last_update_date
1296: , x_ic_jrnl_mst_row.created_by

Line 1293: , x_ic_jrnl_mst_row.orgn_code

1289: , x_ic_jrnl_mst_row.journal_comment
1290: , x_ic_jrnl_mst_row.posting_id
1291: , x_ic_jrnl_mst_row.print_cnt
1292: , x_ic_jrnl_mst_row.posted_ind
1293: , x_ic_jrnl_mst_row.orgn_code
1294: , x_ic_jrnl_mst_row.creation_date
1295: , x_ic_jrnl_mst_row.last_update_date
1296: , x_ic_jrnl_mst_row.created_by
1297: , x_ic_jrnl_mst_row.last_updated_by

Line 1294: , x_ic_jrnl_mst_row.creation_date

1290: , x_ic_jrnl_mst_row.posting_id
1291: , x_ic_jrnl_mst_row.print_cnt
1292: , x_ic_jrnl_mst_row.posted_ind
1293: , x_ic_jrnl_mst_row.orgn_code
1294: , x_ic_jrnl_mst_row.creation_date
1295: , x_ic_jrnl_mst_row.last_update_date
1296: , x_ic_jrnl_mst_row.created_by
1297: , x_ic_jrnl_mst_row.last_updated_by
1298: , x_ic_jrnl_mst_row.delete_mark

Line 1295: , x_ic_jrnl_mst_row.last_update_date

1291: , x_ic_jrnl_mst_row.print_cnt
1292: , x_ic_jrnl_mst_row.posted_ind
1293: , x_ic_jrnl_mst_row.orgn_code
1294: , x_ic_jrnl_mst_row.creation_date
1295: , x_ic_jrnl_mst_row.last_update_date
1296: , x_ic_jrnl_mst_row.created_by
1297: , x_ic_jrnl_mst_row.last_updated_by
1298: , x_ic_jrnl_mst_row.delete_mark
1299: , x_ic_jrnl_mst_row.text_code

Line 1296: , x_ic_jrnl_mst_row.created_by

1292: , x_ic_jrnl_mst_row.posted_ind
1293: , x_ic_jrnl_mst_row.orgn_code
1294: , x_ic_jrnl_mst_row.creation_date
1295: , x_ic_jrnl_mst_row.last_update_date
1296: , x_ic_jrnl_mst_row.created_by
1297: , x_ic_jrnl_mst_row.last_updated_by
1298: , x_ic_jrnl_mst_row.delete_mark
1299: , x_ic_jrnl_mst_row.text_code
1300: , x_ic_jrnl_mst_row.in_use

Line 1297: , x_ic_jrnl_mst_row.last_updated_by

1293: , x_ic_jrnl_mst_row.orgn_code
1294: , x_ic_jrnl_mst_row.creation_date
1295: , x_ic_jrnl_mst_row.last_update_date
1296: , x_ic_jrnl_mst_row.created_by
1297: , x_ic_jrnl_mst_row.last_updated_by
1298: , x_ic_jrnl_mst_row.delete_mark
1299: , x_ic_jrnl_mst_row.text_code
1300: , x_ic_jrnl_mst_row.in_use
1301: , x_ic_jrnl_mst_row.attribute1

Line 1298: , x_ic_jrnl_mst_row.delete_mark

1294: , x_ic_jrnl_mst_row.creation_date
1295: , x_ic_jrnl_mst_row.last_update_date
1296: , x_ic_jrnl_mst_row.created_by
1297: , x_ic_jrnl_mst_row.last_updated_by
1298: , x_ic_jrnl_mst_row.delete_mark
1299: , x_ic_jrnl_mst_row.text_code
1300: , x_ic_jrnl_mst_row.in_use
1301: , x_ic_jrnl_mst_row.attribute1
1302: , x_ic_jrnl_mst_row.attribute2

Line 1299: , x_ic_jrnl_mst_row.text_code

1295: , x_ic_jrnl_mst_row.last_update_date
1296: , x_ic_jrnl_mst_row.created_by
1297: , x_ic_jrnl_mst_row.last_updated_by
1298: , x_ic_jrnl_mst_row.delete_mark
1299: , x_ic_jrnl_mst_row.text_code
1300: , x_ic_jrnl_mst_row.in_use
1301: , x_ic_jrnl_mst_row.attribute1
1302: , x_ic_jrnl_mst_row.attribute2
1303: , x_ic_jrnl_mst_row.attribute3

Line 1300: , x_ic_jrnl_mst_row.in_use

1296: , x_ic_jrnl_mst_row.created_by
1297: , x_ic_jrnl_mst_row.last_updated_by
1298: , x_ic_jrnl_mst_row.delete_mark
1299: , x_ic_jrnl_mst_row.text_code
1300: , x_ic_jrnl_mst_row.in_use
1301: , x_ic_jrnl_mst_row.attribute1
1302: , x_ic_jrnl_mst_row.attribute2
1303: , x_ic_jrnl_mst_row.attribute3
1304: , x_ic_jrnl_mst_row.attribute4

Line 1301: , x_ic_jrnl_mst_row.attribute1

1297: , x_ic_jrnl_mst_row.last_updated_by
1298: , x_ic_jrnl_mst_row.delete_mark
1299: , x_ic_jrnl_mst_row.text_code
1300: , x_ic_jrnl_mst_row.in_use
1301: , x_ic_jrnl_mst_row.attribute1
1302: , x_ic_jrnl_mst_row.attribute2
1303: , x_ic_jrnl_mst_row.attribute3
1304: , x_ic_jrnl_mst_row.attribute4
1305: , x_ic_jrnl_mst_row.attribute5

Line 1302: , x_ic_jrnl_mst_row.attribute2

1298: , x_ic_jrnl_mst_row.delete_mark
1299: , x_ic_jrnl_mst_row.text_code
1300: , x_ic_jrnl_mst_row.in_use
1301: , x_ic_jrnl_mst_row.attribute1
1302: , x_ic_jrnl_mst_row.attribute2
1303: , x_ic_jrnl_mst_row.attribute3
1304: , x_ic_jrnl_mst_row.attribute4
1305: , x_ic_jrnl_mst_row.attribute5
1306: , x_ic_jrnl_mst_row.attribute6

Line 1303: , x_ic_jrnl_mst_row.attribute3

1299: , x_ic_jrnl_mst_row.text_code
1300: , x_ic_jrnl_mst_row.in_use
1301: , x_ic_jrnl_mst_row.attribute1
1302: , x_ic_jrnl_mst_row.attribute2
1303: , x_ic_jrnl_mst_row.attribute3
1304: , x_ic_jrnl_mst_row.attribute4
1305: , x_ic_jrnl_mst_row.attribute5
1306: , x_ic_jrnl_mst_row.attribute6
1307: , x_ic_jrnl_mst_row.attribute7

Line 1304: , x_ic_jrnl_mst_row.attribute4

1300: , x_ic_jrnl_mst_row.in_use
1301: , x_ic_jrnl_mst_row.attribute1
1302: , x_ic_jrnl_mst_row.attribute2
1303: , x_ic_jrnl_mst_row.attribute3
1304: , x_ic_jrnl_mst_row.attribute4
1305: , x_ic_jrnl_mst_row.attribute5
1306: , x_ic_jrnl_mst_row.attribute6
1307: , x_ic_jrnl_mst_row.attribute7
1308: , x_ic_jrnl_mst_row.attribute8

Line 1305: , x_ic_jrnl_mst_row.attribute5

1301: , x_ic_jrnl_mst_row.attribute1
1302: , x_ic_jrnl_mst_row.attribute2
1303: , x_ic_jrnl_mst_row.attribute3
1304: , x_ic_jrnl_mst_row.attribute4
1305: , x_ic_jrnl_mst_row.attribute5
1306: , x_ic_jrnl_mst_row.attribute6
1307: , x_ic_jrnl_mst_row.attribute7
1308: , x_ic_jrnl_mst_row.attribute8
1309: , x_ic_jrnl_mst_row.attribute9

Line 1306: , x_ic_jrnl_mst_row.attribute6

1302: , x_ic_jrnl_mst_row.attribute2
1303: , x_ic_jrnl_mst_row.attribute3
1304: , x_ic_jrnl_mst_row.attribute4
1305: , x_ic_jrnl_mst_row.attribute5
1306: , x_ic_jrnl_mst_row.attribute6
1307: , x_ic_jrnl_mst_row.attribute7
1308: , x_ic_jrnl_mst_row.attribute8
1309: , x_ic_jrnl_mst_row.attribute9
1310: , x_ic_jrnl_mst_row.attribute10

Line 1307: , x_ic_jrnl_mst_row.attribute7

1303: , x_ic_jrnl_mst_row.attribute3
1304: , x_ic_jrnl_mst_row.attribute4
1305: , x_ic_jrnl_mst_row.attribute5
1306: , x_ic_jrnl_mst_row.attribute6
1307: , x_ic_jrnl_mst_row.attribute7
1308: , x_ic_jrnl_mst_row.attribute8
1309: , x_ic_jrnl_mst_row.attribute9
1310: , x_ic_jrnl_mst_row.attribute10
1311: , x_ic_jrnl_mst_row.attribute11

Line 1308: , x_ic_jrnl_mst_row.attribute8

1304: , x_ic_jrnl_mst_row.attribute4
1305: , x_ic_jrnl_mst_row.attribute5
1306: , x_ic_jrnl_mst_row.attribute6
1307: , x_ic_jrnl_mst_row.attribute7
1308: , x_ic_jrnl_mst_row.attribute8
1309: , x_ic_jrnl_mst_row.attribute9
1310: , x_ic_jrnl_mst_row.attribute10
1311: , x_ic_jrnl_mst_row.attribute11
1312: , x_ic_jrnl_mst_row.attribute12

Line 1309: , x_ic_jrnl_mst_row.attribute9

1305: , x_ic_jrnl_mst_row.attribute5
1306: , x_ic_jrnl_mst_row.attribute6
1307: , x_ic_jrnl_mst_row.attribute7
1308: , x_ic_jrnl_mst_row.attribute8
1309: , x_ic_jrnl_mst_row.attribute9
1310: , x_ic_jrnl_mst_row.attribute10
1311: , x_ic_jrnl_mst_row.attribute11
1312: , x_ic_jrnl_mst_row.attribute12
1313: , x_ic_jrnl_mst_row.attribute13

Line 1310: , x_ic_jrnl_mst_row.attribute10

1306: , x_ic_jrnl_mst_row.attribute6
1307: , x_ic_jrnl_mst_row.attribute7
1308: , x_ic_jrnl_mst_row.attribute8
1309: , x_ic_jrnl_mst_row.attribute9
1310: , x_ic_jrnl_mst_row.attribute10
1311: , x_ic_jrnl_mst_row.attribute11
1312: , x_ic_jrnl_mst_row.attribute12
1313: , x_ic_jrnl_mst_row.attribute13
1314: , x_ic_jrnl_mst_row.attribute14

Line 1311: , x_ic_jrnl_mst_row.attribute11

1307: , x_ic_jrnl_mst_row.attribute7
1308: , x_ic_jrnl_mst_row.attribute8
1309: , x_ic_jrnl_mst_row.attribute9
1310: , x_ic_jrnl_mst_row.attribute10
1311: , x_ic_jrnl_mst_row.attribute11
1312: , x_ic_jrnl_mst_row.attribute12
1313: , x_ic_jrnl_mst_row.attribute13
1314: , x_ic_jrnl_mst_row.attribute14
1315: , x_ic_jrnl_mst_row.attribute15

Line 1312: , x_ic_jrnl_mst_row.attribute12

1308: , x_ic_jrnl_mst_row.attribute8
1309: , x_ic_jrnl_mst_row.attribute9
1310: , x_ic_jrnl_mst_row.attribute10
1311: , x_ic_jrnl_mst_row.attribute11
1312: , x_ic_jrnl_mst_row.attribute12
1313: , x_ic_jrnl_mst_row.attribute13
1314: , x_ic_jrnl_mst_row.attribute14
1315: , x_ic_jrnl_mst_row.attribute15
1316: , x_ic_jrnl_mst_row.attribute16

Line 1313: , x_ic_jrnl_mst_row.attribute13

1309: , x_ic_jrnl_mst_row.attribute9
1310: , x_ic_jrnl_mst_row.attribute10
1311: , x_ic_jrnl_mst_row.attribute11
1312: , x_ic_jrnl_mst_row.attribute12
1313: , x_ic_jrnl_mst_row.attribute13
1314: , x_ic_jrnl_mst_row.attribute14
1315: , x_ic_jrnl_mst_row.attribute15
1316: , x_ic_jrnl_mst_row.attribute16
1317: , x_ic_jrnl_mst_row.attribute17

Line 1314: , x_ic_jrnl_mst_row.attribute14

1310: , x_ic_jrnl_mst_row.attribute10
1311: , x_ic_jrnl_mst_row.attribute11
1312: , x_ic_jrnl_mst_row.attribute12
1313: , x_ic_jrnl_mst_row.attribute13
1314: , x_ic_jrnl_mst_row.attribute14
1315: , x_ic_jrnl_mst_row.attribute15
1316: , x_ic_jrnl_mst_row.attribute16
1317: , x_ic_jrnl_mst_row.attribute17
1318: , x_ic_jrnl_mst_row.attribute18

Line 1315: , x_ic_jrnl_mst_row.attribute15

1311: , x_ic_jrnl_mst_row.attribute11
1312: , x_ic_jrnl_mst_row.attribute12
1313: , x_ic_jrnl_mst_row.attribute13
1314: , x_ic_jrnl_mst_row.attribute14
1315: , x_ic_jrnl_mst_row.attribute15
1316: , x_ic_jrnl_mst_row.attribute16
1317: , x_ic_jrnl_mst_row.attribute17
1318: , x_ic_jrnl_mst_row.attribute18
1319: , x_ic_jrnl_mst_row.attribute19

Line 1316: , x_ic_jrnl_mst_row.attribute16

1312: , x_ic_jrnl_mst_row.attribute12
1313: , x_ic_jrnl_mst_row.attribute13
1314: , x_ic_jrnl_mst_row.attribute14
1315: , x_ic_jrnl_mst_row.attribute15
1316: , x_ic_jrnl_mst_row.attribute16
1317: , x_ic_jrnl_mst_row.attribute17
1318: , x_ic_jrnl_mst_row.attribute18
1319: , x_ic_jrnl_mst_row.attribute19
1320: , x_ic_jrnl_mst_row.attribute20

Line 1317: , x_ic_jrnl_mst_row.attribute17

1313: , x_ic_jrnl_mst_row.attribute13
1314: , x_ic_jrnl_mst_row.attribute14
1315: , x_ic_jrnl_mst_row.attribute15
1316: , x_ic_jrnl_mst_row.attribute16
1317: , x_ic_jrnl_mst_row.attribute17
1318: , x_ic_jrnl_mst_row.attribute18
1319: , x_ic_jrnl_mst_row.attribute19
1320: , x_ic_jrnl_mst_row.attribute20
1321: , x_ic_jrnl_mst_row.attribute21

Line 1318: , x_ic_jrnl_mst_row.attribute18

1314: , x_ic_jrnl_mst_row.attribute14
1315: , x_ic_jrnl_mst_row.attribute15
1316: , x_ic_jrnl_mst_row.attribute16
1317: , x_ic_jrnl_mst_row.attribute17
1318: , x_ic_jrnl_mst_row.attribute18
1319: , x_ic_jrnl_mst_row.attribute19
1320: , x_ic_jrnl_mst_row.attribute20
1321: , x_ic_jrnl_mst_row.attribute21
1322: , x_ic_jrnl_mst_row.attribute22

Line 1319: , x_ic_jrnl_mst_row.attribute19

1315: , x_ic_jrnl_mst_row.attribute15
1316: , x_ic_jrnl_mst_row.attribute16
1317: , x_ic_jrnl_mst_row.attribute17
1318: , x_ic_jrnl_mst_row.attribute18
1319: , x_ic_jrnl_mst_row.attribute19
1320: , x_ic_jrnl_mst_row.attribute20
1321: , x_ic_jrnl_mst_row.attribute21
1322: , x_ic_jrnl_mst_row.attribute22
1323: , x_ic_jrnl_mst_row.attribute23

Line 1320: , x_ic_jrnl_mst_row.attribute20

1316: , x_ic_jrnl_mst_row.attribute16
1317: , x_ic_jrnl_mst_row.attribute17
1318: , x_ic_jrnl_mst_row.attribute18
1319: , x_ic_jrnl_mst_row.attribute19
1320: , x_ic_jrnl_mst_row.attribute20
1321: , x_ic_jrnl_mst_row.attribute21
1322: , x_ic_jrnl_mst_row.attribute22
1323: , x_ic_jrnl_mst_row.attribute23
1324: , x_ic_jrnl_mst_row.attribute24

Line 1321: , x_ic_jrnl_mst_row.attribute21

1317: , x_ic_jrnl_mst_row.attribute17
1318: , x_ic_jrnl_mst_row.attribute18
1319: , x_ic_jrnl_mst_row.attribute19
1320: , x_ic_jrnl_mst_row.attribute20
1321: , x_ic_jrnl_mst_row.attribute21
1322: , x_ic_jrnl_mst_row.attribute22
1323: , x_ic_jrnl_mst_row.attribute23
1324: , x_ic_jrnl_mst_row.attribute24
1325: , x_ic_jrnl_mst_row.attribute25

Line 1322: , x_ic_jrnl_mst_row.attribute22

1318: , x_ic_jrnl_mst_row.attribute18
1319: , x_ic_jrnl_mst_row.attribute19
1320: , x_ic_jrnl_mst_row.attribute20
1321: , x_ic_jrnl_mst_row.attribute21
1322: , x_ic_jrnl_mst_row.attribute22
1323: , x_ic_jrnl_mst_row.attribute23
1324: , x_ic_jrnl_mst_row.attribute24
1325: , x_ic_jrnl_mst_row.attribute25
1326: , x_ic_jrnl_mst_row.attribute26

Line 1323: , x_ic_jrnl_mst_row.attribute23

1319: , x_ic_jrnl_mst_row.attribute19
1320: , x_ic_jrnl_mst_row.attribute20
1321: , x_ic_jrnl_mst_row.attribute21
1322: , x_ic_jrnl_mst_row.attribute22
1323: , x_ic_jrnl_mst_row.attribute23
1324: , x_ic_jrnl_mst_row.attribute24
1325: , x_ic_jrnl_mst_row.attribute25
1326: , x_ic_jrnl_mst_row.attribute26
1327: , x_ic_jrnl_mst_row.attribute27

Line 1324: , x_ic_jrnl_mst_row.attribute24

1320: , x_ic_jrnl_mst_row.attribute20
1321: , x_ic_jrnl_mst_row.attribute21
1322: , x_ic_jrnl_mst_row.attribute22
1323: , x_ic_jrnl_mst_row.attribute23
1324: , x_ic_jrnl_mst_row.attribute24
1325: , x_ic_jrnl_mst_row.attribute25
1326: , x_ic_jrnl_mst_row.attribute26
1327: , x_ic_jrnl_mst_row.attribute27
1328: , x_ic_jrnl_mst_row.attribute28

Line 1325: , x_ic_jrnl_mst_row.attribute25

1321: , x_ic_jrnl_mst_row.attribute21
1322: , x_ic_jrnl_mst_row.attribute22
1323: , x_ic_jrnl_mst_row.attribute23
1324: , x_ic_jrnl_mst_row.attribute24
1325: , x_ic_jrnl_mst_row.attribute25
1326: , x_ic_jrnl_mst_row.attribute26
1327: , x_ic_jrnl_mst_row.attribute27
1328: , x_ic_jrnl_mst_row.attribute28
1329: , x_ic_jrnl_mst_row.attribute29

Line 1326: , x_ic_jrnl_mst_row.attribute26

1322: , x_ic_jrnl_mst_row.attribute22
1323: , x_ic_jrnl_mst_row.attribute23
1324: , x_ic_jrnl_mst_row.attribute24
1325: , x_ic_jrnl_mst_row.attribute25
1326: , x_ic_jrnl_mst_row.attribute26
1327: , x_ic_jrnl_mst_row.attribute27
1328: , x_ic_jrnl_mst_row.attribute28
1329: , x_ic_jrnl_mst_row.attribute29
1330: , x_ic_jrnl_mst_row.attribute30

Line 1327: , x_ic_jrnl_mst_row.attribute27

1323: , x_ic_jrnl_mst_row.attribute23
1324: , x_ic_jrnl_mst_row.attribute24
1325: , x_ic_jrnl_mst_row.attribute25
1326: , x_ic_jrnl_mst_row.attribute26
1327: , x_ic_jrnl_mst_row.attribute27
1328: , x_ic_jrnl_mst_row.attribute28
1329: , x_ic_jrnl_mst_row.attribute29
1330: , x_ic_jrnl_mst_row.attribute30
1331: , x_ic_jrnl_mst_row.attribute_category

Line 1328: , x_ic_jrnl_mst_row.attribute28

1324: , x_ic_jrnl_mst_row.attribute24
1325: , x_ic_jrnl_mst_row.attribute25
1326: , x_ic_jrnl_mst_row.attribute26
1327: , x_ic_jrnl_mst_row.attribute27
1328: , x_ic_jrnl_mst_row.attribute28
1329: , x_ic_jrnl_mst_row.attribute29
1330: , x_ic_jrnl_mst_row.attribute30
1331: , x_ic_jrnl_mst_row.attribute_category
1332: );

Line 1329: , x_ic_jrnl_mst_row.attribute29

1325: , x_ic_jrnl_mst_row.attribute25
1326: , x_ic_jrnl_mst_row.attribute26
1327: , x_ic_jrnl_mst_row.attribute27
1328: , x_ic_jrnl_mst_row.attribute28
1329: , x_ic_jrnl_mst_row.attribute29
1330: , x_ic_jrnl_mst_row.attribute30
1331: , x_ic_jrnl_mst_row.attribute_category
1332: );
1333: END IF;

Line 1330: , x_ic_jrnl_mst_row.attribute30

1326: , x_ic_jrnl_mst_row.attribute26
1327: , x_ic_jrnl_mst_row.attribute27
1328: , x_ic_jrnl_mst_row.attribute28
1329: , x_ic_jrnl_mst_row.attribute29
1330: , x_ic_jrnl_mst_row.attribute30
1331: , x_ic_jrnl_mst_row.attribute_category
1332: );
1333: END IF;
1334: GMIGUTL.DB_ERRNUM := NULL;

Line 1331: , x_ic_jrnl_mst_row.attribute_category

1327: , x_ic_jrnl_mst_row.attribute27
1328: , x_ic_jrnl_mst_row.attribute28
1329: , x_ic_jrnl_mst_row.attribute29
1330: , x_ic_jrnl_mst_row.attribute30
1331: , x_ic_jrnl_mst_row.attribute_category
1332: );
1333: END IF;
1334: GMIGUTL.DB_ERRNUM := NULL;
1335: RETURN TRUE;

Line 1348: END ic_jrnl_mst_insert;

1344:
1345: GMIGUTL.DB_ERRNUM := SQLCODE;
1346: GMIGUTL.DB_ERRMSG:= SQLERRM;
1347: RETURN FALSE;
1348: END ic_jrnl_mst_insert;
1349:
1350: FUNCTION ic_jrnl_mst_select
1351: (p_ic_jrnl_mst_row IN ic_jrnl_mst%ROWTYPE, x_ic_jrnl_mst_row IN OUT NOCOPY ic_jrnl_mst%ROWTYPE)
1352: RETURN BOOLEAN

Line 1350: FUNCTION ic_jrnl_mst_select

1346: GMIGUTL.DB_ERRMSG:= SQLERRM;
1347: RETURN FALSE;
1348: END ic_jrnl_mst_insert;
1349:
1350: FUNCTION ic_jrnl_mst_select
1351: (p_ic_jrnl_mst_row IN ic_jrnl_mst%ROWTYPE, x_ic_jrnl_mst_row IN OUT NOCOPY ic_jrnl_mst%ROWTYPE)
1352: RETURN BOOLEAN
1353: IS
1354: BEGIN

Line 1351: (p_ic_jrnl_mst_row IN ic_jrnl_mst%ROWTYPE, x_ic_jrnl_mst_row IN OUT NOCOPY ic_jrnl_mst%ROWTYPE)

1347: RETURN FALSE;
1348: END ic_jrnl_mst_insert;
1349:
1350: FUNCTION ic_jrnl_mst_select
1351: (p_ic_jrnl_mst_row IN ic_jrnl_mst%ROWTYPE, x_ic_jrnl_mst_row IN OUT NOCOPY ic_jrnl_mst%ROWTYPE)
1352: RETURN BOOLEAN
1353: IS
1354: BEGIN
1355:

Line 1356: IF p_ic_jrnl_mst_row.journal_no IS NOT NULL AND

1352: RETURN BOOLEAN
1353: IS
1354: BEGIN
1355:
1356: IF p_ic_jrnl_mst_row.journal_no IS NOT NULL AND
1357: p_ic_jrnl_mst_row.orgn_code IS NOT NULL
1358: THEN
1359: SELECT * INTO x_ic_jrnl_mst_row FROM ic_jrnl_mst
1360: WHERE orgn_code = p_ic_jrnl_mst_row.orgn_code AND

Line 1357: p_ic_jrnl_mst_row.orgn_code IS NOT NULL

1353: IS
1354: BEGIN
1355:
1356: IF p_ic_jrnl_mst_row.journal_no IS NOT NULL AND
1357: p_ic_jrnl_mst_row.orgn_code IS NOT NULL
1358: THEN
1359: SELECT * INTO x_ic_jrnl_mst_row FROM ic_jrnl_mst
1360: WHERE orgn_code = p_ic_jrnl_mst_row.orgn_code AND
1361: journal_no = p_ic_jrnl_mst_row.journal_no;

Line 1359: SELECT * INTO x_ic_jrnl_mst_row FROM ic_jrnl_mst

1355:
1356: IF p_ic_jrnl_mst_row.journal_no IS NOT NULL AND
1357: p_ic_jrnl_mst_row.orgn_code IS NOT NULL
1358: THEN
1359: SELECT * INTO x_ic_jrnl_mst_row FROM ic_jrnl_mst
1360: WHERE orgn_code = p_ic_jrnl_mst_row.orgn_code AND
1361: journal_no = p_ic_jrnl_mst_row.journal_no;
1362: ELSE
1363: SELECT * INTO x_ic_jrnl_mst_row FROM ic_jrnl_mst

Line 1360: WHERE orgn_code = p_ic_jrnl_mst_row.orgn_code AND

1356: IF p_ic_jrnl_mst_row.journal_no IS NOT NULL AND
1357: p_ic_jrnl_mst_row.orgn_code IS NOT NULL
1358: THEN
1359: SELECT * INTO x_ic_jrnl_mst_row FROM ic_jrnl_mst
1360: WHERE orgn_code = p_ic_jrnl_mst_row.orgn_code AND
1361: journal_no = p_ic_jrnl_mst_row.journal_no;
1362: ELSE
1363: SELECT * INTO x_ic_jrnl_mst_row FROM ic_jrnl_mst
1364: WHERE journal_id = p_ic_jrnl_mst_row.journal_id;

Line 1361: journal_no = p_ic_jrnl_mst_row.journal_no;

1357: p_ic_jrnl_mst_row.orgn_code IS NOT NULL
1358: THEN
1359: SELECT * INTO x_ic_jrnl_mst_row FROM ic_jrnl_mst
1360: WHERE orgn_code = p_ic_jrnl_mst_row.orgn_code AND
1361: journal_no = p_ic_jrnl_mst_row.journal_no;
1362: ELSE
1363: SELECT * INTO x_ic_jrnl_mst_row FROM ic_jrnl_mst
1364: WHERE journal_id = p_ic_jrnl_mst_row.journal_id;
1365: END IF;

Line 1363: SELECT * INTO x_ic_jrnl_mst_row FROM ic_jrnl_mst

1359: SELECT * INTO x_ic_jrnl_mst_row FROM ic_jrnl_mst
1360: WHERE orgn_code = p_ic_jrnl_mst_row.orgn_code AND
1361: journal_no = p_ic_jrnl_mst_row.journal_no;
1362: ELSE
1363: SELECT * INTO x_ic_jrnl_mst_row FROM ic_jrnl_mst
1364: WHERE journal_id = p_ic_jrnl_mst_row.journal_id;
1365: END IF;
1366: GMIGUTL.DB_ERRNUM := NULL;
1367: RETURN TRUE;

Line 1364: WHERE journal_id = p_ic_jrnl_mst_row.journal_id;

1360: WHERE orgn_code = p_ic_jrnl_mst_row.orgn_code AND
1361: journal_no = p_ic_jrnl_mst_row.journal_no;
1362: ELSE
1363: SELECT * INTO x_ic_jrnl_mst_row FROM ic_jrnl_mst
1364: WHERE journal_id = p_ic_jrnl_mst_row.journal_id;
1365: END IF;
1366: GMIGUTL.DB_ERRNUM := NULL;
1367: RETURN TRUE;
1368:

Line 1389: END ic_jrnl_mst_select;

1385:
1386: GMIGUTL.DB_ERRNUM := SQLCODE;
1387: GMIGUTL.DB_ERRMSG:= SQLERRM;
1388: RETURN FALSE;
1389: END ic_jrnl_mst_select;
1390:
1391: FUNCTION ic_adjs_jnl_insert
1392: (p_ic_adjs_jnl_row IN ic_adjs_jnl%ROWTYPE, x_ic_adjs_jnl_row IN OUT NOCOPY ic_adjs_jnl%ROWTYPE)
1393: RETURN BOOLEAN