DBA Data[Home] [Help]

APPS.QP_QP_FORM_LIMIT_BALANCES dependencies on QP_LIMIT_BALANCES_UTIL

Line 200: l_LIMIT_BALANCES_val_rec := QP_Limit_Balances_Util.Get_Values

196: x_reserved_amount := l_x_LIMIT_BALANCES_rec.reserved_amount;
197:
198: -- Load display out parameters if any
199:
200: l_LIMIT_BALANCES_val_rec := QP_Limit_Balances_Util.Get_Values
201: ( p_LIMIT_BALANCES_rec => l_x_LIMIT_BALANCES_rec
202: );
203: x_limit_balance := l_LIMIT_BALANCES_val_rec.limit_balance;
204: x_limit := l_LIMIT_BALANCES_val_rec.limit;

Line 374: IF p_attr_id = QP_Limit_Balances_Util.G_AVAILABLE_AMOUNT THEN

370: );
371:
372: l_old_LIMIT_BALANCES_rec := l_LIMIT_BALANCES_rec;
373:
374: IF p_attr_id = QP_Limit_Balances_Util.G_AVAILABLE_AMOUNT THEN
375: l_LIMIT_BALANCES_rec.available_amount := TO_NUMBER(p_attr_value);
376: ELSIF p_attr_id = QP_Limit_Balances_Util.G_CONSUMED_AMOUNT THEN
377: l_LIMIT_BALANCES_rec.consumed_amount := TO_NUMBER(p_attr_value);
378: ELSIF p_attr_id = QP_Limit_Balances_Util.G_LIMIT_BALANCE THEN

Line 376: ELSIF p_attr_id = QP_Limit_Balances_Util.G_CONSUMED_AMOUNT THEN

372: l_old_LIMIT_BALANCES_rec := l_LIMIT_BALANCES_rec;
373:
374: IF p_attr_id = QP_Limit_Balances_Util.G_AVAILABLE_AMOUNT THEN
375: l_LIMIT_BALANCES_rec.available_amount := TO_NUMBER(p_attr_value);
376: ELSIF p_attr_id = QP_Limit_Balances_Util.G_CONSUMED_AMOUNT THEN
377: l_LIMIT_BALANCES_rec.consumed_amount := TO_NUMBER(p_attr_value);
378: ELSIF p_attr_id = QP_Limit_Balances_Util.G_LIMIT_BALANCE THEN
379: l_LIMIT_BALANCES_rec.limit_balance_id := TO_NUMBER(p_attr_value);
380: ELSIF p_attr_id = QP_Limit_Balances_Util.G_LIMIT THEN

Line 378: ELSIF p_attr_id = QP_Limit_Balances_Util.G_LIMIT_BALANCE THEN

374: IF p_attr_id = QP_Limit_Balances_Util.G_AVAILABLE_AMOUNT THEN
375: l_LIMIT_BALANCES_rec.available_amount := TO_NUMBER(p_attr_value);
376: ELSIF p_attr_id = QP_Limit_Balances_Util.G_CONSUMED_AMOUNT THEN
377: l_LIMIT_BALANCES_rec.consumed_amount := TO_NUMBER(p_attr_value);
378: ELSIF p_attr_id = QP_Limit_Balances_Util.G_LIMIT_BALANCE THEN
379: l_LIMIT_BALANCES_rec.limit_balance_id := TO_NUMBER(p_attr_value);
380: ELSIF p_attr_id = QP_Limit_Balances_Util.G_LIMIT THEN
381: l_LIMIT_BALANCES_rec.limit_id := TO_NUMBER(p_attr_value);
382: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR1_TYPE THEN

Line 380: ELSIF p_attr_id = QP_Limit_Balances_Util.G_LIMIT THEN

376: ELSIF p_attr_id = QP_Limit_Balances_Util.G_CONSUMED_AMOUNT THEN
377: l_LIMIT_BALANCES_rec.consumed_amount := TO_NUMBER(p_attr_value);
378: ELSIF p_attr_id = QP_Limit_Balances_Util.G_LIMIT_BALANCE THEN
379: l_LIMIT_BALANCES_rec.limit_balance_id := TO_NUMBER(p_attr_value);
380: ELSIF p_attr_id = QP_Limit_Balances_Util.G_LIMIT THEN
381: l_LIMIT_BALANCES_rec.limit_id := TO_NUMBER(p_attr_value);
382: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR1_TYPE THEN
383: l_LIMIT_BALANCES_rec.multival_attr1_type := p_attr_value;
384: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR1_CONTEXT THEN

Line 382: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR1_TYPE THEN

378: ELSIF p_attr_id = QP_Limit_Balances_Util.G_LIMIT_BALANCE THEN
379: l_LIMIT_BALANCES_rec.limit_balance_id := TO_NUMBER(p_attr_value);
380: ELSIF p_attr_id = QP_Limit_Balances_Util.G_LIMIT THEN
381: l_LIMIT_BALANCES_rec.limit_id := TO_NUMBER(p_attr_value);
382: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR1_TYPE THEN
383: l_LIMIT_BALANCES_rec.multival_attr1_type := p_attr_value;
384: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR1_CONTEXT THEN
385: l_LIMIT_BALANCES_rec.multival_attr1_context := p_attr_value;
386: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTRIBUTE1 THEN

Line 384: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR1_CONTEXT THEN

380: ELSIF p_attr_id = QP_Limit_Balances_Util.G_LIMIT THEN
381: l_LIMIT_BALANCES_rec.limit_id := TO_NUMBER(p_attr_value);
382: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR1_TYPE THEN
383: l_LIMIT_BALANCES_rec.multival_attr1_type := p_attr_value;
384: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR1_CONTEXT THEN
385: l_LIMIT_BALANCES_rec.multival_attr1_context := p_attr_value;
386: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTRIBUTE1 THEN
387: l_LIMIT_BALANCES_rec.multival_attribute1 := p_attr_value;
388: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR1_VALUE THEN

Line 386: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTRIBUTE1 THEN

382: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR1_TYPE THEN
383: l_LIMIT_BALANCES_rec.multival_attr1_type := p_attr_value;
384: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR1_CONTEXT THEN
385: l_LIMIT_BALANCES_rec.multival_attr1_context := p_attr_value;
386: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTRIBUTE1 THEN
387: l_LIMIT_BALANCES_rec.multival_attribute1 := p_attr_value;
388: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR1_VALUE THEN
389: l_LIMIT_BALANCES_rec.multival_attr1_value := p_attr_value;
390: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR1_DATATYPE THEN

Line 388: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR1_VALUE THEN

384: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR1_CONTEXT THEN
385: l_LIMIT_BALANCES_rec.multival_attr1_context := p_attr_value;
386: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTRIBUTE1 THEN
387: l_LIMIT_BALANCES_rec.multival_attribute1 := p_attr_value;
388: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR1_VALUE THEN
389: l_LIMIT_BALANCES_rec.multival_attr1_value := p_attr_value;
390: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR1_DATATYPE THEN
391: l_LIMIT_BALANCES_rec.multival_attr1_datatype := p_attr_value;
392: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR2_TYPE THEN

Line 390: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR1_DATATYPE THEN

386: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTRIBUTE1 THEN
387: l_LIMIT_BALANCES_rec.multival_attribute1 := p_attr_value;
388: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR1_VALUE THEN
389: l_LIMIT_BALANCES_rec.multival_attr1_value := p_attr_value;
390: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR1_DATATYPE THEN
391: l_LIMIT_BALANCES_rec.multival_attr1_datatype := p_attr_value;
392: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR2_TYPE THEN
393: l_LIMIT_BALANCES_rec.multival_attr2_type := p_attr_value;
394: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR2_CONTEXT THEN

Line 392: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR2_TYPE THEN

388: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR1_VALUE THEN
389: l_LIMIT_BALANCES_rec.multival_attr1_value := p_attr_value;
390: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR1_DATATYPE THEN
391: l_LIMIT_BALANCES_rec.multival_attr1_datatype := p_attr_value;
392: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR2_TYPE THEN
393: l_LIMIT_BALANCES_rec.multival_attr2_type := p_attr_value;
394: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR2_CONTEXT THEN
395: l_LIMIT_BALANCES_rec.multival_attr2_context := p_attr_value;
396: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTRIBUTE2 THEN

Line 394: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR2_CONTEXT THEN

390: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR1_DATATYPE THEN
391: l_LIMIT_BALANCES_rec.multival_attr1_datatype := p_attr_value;
392: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR2_TYPE THEN
393: l_LIMIT_BALANCES_rec.multival_attr2_type := p_attr_value;
394: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR2_CONTEXT THEN
395: l_LIMIT_BALANCES_rec.multival_attr2_context := p_attr_value;
396: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTRIBUTE2 THEN
397: l_LIMIT_BALANCES_rec.multival_attribute2 := p_attr_value;
398: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR2_VALUE THEN

Line 396: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTRIBUTE2 THEN

392: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR2_TYPE THEN
393: l_LIMIT_BALANCES_rec.multival_attr2_type := p_attr_value;
394: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR2_CONTEXT THEN
395: l_LIMIT_BALANCES_rec.multival_attr2_context := p_attr_value;
396: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTRIBUTE2 THEN
397: l_LIMIT_BALANCES_rec.multival_attribute2 := p_attr_value;
398: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR2_VALUE THEN
399: l_LIMIT_BALANCES_rec.multival_attr2_value := p_attr_value;
400: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR2_DATATYPE THEN

Line 398: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR2_VALUE THEN

394: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR2_CONTEXT THEN
395: l_LIMIT_BALANCES_rec.multival_attr2_context := p_attr_value;
396: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTRIBUTE2 THEN
397: l_LIMIT_BALANCES_rec.multival_attribute2 := p_attr_value;
398: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR2_VALUE THEN
399: l_LIMIT_BALANCES_rec.multival_attr2_value := p_attr_value;
400: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR2_DATATYPE THEN
401: l_LIMIT_BALANCES_rec.multival_attr2_datatype := p_attr_value;
402: ELSIF p_attr_id = QP_Limit_Balances_Util.G_ORGANIZATION_ATTR_CONTEXT THEN

Line 400: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR2_DATATYPE THEN

396: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTRIBUTE2 THEN
397: l_LIMIT_BALANCES_rec.multival_attribute2 := p_attr_value;
398: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR2_VALUE THEN
399: l_LIMIT_BALANCES_rec.multival_attr2_value := p_attr_value;
400: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR2_DATATYPE THEN
401: l_LIMIT_BALANCES_rec.multival_attr2_datatype := p_attr_value;
402: ELSIF p_attr_id = QP_Limit_Balances_Util.G_ORGANIZATION_ATTR_CONTEXT THEN
403: l_LIMIT_BALANCES_rec.organization_attr_context := p_attr_value;
404: ELSIF p_attr_id = QP_Limit_Balances_Util.G_ORGANIZATION_ATTRIBUTE THEN

Line 402: ELSIF p_attr_id = QP_Limit_Balances_Util.G_ORGANIZATION_ATTR_CONTEXT THEN

398: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR2_VALUE THEN
399: l_LIMIT_BALANCES_rec.multival_attr2_value := p_attr_value;
400: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR2_DATATYPE THEN
401: l_LIMIT_BALANCES_rec.multival_attr2_datatype := p_attr_value;
402: ELSIF p_attr_id = QP_Limit_Balances_Util.G_ORGANIZATION_ATTR_CONTEXT THEN
403: l_LIMIT_BALANCES_rec.organization_attr_context := p_attr_value;
404: ELSIF p_attr_id = QP_Limit_Balances_Util.G_ORGANIZATION_ATTRIBUTE THEN
405: l_LIMIT_BALANCES_rec.organization_attribute := p_attr_value;
406: ELSIF p_attr_id = QP_Limit_Balances_Util.G_ORGANIZATION_ATTR_VALUE THEN

Line 404: ELSIF p_attr_id = QP_Limit_Balances_Util.G_ORGANIZATION_ATTRIBUTE THEN

400: ELSIF p_attr_id = QP_Limit_Balances_Util.G_MULTIVAL_ATTR2_DATATYPE THEN
401: l_LIMIT_BALANCES_rec.multival_attr2_datatype := p_attr_value;
402: ELSIF p_attr_id = QP_Limit_Balances_Util.G_ORGANIZATION_ATTR_CONTEXT THEN
403: l_LIMIT_BALANCES_rec.organization_attr_context := p_attr_value;
404: ELSIF p_attr_id = QP_Limit_Balances_Util.G_ORGANIZATION_ATTRIBUTE THEN
405: l_LIMIT_BALANCES_rec.organization_attribute := p_attr_value;
406: ELSIF p_attr_id = QP_Limit_Balances_Util.G_ORGANIZATION_ATTR_VALUE THEN
407: l_LIMIT_BALANCES_rec.organization_attr_value := p_attr_value;
408: ELSIF p_attr_id = QP_Limit_Balances_Util.G_RESERVED_AMOUNT THEN

Line 406: ELSIF p_attr_id = QP_Limit_Balances_Util.G_ORGANIZATION_ATTR_VALUE THEN

402: ELSIF p_attr_id = QP_Limit_Balances_Util.G_ORGANIZATION_ATTR_CONTEXT THEN
403: l_LIMIT_BALANCES_rec.organization_attr_context := p_attr_value;
404: ELSIF p_attr_id = QP_Limit_Balances_Util.G_ORGANIZATION_ATTRIBUTE THEN
405: l_LIMIT_BALANCES_rec.organization_attribute := p_attr_value;
406: ELSIF p_attr_id = QP_Limit_Balances_Util.G_ORGANIZATION_ATTR_VALUE THEN
407: l_LIMIT_BALANCES_rec.organization_attr_value := p_attr_value;
408: ELSIF p_attr_id = QP_Limit_Balances_Util.G_RESERVED_AMOUNT THEN
409: l_LIMIT_BALANCES_rec.reserved_amount := TO_NUMBER(p_attr_value);
410: ELSIF p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE1

Line 408: ELSIF p_attr_id = QP_Limit_Balances_Util.G_RESERVED_AMOUNT THEN

404: ELSIF p_attr_id = QP_Limit_Balances_Util.G_ORGANIZATION_ATTRIBUTE THEN
405: l_LIMIT_BALANCES_rec.organization_attribute := p_attr_value;
406: ELSIF p_attr_id = QP_Limit_Balances_Util.G_ORGANIZATION_ATTR_VALUE THEN
407: l_LIMIT_BALANCES_rec.organization_attr_value := p_attr_value;
408: ELSIF p_attr_id = QP_Limit_Balances_Util.G_RESERVED_AMOUNT THEN
409: l_LIMIT_BALANCES_rec.reserved_amount := TO_NUMBER(p_attr_value);
410: ELSIF p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE1
411: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE10
412: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE11

Line 410: ELSIF p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE1

406: ELSIF p_attr_id = QP_Limit_Balances_Util.G_ORGANIZATION_ATTR_VALUE THEN
407: l_LIMIT_BALANCES_rec.organization_attr_value := p_attr_value;
408: ELSIF p_attr_id = QP_Limit_Balances_Util.G_RESERVED_AMOUNT THEN
409: l_LIMIT_BALANCES_rec.reserved_amount := TO_NUMBER(p_attr_value);
410: ELSIF p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE1
411: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE10
412: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE11
413: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE12
414: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE13

Line 411: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE10

407: l_LIMIT_BALANCES_rec.organization_attr_value := p_attr_value;
408: ELSIF p_attr_id = QP_Limit_Balances_Util.G_RESERVED_AMOUNT THEN
409: l_LIMIT_BALANCES_rec.reserved_amount := TO_NUMBER(p_attr_value);
410: ELSIF p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE1
411: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE10
412: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE11
413: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE12
414: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE13
415: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE14

Line 412: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE11

408: ELSIF p_attr_id = QP_Limit_Balances_Util.G_RESERVED_AMOUNT THEN
409: l_LIMIT_BALANCES_rec.reserved_amount := TO_NUMBER(p_attr_value);
410: ELSIF p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE1
411: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE10
412: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE11
413: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE12
414: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE13
415: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE14
416: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE15

Line 413: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE12

409: l_LIMIT_BALANCES_rec.reserved_amount := TO_NUMBER(p_attr_value);
410: ELSIF p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE1
411: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE10
412: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE11
413: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE12
414: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE13
415: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE14
416: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE15
417: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE2

Line 414: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE13

410: ELSIF p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE1
411: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE10
412: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE11
413: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE12
414: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE13
415: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE14
416: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE15
417: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE2
418: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE3

Line 415: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE14

411: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE10
412: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE11
413: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE12
414: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE13
415: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE14
416: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE15
417: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE2
418: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE3
419: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE4

Line 416: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE15

412: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE11
413: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE12
414: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE13
415: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE14
416: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE15
417: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE2
418: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE3
419: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE4
420: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE5

Line 417: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE2

413: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE12
414: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE13
415: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE14
416: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE15
417: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE2
418: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE3
419: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE4
420: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE5
421: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE6

Line 418: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE3

414: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE13
415: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE14
416: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE15
417: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE2
418: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE3
419: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE4
420: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE5
421: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE6
422: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE7

Line 419: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE4

415: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE14
416: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE15
417: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE2
418: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE3
419: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE4
420: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE5
421: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE6
422: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE7
423: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE8

Line 420: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE5

416: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE15
417: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE2
418: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE3
419: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE4
420: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE5
421: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE6
422: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE7
423: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE8
424: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE9

Line 421: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE6

417: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE2
418: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE3
419: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE4
420: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE5
421: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE6
422: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE7
423: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE8
424: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE9
425: OR p_attr_id = QP_Limit_Balances_Util.G_CONTEXT

Line 422: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE7

418: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE3
419: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE4
420: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE5
421: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE6
422: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE7
423: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE8
424: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE9
425: OR p_attr_id = QP_Limit_Balances_Util.G_CONTEXT
426: THEN

Line 423: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE8

419: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE4
420: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE5
421: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE6
422: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE7
423: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE8
424: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE9
425: OR p_attr_id = QP_Limit_Balances_Util.G_CONTEXT
426: THEN
427:

Line 424: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE9

420: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE5
421: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE6
422: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE7
423: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE8
424: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE9
425: OR p_attr_id = QP_Limit_Balances_Util.G_CONTEXT
426: THEN
427:
428: l_LIMIT_BALANCES_rec.attribute1 := p_attribute1;

Line 425: OR p_attr_id = QP_Limit_Balances_Util.G_CONTEXT

421: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE6
422: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE7
423: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE8
424: OR p_attr_id = QP_Limit_Balances_Util.G_ATTRIBUTE9
425: OR p_attr_id = QP_Limit_Balances_Util.G_CONTEXT
426: THEN
427:
428: l_LIMIT_BALANCES_rec.attribute1 := p_attribute1;
429: l_LIMIT_BALANCES_rec.attribute10 := p_attribute10;

Line 544: l_LIMIT_BALANCES_val_rec := QP_Limit_Balances_Util.Get_Values

540: x_limit := FND_API.G_MISS_CHAR;
541:
542: -- Load display out parameters if any
543:
544: l_LIMIT_BALANCES_val_rec := QP_Limit_Balances_Util.Get_Values
545: ( p_LIMIT_BALANCES_rec => l_x_LIMIT_BALANCES_rec
546: , p_old_LIMIT_BALANCES_rec => l_LIMIT_BALANCES_rec
547: );
548:

Line 1442: g_LIMIT_BALANCES_rec := QP_Limit_Balances_Util.Query_Row

1438: THEN
1439:
1440: -- Query row from DB
1441:
1442: g_LIMIT_BALANCES_rec := QP_Limit_Balances_Util.Query_Row
1443: ( p_limit_balance_id => p_limit_balance_id
1444: );
1445:
1446: g_LIMIT_BALANCES_rec.db_flag := FND_API.G_TRUE;